DSXchange

hey thanks guys,

thanks bondcaliwood

it worked, job aborts when script returns nonzero value..

Hi Folks, I'm trying to use Unix shell script before-job subroutine using ExecSH I'm not fluent with unix scripting Background: I have a server job that contains a Sequential File,Transformer and ODBC stage.It simply loads data from txt file to a table. My script creates Index on a column.It works f...

ya anupam i tried the same,

and i dont want to run it using command line.

can i do that ?

hey ArndW ,

I told earlier that i dont want to run it in sequence and so u suggested me the multiple instances and now i have 2 instances of the same job but i m unable to run them simultaniously.

thak you.

ArndW, I have created 2 job invocation's in DS Director ,in job status it shows me myjob Validated OK myjob.invo1 Validated OK (parameter is file1's path) myjob.invo2 Validated OK (parameter is file2's path) now i want to run these 2 invocations . If i click on one of these then only run is active i...

hi Ray ,

I have created instances with different invocation IDs but I am not able to
run those at same time .

I cant use shcedular for that.

how can I do that ?

hi ArndW,

thanx i think it will help me,

i m new to this multinstances,

i have done(validated) 2 instances of same job with diff file path as parameter,

now how to run these two instances at a time ??

i cant shcedule it..

hey thanks for reply,

but the job is going to run frequently and the data is going to be changed with same file names.
Its not fisible to cat 2 files that every time.

hi Anupam,

I think u have not read the Question completely.I dont want it sequentialy.
And also I dont want to add new stage in my job.

can I do that ??

Hi Folks, I'm trying to load two different text files(same columns) to a table in server job which loads data from a sequential file stage(source) to a ODBC stage(target) and I'm having a little difficulty that I hope someone can help me with. Background:: I have tried with 'job sequencing' in which...

Hi OP,

thats true, Can I write a routine (in Basic ) for that ?

If yes give some hints or examples.

Regards ,

Amarnath

Hi Folks, I'm trying to use environment variables with DataStage and I'm having a little difficulty that I hope someone can help me with. Background: I have some server jobs that contains some Sequential File,Transformer and ODBC stages. I have defined some environment variables using DS Administrat...

ohhhh and one more,

the date format in the example is DD-MM-YYYY

and for the same reason tat leap year and differnt days in months I want built in function for same

ohhhh and one more,

the date format in the example is DD-MM-YYYY

and for the same reason tat leap year and differnt days in months I want built in function for same

hey sorry guys,

by mistake i posted this topic on TX forum

And yes I am using Server job for this n dont wana write the routine for that

thax,