Re: SQL Labels

[daparnin@xxxxxxxxxxxxxx]

Thanks Jerry, Charles, and Scott!  That worked!  It looks like I can even
center the words by adjusting the spaces before and after each word.  I
learn more things from the people on this list.  Thanks again.


Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx




                                                                                
                                                          
                      Jerry Adams                                               
                                                          
                      <jerry@xxxxxxxxxxxxx        To:       Midrange Systems 
Technical Discussion <midrange-l@xxxxxxxxxxxx>               
                      om>                         cc:                           
                                                          
                      Sent by:                    Subject:  Re: SQL Labels      
                                                          
                      midrange-l-bounces@m                                      
                                                          
                      idrange.com                                               
                                                          
                                                                                
                                                          
                                                                                
                                                          
                      07/12/2006 09:58 AM                                       
                                                          
                      Please respond to                                         
                                                          
                      Midrange Systems                                          
                                                          
                      Technical Discussion                                      
                                                          
                                                                                
                                                          




The space for each line must be, IIRC, 20 characters.

Thus, 'Transaction(+9 spaces) Type'.

 * Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
 615.995.7024
fax
 615.995.1201
email
 jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



daparnin@xxxxxxxxxxxxxx wrote:

> Good morning all,
>
> In the past few months I've gotten into the habit of creating files with
> SQL instead of DDS.  Today I was working on one and couldn't figure out
how
> to break a label so that the words appear above each other instead of side
> by side when a query is done on the file.  I'm currently doing the
> following:
>
> LABEL ON COLUMN DPWORK/STATEMNT (STTRNT is 'Transaction Type')
>
> I would like it to appear as:
> Transaction
> Type
>
> instead of :
> Transaction Type
>
> Any suggestions would be appreciated.
>
>
> Dave Parnin
> --
> Nishikawa Standard Company
> Topeka, IN  46571
> daparnin@xxxxxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.