Table updates outside the GUI

[Rob Lindsey]

CL 5.8 on AIX 6.1

I am working on a system that has a lot of table updates done manually and I would like to convert those over to an automated script.  The issue that I am running into is that the version of the tables is now version 4.0 and I have code that works with the version 3.0 table formats.

The main difference is the Prolog statements the default and revdefault lines and the encoding lines.

The tools that I have used in the past TioSave, TioLoad, TioUpdateData, and TioGetValueLists.  Everything works fine except for the TioSave which defaults to version 3.0.  All of the Encoding lines are missing from the updated table.

Does anyone know of a different PROC that I can use to get version 4.0 info into the table?

Thanks in Advance.

Rob Lindsey

Topic

[Jim Kosloskey]

Rob,

We wrote our own table builder proc that does not rely on the unsupported internal functions. That way we can easily make a change.

For Tables the file format is not very complex.

However, beginning with 5.8 there is the ability to encrypt the table and so we may need to re-engineer for that.

Our proc uses a delimited file (usually CSV) that is exported from either a spreadsheet or a DB as input. The entire Table is rebuilt each time.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Rob Lindsey]

Yes I agreee that the Table format is simple.  

I was just trying to use the built in functions (which actually does do locking).

I am trying to do the same thing with CSV files but I am giving the ability to Add, Change, or Delete entries instead of rebuilding the entire table.  I had one written years ago but again it was for the older version and does not handle the encoding stuff.

[Author]

Replies