DSXchange

Hi Pongal,

Alternatively, you can always store the number of rows read from source in a sequential file and read the file in a before job routine and populate your sequence number accordingly.

Hi jetlim,

You need "ABAP Extract Pack for SAP R/3" plugin, if you want to extract data from SAP R/3. This plugin is a part of the SAP R/3 Pack sold seperately by Ascential.

Hi Shivan,

Could you tell me how many rows you see on the link that goes into the transformer and how many rows you see on the link that goes out of the transformer?

Hi Shivan,

After extracting data from SQL server and before loading into DB2, what tranformations are you applying to the data?

Hi Shivan,

What exactly do you mean by "but i m just using grouping". Could you please eloborate on what you are exactly doing by grouping?

Hi Shivan, 1) Check how many rows you are extracting from source( SQL server) 2) At each stage where you have a constraint, store the reject records in a reject file 3) Then finally, No of rows you are trying to load to target = No of rows you extracted from source + Total No of rows eliminated beca...

Hi NaveenD,

I believe even the Count function expects a string and therefore you would have to convert numeric to string to use that function.

Count Function "Counts the number of times a substring occurs in a string."

Please correct me, if I am wrong.

Hi NaveenD, You can convert the numeric field to a string and then use the substring function and check for a "-" sign in the first character of the string. Based on the result, you can apply your processing logic. Once your processing is done, you can convert the string back to numeric an...

Hi Anil,

How about the sdk Built-in transform DateGenericDateDiff. I am not sure whether it works on MVS edition, but give it a try.

Hi Balaid,

Like Arndw rightly pointed out, there are a lot of ways you can achieve your goal.

Here is one using Oconv

For Extracting Numbers
For Extracting Characters

Hi, If your datastage server is a Single Processor System, then you can use "In Process" row buffering and If your datastage server is a Multi Processor System, its advisable to use "Inter Process" row buffering. That being said, from your error "row too big for inter stage ...

Hi dsxdev,

Try the below syntax

Yes Vinodlakshmanan, you are exactly right.

...if you have DS 7.5 or above.

Oops, I forgot to mention that. Thanks Sai for adding it.

Hi Roshni,

You can attach the files in the Notification Activity Stage in the Job Sequencer.