DSXchange

Im using 7.5.1 A and seems the bug has been fixed! i can use $PROJDEF as default value for password and view data seems to work without much complaints

Are you using a create table option in the Universe Stage? Have you clicked on the Create DDL button?

Can you use 2 or 3 transformers in cascade? That might reduce the length of your derivation. USe some stage variables to store intermediate results or flag status. This is not very elegant , but if it is a quick fix, then you know what actually causing the error. ALternatively , you can create a fun...

well im calling a perl script in my job, but giving the absolute path. Im also sourcing the environment before running that script( using a shell file full of 'export ENV=$VALUE' commands). Im NOT using perl - blah blah anywhere. INstead i have a shell script that will invoke the perl script and im ...

Hi you havent mentioned whether you are using the command stage in a job or whether you are using the execute command activity of the job sequencer. If you mean the latter , maybe you can try something like ". /usr/xyz/scripts/commandtoexec.sh" or sh -c ". /usr/xyz/scripts/commandtoex...

todev132:/app/ascential/Ascential/DataStage/DSEngine> bash todev132:/app/ascential/Ascential/DataStage/DSEngine . dsenv todev132:/app/ascential/Ascential/DataStage/DSEngine bin/dsjob Command Syntax: dsjob [-file <file> <server> | [-server <servertodev132:/app/ascential/Ascential/DataStage/DSEngine> ...

further, to assign a value to #PARMDATE#, you will have to introduce this job as a job activity stage in a sequencer and edit teh job activity stage, use a datastage function lile "Oconv(@DATE,"FORMAT_CODE") to pass a VARCHAR value to the #PARMDAT# parameter, the advantage here(using ...

[quote]select ID,Create_Date,Desc_cfp from table where Create_Date>#PARMDATE# [/quote] I would rewrite the query thus if i were using oracle select ID,Create_Date,Desc_cfp from table where Create_Date>TO_DATE(#PARMDATE#, 'mm/dd/yy') im not sure what problem you are up against, but i guess you need ...

Hi Copy the definition(source code) of TAG.TO.DATE from the transform and use it within the routine. Use an intermediate variable to store the result of the routine. alternatively this is the way you could go about it Ans = ICONV(Arg1,"D-YMD") where Arg1 = "2006-03-24" Thanks