RE: SQL Retrieve in iNav

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

x'0D' is carriage return in both ASCII and EBCDIC. x'25' is EBCDIC 
for line feed - same as x'0A' in ASCII.

The underline and reverse image only applies to displays - if you 
were to have the script in a PF and use DSPPFM, you'd see the result 
of that value displayed. IIRC.

The file generated by this can be FTP'd to the iSeries - or put in 
the IFS and copied with CPYFRMSTMF or CPYFRMIMPF - one or another of 
these will strip the CRLF when going to a physical file.

HTH
Vern

At 07:55 PM 5/24/2007, you wrote:

> <snip>
> So I used iNav's "Generate SQL..." in the Databases node.  All well and
> goodness, but there's something that's irritating me about it.  The
> source member that it creates has x'0D' x'25' at the conclusion of every
>
> line.  I have no idea what x'0D' means, but x'25' is underline and
> reverse image.
> </snip>
>
> I have run into same problem. What you are seeing is ASCII Carriage
> Return, Line Feeds. Every line in a text file has a <CR><LF> at the end
> and IBM is not clearing them out when they write to the AS/400. IBM bug
> of some kind.
>
> I end up having to manually clean up each time that I generate the
> source.
>
> Never have contacted IBM about this.
>
> Congratulations on going to DDL. I really like the create table wizard.
> Make sure you are at Client Access V5R4. Unfortunately, my boss won't
> let me create new table with DDL except in utilities. I create all my
> tables through the DDL and then use DBU to extract the DDS to create the
> table. Means I don't have to manually enter DDS which I hate.
>
>
> --
> 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.