DSXchange

hi all,

i would like to know how can i set the default number of warnings that leads to job abort (just like we do in director)? I like to make the job abort once a warning occurs so that the transaction could be rolled back.

Thanks,
Cal

Hi all,

I have one input file pointing to multiple output stage according to different constraints. How can i get the number of records inserted/updated in each of the stage?? Thank you

Calvin

o.. the example contains space~
and so how can i handle if the argument contains space

Thanks,
Cal

Hi all, I use Call DSExecute("UNIX",myCommand, Output, ErrCode) to execute system command. but i find that if myCommand consists of double quote(") and single quote(') ..mostly as script argument....and it always fail to run. e.g. myCommand is testing.sh "hello '1234'" i use...

Thanks.
But there are many cases that data from staging table populate to several tables in SoR. How can i handle this?

Cal

I have staging tables and now it is the apply stage. Records in one table in staging table needs to populate into two tables in system of records. So not multiple links input to single stage, instead is one input to multiple stage.
Hope you all could help me.

Thanks,
Cal

Hi all,

I have a server job with one input, one transformer and two outputs for two tables. I would like to know how DataStage handle transaction. e.g. If one of the table fails to insert, could it rollback two tables?? can i make it one single transaction?
I am using DB2.

Thanks,
Cal

I've tried wildcard but it doesn't work and so hope to know if there are other solution

Thanks

Cal

Hi all

Could i do sth like Wait For file in a Directory?
Since the input file always comes with a timestamp, e.g. accounts20030805.dat and the timestamp is arbitrary....how can i make use of the "WaitForFile" stage instead of writing DS script.
Thanks

Cal

Thanks for your help.

but i still cannot use "execute command" in "sequencer" to execute unix script with correct parameters passed. now i just use server job to do that.. the drawback is i cannot view the the unix command flow graphically.

Cal

I am sorry that this problem only occurs when i use "Execute Command" in "Job Sequencer" job.....am i using the right stage("Execute Command") if i hope to execute unix command ?

Thanks,
Cal

Thanks all of you!
I know the master job got the log but it is quite difficult to read~
and now i am trying to archive the log before i compile jobs~

Cal

Hi all, I've tried to use sequencer and server job to execute unix command in different ways but i found there's a problem.. when i try to execute "mv #inputfile# #outputfile#" it seems that datastage really run this command(accept "#inputfile#" as parameter) instead of passing p...

Hi all, I have a job(interfaceControl) running many instances at the same time, and so i use the invocation id to differentiate them. e.g. interfaceControl.Accounts, interfaceControl.Customer but if i hope to modify this job, i found that all instance logs will be cleared once i compile it. Any thin...

Job1: (Outputs to hash file HashMaxKeys) select max(CustId) from Customer -> "HashMaxKeys", "Customer" Job2: Stage Variable (Initial Value): StartCustId -> UtilityHashLookup("HashMaxKeys", "Customer") For this method will there be concurrency problems if "...