Loading a Tilde-Delimited File into the Database

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

READ MORE >

Find the Cursor Position in a CL Program

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

READ MORE >

Reader Feedback and Insights: Midrange Guru Articles Helpful

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.

-- Darrell