RE: SQL Retrieve in iNav

<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.