OPNQRYF ???

[Rajani Chebrolu <chebro@xxxxxxxxx>]

Hello All ,
     I have come across a problem with OPNQRYF command.
Problem :

I have 2 files - BFILE, CFILE, both having only one field. BFILE has a
field  "DATE"  which is an L- type. and CFILE has a field "DATE1"
which is  10 char.
in  CL pgm i use -

OPNQRYF   FILE((BFILE))  FORMAT(CFILE)  MAPFLD((DATE1 DATE)) 
IGNDECERR(*YES)  OPNID(QRYFILE)  
                       
CPYFRMQRYF FROMOPNID(QRYFILE) TOFILE(CONDZS/CFILE) +
             MBROPT(*REPLACE) FMTOPT(*DROP *MAP)    

BFILE  has  ISO dates. After running this CL program, CFILE  has  data
 which is  *MDY  of  DATE ( in bfile) with  "/"  as a sep.
ie  if  DATE = 1998-01-02 , then DATE1 is getting a value  01/02/98 .

SOmebody  please  explain me................

I  appreciate all ur help.

thanks in Advance,

bye,
Sreedhar






_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---