DSXchange

Use SELECT * FROM DS_JOBS WHERE NAME LIKE Jobname ... in Datastage Adminstrator command.. this is the only option


Thanks,
Anupam

Go to Job Properties and check allow multiple instance and run job same job with diffrent inovacation ids......


Thanks,
Anupam

Hi Guys You totally misunderstood me. I will try to rephrase the whole thing. I have an Oracle table with 36 columns.(like code1, code2, code3,.....,code36) So each record might have 36 codes. But there is an exception here , if 001 is found in any of the codes the remaining codes are NULLS. So my ...

Ahh, I see what you are trying to do; I thought you had misplaced the FIELD() parameters. Unfortunately the delimiter for both forms needs to be a single character, so this won't work. ... I tried with "001" delimiter and it is working here ... so i dont think it should be single characte...

ArndW wrote:Anupam - what does the subfunction InLink.Field["001",1,1] do? This is not a legal substring expression. ...

string [ delimiter, instance, fields ]



Thanks,
Anupam

Try this Dcount(InLink.Field["001",1,1], "|") too


Thanks,
Anupam

i have 2 instances of the same job but i m unable to run them simultaniously. I'm lost... why the heck not? That's the whole point of these kind of jobs - so you can run the same job multiple times at the same time. Highlight the main job in the Director, click 'Run', supply a unique Invocation ID ...

Is that sequence having option check as automatically handle activity that fail...if any activity fails it aborts sequence with that error....


Thanks,
Anupam

I dont have experince with MS Access but i think .. You need to convert varchar date you are getting into Date/time datatype of MS Access....
I think convert function my help you...


Thanks,
Anupam

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. I think better to go with one job with 2 link from one sequential file stage to one target s...

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 ...

Take two link from flat file with diffrent file name to target with same name it will execute sequntailly one after another.


Thanks,
Anupam

Use stage variable to calulate ......................


Thanks,
Anupam

Target data type must be timestamp ....
Use TO_TIMESTAMP(:1,'YYYY-MM-DD HH24:MI:SS:FF')


Thanks,
Anupam

loveojha2 wrote: It won't, until you have designed it that way, I have tried with exactly what you mentioned the result is all zeroes for all the link counts.

Try to get Just before target stage, Just plan it ..............

Thnaks,
Anupam