Re: CPYTOXLS problem converting a field with ip address

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.