4 replies to this topic

[tom braider]

Hi, does anybody know if you can add to a PRO-ISAM file using command line instructions in Unix. You can create a file using 'iscr' but can you add a record?

[Rob Donovan]

Hi,

You can use isout to create an 'out' file from a ProISAM file, and then use isin to read that out file back into a ProISAM file.

A long time ago, when I had to convert a system from P4 1.2 to 1.5, version 1.2 had no isout, I had to write a QucikBasic program that read the ProISAM files and created the out file in the correct format to then be read into 1.5 with isin.

It is possible, but its probably a large amount of work...

I think a company called http://www.Transoft.com produce a ProISAM & CISAM ODBC for use outside ProIV, but I have never looked at it.

What are you trying to do, are once of import of data or something more?

Rob D.

[Rob Donovan]

Oh, and you could take a look at this site http://www.net-aware.com/, cause they have some ProISAM Utilities.

I'm sure Aprile will be along soon, and tell you all about it

Rob.

[Richard Bassett]

Don't know if you have ProIV dev capability and I guess I'm stating the obvious here but..

Provided your ProISAM record contains a limited number of fields and the performance of inserting the new record is relatively unimportant, it is pretty straightforward (on Unix/VMS anyway) to write a ProIV function that picks up command-line arguments for the fields, inserts a single record and then terminates ProIV (links to OFF). You can then invoke that ProIV function from a single-line shell script using transparent logon so it looks like a command-line utility. You can suppress the screen verbiage ProIV will produce by redirecting it to /dev/null or a log or whatever.

HTH.

[Barry Glass]

Bus and task (p4task) could also be used if you create a task and function to add the record. Parameter passing might be a bit easier.

Barry