Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
IBMDS4KK
Participant
Posts: 20 Joined: Tue Sep 10, 2013 5:50 am
Post
by IBMDS4KK » Sat Sep 14, 2013 10:25 pm
Hi All,
I am new to server jobs. And currently my project is support project. While analyzing the job, I was not able to understand what is use of Hashed file stage and the main concept behind this ?
Kiran Kumar
...ALL IS WELL...
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Sun Sep 15, 2013 5:08 am
Hashed files in server jobs are similar to very fast local tables used to store and retrieve data. Perhaps the
Manual Pages might help you further.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sun Sep 15, 2013 7:42 am
Typically used for lookups. If you have any Informatica experience, I can make a comparison if that would help.
-craig
"You can never have too many knives" -- Logan Nine Fingers
IBMDS4KK
Participant
Posts: 20 Joined: Tue Sep 10, 2013 5:50 am
Post
by IBMDS4KK » Tue Sep 17, 2013 11:03 pm
Dear Craig,
1) Are we able to view the data of hashed file ?
2) In my project, some hashed file stages are used as a reference to the Transformer stage. I wanna see the data of hashed file, for that I was asked my team mates what is the source of the hashed file. But no body responded. Could you suggest how to see the data ?
Note: I do not have Informatica Experience.
Kiran Kumar
...ALL IS WELL...
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Wed Sep 18, 2013 1:40 am
You can do a "view data" by right-mouse-clicking on a hashed file in the designer, this is the easiest option for you. The other option is to enter TCL and issue either the old UniVerse DML or SQL commands to list the file, but I'd recommend sticking with "view data" for the moment.
IBMDS4KK
Participant
Posts: 20 Joined: Tue Sep 10, 2013 5:50 am
Post
by IBMDS4KK » Wed Sep 18, 2013 6:48 am
Dear ArndW,
The option which you mentioned 'Right Click' on the stage is not working, When i do this it will display like unable to open the file. Please suggest something else.
Kiran Kumar
...ALL IS WELL...
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Sep 18, 2013 7:18 am
If the job has never been run and thus the table never created and populated, then you'll get that error. Is that the case?
-craig
"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Wed Sep 18, 2013 8:32 am
If the hashed file exists and has data, then please post the exact error message, as the view-data functionality should work.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Sep 19, 2013 6:07 am
Report to us all the property settings in the Hashed File stage. Beware, too, that names are case sensitive.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
arunkumarmm
Participant
Posts: 246 Joined: Mon Jun 30, 2008 3:22 am
Location: New York
Contact:
Post
by arunkumarmm » Mon Sep 23, 2013 4:08 am
Check for the proper file name too.
If the file name is parametrized, it might not have the same file name/path in the job as it does in the job sequence.
You may need to verify those values before trying to view it.
Arun
oracledba
Premium Member
Posts: 49 Joined: Mon Aug 06, 2012 9:21 am
Post
by oracledba » Mon Oct 21, 2013 12:03 pm
IBMDS4KK wrote: The option which you mentioned 'Right Click' on the stage is not working, When i do this it will display like unable to open the file.
Dont right click..... Double click on hash file stage. go to output tab. click on view data