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
<*> 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/
