Page 1 of 1

Regarding Analyzing Parameter

Posted: Tue Jan 16, 2007 2:33 pm
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

Re: Regarding Analyzing Parameter

Posted: Tue Jan 16, 2007 2:35 pm
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.

Posted: Tue Jan 16, 2007 2:37 pm
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.

Posted: Tue Jan 16, 2007 3:52 pm
by us1aslam1us
Check the environment variables and you will be able to analyze it by yourself.

Posted: Tue Jan 16, 2007 5:05 pm
by vijaykumar
Hi Gurus,

Thanks very much Gurus.

cheers;
vijay

Posted: Tue Jan 16, 2007 5:10 pm
by narasimha
Make it a practice to mark your resolved posts as "Resolved". :idea: