Creating Static Hash file

[Gokul]

Hi ,

I have created the static type 3 hashed file using command line of adminstrator.
I am trying to create the hashed file through the datastage job.
I have specified Type 3 in the Create file options of the target hashed file.
No transformer is used in the Job . The hashed file is created from the sequential file.

While compiling it gave below error,
Error Compiling generated subroutine for stage TestHash.Hashed_File_1.IDENT1

Thanks,
Gokul

[chulett]

What does it tell you when you click the 'More' button?

[ArndW]

Gokul,

Do you have columns going into the hashed file stage? Is at least one of them identified as a key? Can you try a View-Data on that hashed file stage?

[Gokul]

The More Buttons Says
(TestHash.Hashed_File_1.IDENT1)

Since the Hashed file is not created , i cannot view it.
The error i got was during compile time and hence hashed file is not created.

Hash file contains 2 columns Col1 and Col2 . Col1 is the key column.


GOkul

[chulett]

There's no problem creating a static hashed file as you are doing... something else must be going wrong.

Perhaps try adding an explicit transformer stage between the two and see if that makes a difference - it shouldn't, but you never know and then at least that consideration will be off the table.

[Gokul]

Thanks Craig,

I tried with the Transformer stage in between, it worked.
After that i recreated the job again without the transformer, it ran succesfully.

i may missed some step during my first attempt.

Thanks again,

Gokul