RE: [RBASE-L] - No Caption Option for SELECT

Tue, 24 Jan 2017 13:39:48 -0800 

Thank you to everyone who replied.  I knew it was going to be simple and I 
would feel foolish and dumb!

Claudine

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of 
A. Razzak Memon
Sent: Tuesday, January 24, 2017 1:51 PM
To: [email protected]
Subject: Re: [RBASE-L] - No Caption Option for SELECT

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.

-- 
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.

Reply via email to