Re: CPYTOXLS problem converting a field with ip address

["Fabio Kang" <fabio.kang@xxxxxxxxx>]

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.