4 replies to this topic

[Neil Barber]

Hi

Here's a utility that can help any site needing to upgrade to 7.x, whether it's recovering lost file definitions, or searching logic using complex patterns, to identify deprecated commands for instance. It can read PROISAM files natively, using random or sequential access, without PROIV installed. It is backwards compatible to 2.0r100, supports all record lengths currently in production, and does not even need files to be byte swapped between platforms.


This particular version should work on Windows platforms, though Linux, Mac OS X and Sparc Solaris 8-10 can be supported. It has been tested on Windows 7 64 bit. You'll need Java installed, version 1.6 or higher, as the program, and the library it uses, are pure Java.


The upload consists of one ZIP file with an MD5 checksum of 840ef130c18a35591356acd6e7269278. It will extract one executable. Typing DumpProIsamFile-windows from a Windows console will display detailed help and other information.

Though the utility is not free, it will be fully functional for all of July.


Regards

Edited by Neil Barber, 29 June 2013 - 02:08 AM.

[Neil Barber]

Sorry

The original post quotes an incorrect MD5 checksum. It should have been 6e4ff6f89325ad3a9830781b5566e89f. I thought it'd also be a good idea to include the ...

SYNOPSIS	DumpProIsamFile [OPTION]... [FILE PATTERN]

        	Outputs file  information and selected records  from any PROISAM
        	file as tab separated values.

        	--analyse   	Inspect  the records  selected,  and construct a
                        	file definition  from the data.  For each field,
                        	its type,  number of times it occurs, minima and
                        	maxima are output 

        	-e [KEY]        Select records with keys <= [KEY]. default: last

        	--header        Output only  the file header,  consisting of the
                        	fully qualified path name,  the size,  in bytes,
                        	the  freespace, as  a percentage  of  the  files
                        	maximum  size,  the  key  length and  the record
                        	length

        	-p [PATTERN]    Apply  [PATTERN]  to each  record  selected, and
                        	reject those which don't match   	

        	--recurse   	Recurse into any sub directories.    default: no

        	--snapshot      Create a local snapshot of each file. It will be
                        	deleted when the Java VM shuts down. default: no

        	-s [KEY]        Select records with keys >= [KEY].default: first

        	[FILE PATTERN],  [KEY] and  [PATTERN] should ALWAYS be quoted so
        	that characters, such as "$" and "&",  are passed to the program
        	without modification by the shell.
        	
        	[FILE PATTERN] can be  any valid  regular expression, as long as
        	backslashes NOT forming part of the path, have been escaped.
        	
                        	e.g "G:\proiv\vm\boots\^file...\\.pro$"
        	
        	[PATTERN] can be any valid regular expression.
        	
                        	e.g "(?i)Sel-(Partial|Range)"

[Neil Barber]

It's August, so the attachment has been taken down.

That said, I have made a folder publicly available here. It's subject to change, but anything you find in it, you can download and use, subject to licensing. I have already uploaded DumpProIsamFile, compatible with Windows and Linux, plus limited source.

[Ngoni]

l was trying to compile and run the code but its giving java.lang.Exception error.

Also how do l link the proisam file to the code.

 

Regards,

Ngoni

[Neil Barber]

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.

 

 

Sorry.