DSXchange

Hi,

I don't have parallel extender installed, so can't try this.

I came to hear that it is compulsory to sort data before using lookup/merge/join/cdc stages.

Is it true? If so why? I can't think of a reason. Is it for performance?

Thanks

Is there any nvl equivalent function to use in select queries of uvsh. Basically want to replace all null with an empty string.

Hi, I have a job which updates an oracle database. I would like to test the working of this job, but at the same time not update the database as other ppl are depended on it. I know that I shouldn't commit after execution of the sql. a) If I someway do not commit, then can others use the data withou...

Hi,
I want to ftp multiple files (say 2 of them from selected directory) on server A to server B. How can I achieve this, I am able to migrate 1 file by giving the the file name in the properties column.

Thanks

Hi,

I know that we can't use hashed file through parallel jobs, but can we use UV database to access via parallel job (which contacts datasets etc).

Thanks

I am using 7.5.1 version

Hi,

No it is not enabled. Does DataStage deal with JobActivities in parallel differently than with JobActivities in Serial

Regards

Hi, I have a sequence with Job Activities (JA) as follows. __ JA4___ / \ JA1 -> JA2 -> JA3 ------- JA5 ----- -- JA7 \ __ JA6 ___/ I have set the sequence as restartable. This is working fine with the Job Activities in serial, but not with parallel. i.e. lets say JA2 has failed, then when i rectify t...

Which way is preferred, to use routine activity with 3 or 4 parameters concatenated (slight messy as each parameter is derived from a lengthy function) or a job with code in job control (will atleast split the messy parameter list into 3 or 4)

Cant we have more than one argument for Before/After Subroutines. If not, they why does the RoutineActivity stage say that it can pass more than one argument?

:o For a while I thought I figured out how to do it. Next approach what I can think of is to write files from Seq1 and Seq2, and Seq3 Waits for those 2 files written by Seq1, Seq2, using Wait for File Activity ( with Do not time out checked ). After that I remove those files (which I will use just t...

I created a new job and had this as first job in a sequence, where I want to wait for two jobs to be completed, before I could move on. I am using the following code in the job control, but this job doesn't wait at all. It compiles and runs properly. and then proceeds to next job in a sequence (I ev...

I need to wait for 4 or 5 sequences to run before I run another sequence. But these 4 or 5 sequences come within a span of 2 weeks to 1 month. How do I remove the time out option (or) specify particular time for time out??

Don't forget to use an existing file in the Input 'FileName' box.

What should this FileName be File1 or File2?

or should i write
and use the FileName as #File3#

I didnt not get that. could you explain it in detail?