DSXchange

Transform routine will definitlyhelp.

if your date has time in it, please put varchar for that column in output.

if your date has time in it, please put varchar for that column in output.

put 009 for horizontal tab and try it out.

hello friends,

please can you provide me some information regarding shared containers implementation or any pdf or white paper on shared containers.

thanks a lot.
sachin

Yes as suggested by chulett it could be done through Job Control and Basic coding.

Hey friends in United States a Wishing you HAPPY THANKSGIVING :D

Please let us know how are you sheduling job, sequencer or through basic code in Job Control.

In first case we can check values using routine activity stage.

in second cases we can find out value in database and call DSRunJob function.

no

check for Incomplete column specification like "Retain","Replace","Error".............,
hope that may help.

job design as below.

take all of your five input input files ----> Transformer--->hash file(or sequential file if you want to maintain duplicate records)-->OCI stage (Insert rows without clearing).

hope this design may help.

2nd design:
may folder stage also help.

hello i have just created a simple test routine(testreturn) with one single input parameter like below --------------------------------- val1=Arg1 if val1 = 1 then Ans=@TRUE end else Ans=@False end -------------------------------- in transformer i write below code If testreturn(2)Then 'True' Else 'f...

yes job parameter will do if you are executing through batch runtime value change will be captured in sequencer.

hello dear, for your requirement, you need command activity stage, which will output start loop and end loop value concatenated. just for example you create one .bat file with echo command. get the output from command activity stage and put it in UserVariables_Activity stage creating one/two variabl...

TEST #1 ******* Arg1 = d:\datastage\data\india1\sachin\out\new7.txt Arg2 = d:\datastage\data\india1\sachin\out\new71.txt Test completed. DSLogWarn called from : ExecDOS Message to be logged is... > Error when executing command: FC d:\datastage\data\india1\sachin\out\new7.txt d:\datastage\data\india1...