SQL – Data definition

Create a table

CREATE TABLE mylib/workfile           
   (company numeric(4, 0),                  
    account numeric(10, 0),                 
    balance numeric(10, 2),         

    PRIMARY KEY(company,               
                account)               
   );

Delete a table

DROP TABLE mylib/workfile;

 

Change the field description

LABEL ON COLUMN workfile.icbal IS 'Balance';