I have the following SQL*Plus query (executed via a Cobol program) that I'd like to output to a Table:
REPHEADER CENTER 'CUSTOMER NAME AND ADDRESS' SKIP2
COLUMN CLIENT_ID HEADING 'CUSTOMER #'
COLUMN CUST_NAME HEADING 'CUSTOMER NAME'
COLUMN ADD_1 HEADING 'ADDRESS LINE 1'
COLUMN ADD_2 HEADING 'ADDRESS LINE 2'
COLUMN ADD_3 HEADING 'ADDRESS LINE 3'
SELECT A.CLIENT_ID, A.CUST_NAME, A.ADD_1, A.ADD_2, A.ADD_3
FROM CUSTOMER A
WHERE CUST_TYPE LIKE 'A%'
ORDER BY A.CUST_ID;
Any help would be appreciated - Thanks in advance.
Rick
REPHEADER CENTER 'CUSTOMER NAME AND ADDRESS' SKIP2
COLUMN CLIENT_ID HEADING 'CUSTOMER #'
COLUMN CUST_NAME HEADING 'CUSTOMER NAME'
COLUMN ADD_1 HEADING 'ADDRESS LINE 1'
COLUMN ADD_2 HEADING 'ADDRESS LINE 2'
COLUMN ADD_3 HEADING 'ADDRESS LINE 3'
SELECT A.CLIENT_ID, A.CUST_NAME, A.ADD_1, A.ADD_2, A.ADD_3
FROM CUSTOMER A
WHERE CUST_TYPE LIKE 'A%'
ORDER BY A.CUST_ID;
Any help would be appreciated - Thanks in advance.
Rick