Jump to content

Neil Barber

Member Since 17 Sep 2012
Offline Last Active Private

Posts I've Made

In Topic: legacy version of proiv upgrade to access

16 December 2018 - 12:45 AM

Hi again Donald

I negated to mention using the 'SEQ' method. Sorry.

To do so, make a copy of the source Logical File Definition, set that target's File Type as 'SEQ', define its Alternate (the physical file) name and assign its fields a Storage Format, then write an Update function that reads (using 'L'ook mode) the source and writes (using 'B'oth mode) the target.

The advantage of the first method is that it does allow you to insert a literal (delimiter) between fields in the Report Field Definition, notwithstanding those fields being fixed width, but that's a bit more portable. It also means just one additional object and no chance of polluting the Data Dictionary.


In Topic: legacy version of proiv upgrade to access

15 December 2018 - 11:58 PM

Hi Donald

How many source (PRO-ISAM) files do you need to convert and what's the source system, DOS/WIndows, Unix, VMS or mainframe?

You're right in identifying 'SEQ' as a target file type that'll allow you to create an externally organised file that's ASCII encoded, but the source data will still have to be transformed.

The most expedient way is to use a Report function, one for each source file. Include each of the source file's fields in the Report Field Definition. Suppress Headers/Footers. Set the Spooler Options as the physical file you want to write the data to. The output will be sequential. Each field will be fixed width.

If there are a lot of fields in the source file, or a lot of source files, or you require the values tab or comma separated, let me know, I have a Java toolkit that can take care of it.


In Topic: looking for a utility to read filedef and generate csv report

20 May 2018 - 04:36 PM

Hi Rob
Point your browser here and download the contents of "p4dump". Run whichever of "p4dump.bat" or "p4dump.sh" applies to your operating system and it'll display a complete synopsis of the command.
Something like

p4dump.sh -include "(?i)FILEDEF\.PRO" "/fully/qualified/path/to/the/bootstraps"

will be close.

Post process the output to remove the header, footer and far left (byte offset) column, and what you have left is tab separated values, nulls displayed as {null}, both of which you can substitute for whatever you need.

In Topic: alphacom

15 October 2017 - 07:49 PM

Hi Paul
AlphaCom is a SSH/Telnet client, right? If you're on Windows, I'd have a look at AutoHotkey, it's great for this sort of thing; lookup SetTimer, IfWinActive and SetCapsLockState




In Topic: DumpProIsamFile

03 May 2015 - 08:37 AM

Hi Ngoni


The exception is being thrown because the licence, under which this particular variant of the utility is distributed, is standalone, that is, it does not permit embedding in third-party applications; that's why it's free.