Manage

The manage step provides data management functionality for your application and/or process.

Below is the code for Manage():

-- Manage

ECHO MANAGE;

ECHO Delete records...;

DELETE FROM custmast;

ECHO Add records...;

INSERT INTO custmast VALUES ('1000', '92867', 'CA', '1', 'Bryan Williams', '2999 Regency', 'Orange');

INSERT INTO custmast VALUES ('1001', '61434', 'CT', '1', 'Michael Jordan', '13 Main', 'Harford');

INSERT INTO custmast VALUES ('1002', '73677', 'GA', '1', 'Joshua Brown', '4356 Cambridge', 'Atlanta');

INSERT INTO custmast VALUES ('1003', '10034', 'MO', '1', 'Keyon Dooling', '19771 Park Avenue', 'Columbia');

ECHO Display records...;

SELECT cm_custnumb "Number", cm_custname "Name" FROM custmast;

ECHO Delete records...;

DELETE FROM custmast;