Regarding Analyzing Parameter

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

Post Reply
vijaykumar
Participant
Posts: 228
Joined: Tue Oct 03, 2006 7:08 pm

Regarding Analyzing Parameter

Post by vijaykumar »

Hi Gurus,

One of my friend is using a parameter
NAME PROMPT TYPE VALUE

$DB TYPE ENTER THE DATABASE TYPE STRING $PROJDEF

Please help me in analyzing the data, i was given task to analyze the parameters. what does the parameter DBTYPE indicates. Is that it shows that it is of dynamic rdbms type or any database type. Please help me Gurus.

cheers;
vijay
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Re: Regarding Analyzing Parameter

Post by DSguru2B »

vijaykumar wrote: $DB TYPE ENTER THE DATABASE TYPE STRING $PROJDEF
It indicates the type of database as it says. It could be any database type. One place where it can be used is in the DRS stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Someone at your site has created an environment variable $DBTYPE that this job will recognize. The $PROJDEF is a token to DataStage to tell it to get it from the environment.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Check the environment variables and you will be able to analyze it by yourself.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
vijaykumar
Participant
Posts: 228
Joined: Tue Oct 03, 2006 7:08 pm

Post by vijaykumar »

Hi Gurus,

Thanks very much Gurus.

cheers;
vijay
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

Make it a practice to mark your resolved posts as "Resolved". :idea:
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
Post Reply