Claudine,
Here are a few examples that will provide you with desired results,
as well as the alignment.
-- Example 01
CONNECT RRBYW18
SET HEADINGS OFF
SET LINES 0
SET SELMARGIN 1
SET EOFCHAR OFF
OUTPUT CustomerList.txt
SELECT Company FROM Customer WHERE CustState = 'WA' ORDER BY Company
OUTPUT SCREEN
SET HEADINGS ON
SET LINES 19
SET SELMARGIN 0
SET EOFCHAR ON
LAUNCH CustomerList.txt
-- Example_02
CONNECT RRBYW18
SET HEADINGS OFF
SET LINES 0
SET SELMARGIN 1
SET EOFCHAR OFF
OUTPUT CustomerList.txt
SELECT (TRIM(CTXT(CustID)))=6,Company FROM Customer WHERE
CustState = 'WA' ORDER BY Company
OUTPUT SCREEN
SET HEADINGS ON
SET LINES 19
SET SELMARGIN 0
SET EOFCHAR ON
LAUNCH CustomerList.txt
Feel free to reach out to me if you need examples of more complex scenarios.
Very Best R:egards,
Razzak
At 02:08 PM 1/24/2017, Claudine Robbins wrote:
Hello,
In the case of SELECTing to a .txt file, how would you suppress the caption:
custid and company in the following example?
OUTPUT file.txt
SELECT custid, company FROM customer +
WHERE custstate = 'WA' ORDER BY company
OUTPUT SCREEN
custid company
122 Data Solutions
119 Datacrafters Infosystems
130 MIS by Design
114 Softech Database Design
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
