Yes, it something different on the way IBM deals with CCSID. The CCSID of the field (if not specified in the CPYTOIMPF command) gets not converted if the src DB field has neutral CCSID (65535) (it did on v5r2). I'm still investigating, I'll let you know when fixed.
Corrado -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, 16 January, 2006 10:47 To: [email protected] Subject: RE: [Easy400Group] Problem with RUNEXCEL on V5R3 i'm not an expert. is this something to do with ccsid? perhaps look at the ccsid of the field in the file you are copying from and the ccsid of the file in QDLS. or look at your continuing use of qdls? (isn't that outmoded?) if you copy the file to /usr/mydir/xxxxx do you get the same results. has your system default value of ccsid changed as you moved to 5.3 Regards, Mike "Corrado Vallino" <[EMAIL PROTECTED] > To Sent by: <[email protected]> [EMAIL PROTECTED] cc ogroups.com Subject RE: [Easy400Group] Problem with 16/01/2006 08:04 RUNEXCEL on V5R3 Please respond to [EMAIL PROTECTED] ogroups.com 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] 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 |Received Qty|Scrap |Close Dt |Component |Req |Issued | | | |Qty | |Qty | |Part |Qty |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 Visit your group "Easy400Group" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- This message is intended for the use of the addressee and may contain information that is privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of the information contained in this message is strictly unauthorized and prohibited. If you have received this message in error, please notify the sender by reply e-mail and delete the message from your system. Opinions, conclusions, or other statements in this message which do not relate to the business of Coty Inc.,its subsidiaries or affiliates, are neither given nor endorsed by Coty Inc. Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Easy400Group/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
