Re: SQL Labels

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.