Kbase P19104: How to export data without column headers using SQL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/02/2003 |
|
Status: Unverified
GOAL:
How to export data without column headers using SQL
FIX:
DEFINE VARIABLE iCustNum AS INTEGER NO-UNDO.
DECLARE aCursor CURSOR FOR SELECT DISTINCT CustNum FROM Customer.
OPEN aCursor.
OUTPUT TO SomeFile.txt.
REPEAT:
FETCH aCursor INTO iCustNum.
EXPORT iCustNum.
END.
OUTPUT CLOSE.
CLOSE aCursor.