RE: query question

["Mark Walter" <mwalter@xxxxxxxxxxx>]

Something like this:
                              Define Result Fields

 

 Type definitions using field names or constants and operators, press
Enter.    
   Operators:  +, -, *, /, SUBSTR, ||, DATE...

 

 Field       Expression                         Column Heading
Len   Dec 
 DATEA       digits(actdte)

 

 

 

 MONTH       substr(datea,5,2)

 

 

 
Bottom  
 

 Field           Text
Len  Dec 
 SHPAD1          SHIP TO ADDRESS 1
35      
 SHPAD2          SHIP TO ADDRESS 2
35      
 SHPAD3          SHIP TO ADDRESS 3
35      
 SHPSTA          SHIP TO STATE
2      
 
More...   


Mark Walter
Senior Programmer/Analyst
IBM Certified RPG Developer
Hainey Business Systems
(717) 771-2362
mwalter@xxxxxxxxxxx
http://www.hbs-inc.com
 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of steema@xxxxxxxxxxxxx
Sent: Thursday, March 30, 2006 2:55 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: query question

Hi I forget how to parse out a piece of a field. I can use a query
rather than RPG on one assignment but the date is mmddyy. I need to
parse out the year and then the month. I tried looking in the archives
to no avail.
Thanks,
Steve
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.