RE: CPYTOXLS problem converting a field with ip address

Fabio,

That is weird. I'm not familiar with CPYTOXLS, but sounds like the problem is with that, for some reason, the program is unable to convert "correctly" that fields, and I can think of two possible reasons:

1. A CCSID issue.
2. CPYTOXLS is (incorrectly) interpreting that field as a numeric value, and trying to convert it to a numeric field, and generating just gibberish.

Possible solutions:

1. Manually add an apostrophe at the beginning of the field (for instance, 127.0.0.1 should look like '127.0.0.1), and repeat the CPYTOXLS.
2. If that fails, maybe the problem is a CCSID conversion issue. Manually create an intermediate table (let's call it "temp"), and add some dummy data. Then convert that to XLS, and see if that works. If it works, then you may have to copy the journal data to the temp file before you convert to XLS.

I hope that helps.

Luis
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Fabio Kang
Sent: Tuesday, January 29, 2008 9:28 AM
To: Midrange Systems Technical Discussion
Subject: Re: CPYTOXLS problem converting a field with ip address

Hi Luis, it is CHAR length 46.




On 1/29/08, Luis Colorado <LuisC@xxxxxxxxxxxxxxxx> wrote:

Fabio,

What is the type of the field (column) containing the IP address?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Fabio Kang
Sent: Monday, January 28, 2008 3:42 PM
To: midrange-l@xxxxxxxxxxxx
Subject: CPYTOXLS problem converting a field with ip address

Hi Everyone, I am having problem converting one field with ip address
information using the tool CPYTOXLS., which I use and it is great.

I do the following:

1- DSPJRN JRN(QAUDJRN) ENTTYP(PW) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE5)
OUTFILE(mylib/crtdupobj of QASYPWJ5)

2- CPYTOXLS FILE(mylib/crtdupobj of QASYPWJ5) TOFILE(myfile.CSV)
TODIR('/mydir')

Looking the file via SQL I can see the IP address field fine, field name
is
PWRADR (QASYPWJ5 Remote address), but after converting with CPYTOXLS
tool, the field look more like this in excell:
±ÒÓKÒ±KãͱKã±ã@@@@@@@@@@@.

Any help will be appreciate.

Thank you, Fabio
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.