SQL and System/36 File Names

Hey, Ted:

Is it possible for interactive SQL to access a file whose name contains a period (.)?

-- John

READ MORE >

Using Timestamps as Unique Keys

Hey, Ted:

We need to generate unique keys for each record written to a file and thought that the timestamp would make a good unique key for a file. Then we ran into a problem. The RPG TIME op code fills in only the first three digits of the microseconds portion of a timestamp field. The last three digits are always zeros.

-- Michael

READ MORE >

Reader Feedback and Insights: Dealing with Record Locks

It's been over a year, but I had a batch job that would run into a record lock problem. If it encountered a record lock, it would retrieve the job name and send a break message to that device (all problems were caused by interactive jobs) asking the user to release the record being updated (back out of the update screen).

-- Mike