DSXchange

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

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

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?

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

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.

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