I tried to use the UtilityHashLookup in a controlling job and declared it like this:
Deffun UtilityHashLookup(A1,A2,A3) Calling "*DataStage*UtilityHashLookup"
But I always get a fatal error??
Stephan
How to use DS Routines in a controlling job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 39
- Joined: Tue May 20, 2003 3:36 am
- Location: Singapore
-
- Premium Member
- Posts: 39
- Joined: Tue May 20, 2003 3:36 am
- Location: Singapore
hi Stephan,
pls use all upper case for DSX.UTILITYHASHLOOKUP.
if this doesn't work, pls
1. check if this SDK function is compiled
2. check in the directory DSU_BP.O under your project directory if it exists (take note of the case)
i tried in my machine and it works. i'm using DS 6.0.1 running on Solaris 9.
just an aside, DS 6.0.1 is not certified on Solaris 9 yet! [:0]
pls try it at your end... thanks...
cheers,
vladimir
pls use all upper case for DSX.UTILITYHASHLOOKUP.
if this doesn't work, pls
1. check if this SDK function is compiled
2. check in the directory DSU_BP.O under your project directory if it exists (take note of the case)
i tried in my machine and it works. i'm using DS 6.0.1 running on Solaris 9.
just an aside, DS 6.0.1 is not certified on Solaris 9 yet! [:0]
pls try it at your end... thanks...
cheers,
vladimir
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Some technical info...
There is some inconsistency with how DataStage routines are cataloged (more historical accident than anything else). There are five main prefixes:
"DSD." routines used primarily at design/compile time (for example DSD.Browse)
"DSP." routines associated with stored procedures (for example DSP.Close)
"DSR." repository management (for example DSR.SCHED)
"DSU." "user-written" routines
"DSX." supplied transform functions (for example DSX.CONVERTWEEK)
Just to be interesting, these are stored in separate Type 19 files (subdirectories in the project) with inconsistent names:
DSD_BP.O primarily "DSD..." functions but some others
DSG_BP.O some transform functions, plus job control functions and repository management functions
DSU_BP.O user-written functions
For backwards compatibility names DSJ_BP.O and DSX_BP.O exist in the VOC file (DataStage vocabulary), but nowadays (version 6.0) point to DSG_BP.O.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
There is some inconsistency with how DataStage routines are cataloged (more historical accident than anything else). There are five main prefixes:
"DSD." routines used primarily at design/compile time (for example DSD.Browse)
"DSP." routines associated with stored procedures (for example DSP.Close)
"DSR." repository management (for example DSR.SCHED)
"DSU." "user-written" routines
"DSX." supplied transform functions (for example DSX.CONVERTWEEK)
Just to be interesting, these are stored in separate Type 19 files (subdirectories in the project) with inconsistent names:
DSD_BP.O primarily "DSD..." functions but some others
DSG_BP.O some transform functions, plus job control functions and repository management functions
DSU_BP.O user-written functions
For backwards compatibility names DSJ_BP.O and DSX_BP.O exist in the VOC file (DataStage vocabulary), but nowadays (version 6.0) point to DSG_BP.O.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518