RE: [Easy400Group] Problem with RUNEXCEL on V5R3

Mon, 16 Jan 2006 00:11:39 -0800

This is the job log of the cmd after the run:
 
4500 - CPYTOIMPF FROMFILE(VITPQ/ICIISSER *FIRST)                      
TOSTMF('/qdls/mydir/ICIISSER.csv') MBROPT(*ADD) STMFCODPAG(*PCASCII)
RCDDLM(*LF) FLDDLM(';') DECPNT('*PERIOD') DATFMT(*EUR) TIMFMT(*EUR)   
 
The cmd ends normally, without any error. Browsing the file I'm getting the following data in that date field:
"ñöKññKòððõ";
 
 
Corrado
 

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Antoon van Os
Sent: Sunday, 15 January, 2006 11:37
To: [email protected]
Subject: RE: [Easy400Group] Problem with RUNEXCEL on V5R3

Corrado,
The RUNEXCEL command uses IBM's CPYTOSTMF in this way :
CPYTOIMPF FROMFILE(*LIBL/TCILA *FIRST)                    
TOSTMF('/home/output/yourfile.csv') MBROPT(*ADD) STMFCODPAG(*PCASCII)
RCDDLM(*LF) FLDDLM(';') DECPNT('*PERIOD')                        
 
Could you verify this in your joblog; then check the file in the IFS
Hth,
Antoon
 
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of Corrado Vallino
Sent: zaterdag 14 januari 2006 18:42
To: [email protected]
Subject: [Easy400Group] Problem with RUNEXCEL on V5R3

I've completed the migration for my 820 to V5R3 but now the RUNEXCEL command on a query generated date filed (dd/mm/yy format) gives me strange results.
Here an example: On the iSeries the DB file looks like this:
Mfg Order  Status      Ord Qty   Received Qty     Scrap Qty   Close Dt  Component Part          Req Qty       Issued Qty
 BF22443     Z             100             96             4   16/11/05  6431026800                    3                2
 
As you can see the "Close Dt" filed is correct.
 
In the stream file I've:
Mfg Order Status Ord Qty Received Qty Scrap Qty Close Dt Component Part  Req Qty Issued Qty
BF22443 Z 100 96 4 ñöKññKòððõ 6.43E+09 3 2
 
As you can see the Close Dt filed is not correctly converted.
Any help will be appreciated, since this command is widely used in production to generate several stream file conversion.
Thanks
 
Corrado
 
 

YAHOO! GROUPS LINKS



Reply via email to