DSXchange

Is there a way to pass parameters from a batch job to a unix script without the use of a text file?

I have a batch file that invokes dsjob in a unix script and I would like to pass the parameters from that batch to the job being called by dsjob.

quote:There's nothing wrong with having a job in Project1 write its parameter values to a text file, and having a job in Project2 read its parameter values from that text file. No, we do some of that already. The problem is that these jobs are inline with other dependecies after them. Is it possible...

No way to trick DSAttachJob to do a change directory? We have three jobs... Master1Batch = passes table_name, schema_name, and where clause CustomerBatch = passes these parameters in a loop to the job CustomerJob = runs the OCI with the above as dynamic parameters CustomerJob now sits in another pro...

You're trying to put a large column into a small column. You must go into the transform and change the value.

IE:

DB Column = Varchar(30)
DS Column = Varchar(10)

I know you can run a dsjob -run script, but I am looking to run a batch job in Project1 which will kick off a DS job in Project2.

Can this be done through the batch job? with DSAttachJob (JobName, DSJ.ERRFATAL)?

Only a DBA can kill a procedure.

What version are you working with? I recently discovered a bug with a job which is looped X number of sources. Some sources would pass through fine but others would not. I tried cleaning every column coming through, which eliminated some of the problem, but was still getting abnormal termination of ...