RE: SQL Retrieve in iNav

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.