Creating Hashed File

mousazzi · Post by **mousazzi** » Wed May 16, 2007 12:57 am

Hi All.
I've got a Before/After routine that get a set of information about the server job that recall it (number of rows, oracle error, name of the stage and so on). I'd like to store this information in an Hashed File (now I put then in a flat file) but I didin't find any specific command to create and store data in it. I'd prefer the Hashed File instead of Flat one because the routine must be used form all the job in the project (about 1000) and I have to insert in an Oracle table all these informations.
Thanks and Ciao.

ray.wurlod · Post by **ray.wurlod** » Wed May 16, 2007 1:03 am

Research the following statements in the on-line Help or in the DataStage BASIC manual:
OPEN
RECORDLOCKU
READU
WRITE
RELEASE
CLOSE

That should get you close.

mousazzi · Post by **mousazzi** » Wed May 16, 2007 7:57 am

ray.wurlod wrote: Research the following statements in the on-line Help or in the DataStage BASIC manual:
OPEN
RECORDLOCKU
READU
WRITE
RELEASE
CLOSE

That should get you close. ...

Yes but I can't understand how I can create a new one...

DSguru2B · Post by **DSguru2B** » Wed May 16, 2007 8:02 am

Also research about CREATE.FILE .

ray.wurlod · Post by **ray.wurlod** » Wed May 16, 2007 3:53 pm

You would call CREATE.FILE, CREATE TABLE or mkdbfile through the DSExecute() subroutine.