DSXchange

Hi,

Check in the Stage Properties of the Sequential File, In that you can find that Line Termination:
Unix Style
Dos Style
None

In those select the opton None.

This is what Kumar trying to say...

Hi,

First Trim that field and then apply 'StringToDate' function.
Hope this will help you...

Subbu, What is your source, If it is Sequential file set the Field Default-->Quote as Double. Then Datastage only takes the data only within quotes(2006). To convert the string in to Integer, you can use the function "AsInteger". This function treats the given input as integer. Hope this w...

Hi,

You can use the 'Notification Activity' to get alert messages when ever your job gets failed.

Hi, Array size determines the number of rows to be read from the database or number of rows write to the database at a single time. For example, for reading data from database, if it is 1, then for each and every row it will read the data from the database. If the array size is 10 for writing, then ...

Hi Srini, Do you mean that passing values (file names) at run time. If yes, you can follow this way: 1) Choose Edit-->Job Properties-->Parameteres 2)In the dialog box you can create your new parameters and also you can assign default values to them. 3)Assign those parameters to the stages. 4)You can...

Ajith,

As far as i know Modify Stage gives more performance than the Transformer Stage. Also we are mostly using modify stage in our jobs instead of Transformer (wherever it is possible), and we are trying to avoiding Transformer stage bcoz of performance.

Hi Barny, To get the number of rows passed in target we can go for the function "DSGetLinkInfo" instead of @INROWCOUNT. Also you can get all details about your job such as Jobname, Jobstarttime, Jobendtime, tiem elapsed etc., by using the DSGetJob functions and you can store those details ...

Balaji, I think it is better to use your first option ie by using the UNION ALL command in DB2 API Stage for combining your tables. Or otherwise if you are using Funnel stage then it is better to use the 'Sequence funnel' bcoz this property copies whole data from first table and loads into target an...

Hi,

It is always better to sort the data based on the partition keys. It will increase the performance of the job.

If the stage is Partitioning data, then the sort will occur after the partitioning. If the stage is collecting data, then sort occurs before the collection of data.

DSJ.INSTRROWCOUNT will returns rowcounts. I think this function is only supported by parallel edition.

Senthil,

'Folder' Stage is not available in Parallel Jobs.

Hi,

Check whether the option, "Automatically handle activities that fail" is selected or not in Job Properties. If not check the option and try it.

Also you can get the number of rows passed in target by using the function "DSGetLinkInfo".

Hi Ramu,

What is the error message its throwing?

Balaji