Reader Feedback and Insights:

September 27, 2002 Timothy Prickett Morgan

Hey, Ted:

I find your Web site and the information stored there more and more useful. Today, somebody I know was having trouble with data being truncated on FTP. Overhearing this triggered me to find the Midrange Guru article where you were discussing “locsite trim 0.” I went to the Midrange Guru Web site, found the article, and passed it on to the person in need of the information. It worked.

I just thought I would pass that information along.

Keep up the good work.

— Darrell

Sponsored By ADVANCED SYSTEMS CONCEPTS

SEQUEL meets all your iSeries and AS/400 data

Loading a Tilde-Delimited File into the Database

September 27, 2002 Timothy Prickett Morgan

Hey, Ted:

I received via an e-mail attachment a file that did not contain any sort of CR/LF record separators, although the stream of information did have tilde characters (~) between each logical record.

So I tried to use Copy from Import File (CPYFRMIMPF) command to upload it to a 96-byte single-field “catch” file, specifying the tilde character as the RCDDLM (record delimiter), but OS/400 says this isn’t allowed.  Do you have any suggestions?

— Bill

Since you’re using CPYFRMIMPF, I take it the file is in the IFS. Use Qshell’s stream editor, sed, to convert the tilde characters to

Find the Cursor Position in a CL Program

September 27, 2002 Timothy Prickett Morgan

Hey, Howard:

At my shop, we have field on-line help in our RPG programs that allows the user to place the cursor on a field, then press F1 and get help for that field. The RPG passes row and column data to the help text program to accomplish this. Is there way to capture row and column in a CL program to accomplish the same thing? Currently, we get a help text-screen that covers the entire screen, not just the field that the cursor is on.

— Larry

My friend Holley Davis can help you with this one, Larry. Here’s