DSXchange

Better to use connector as they can process data in parallel nodes.

I am not able to see what ArndW has suggested. Normally we avoid doing insert and updates separately in the same job because locking can happen. Also if your data is like inserts should happen first or an update record can exist for new incoming record then surely inserts should happen first. And it...

@dfkettle
I have tried using a reject link in the DB2 UDB stage and its giving the same compilation error.
If your consultant is right then we both have that "installation" issue

The Stored Procedure stage is present in the Palette under "Database". The stored procedure is not so difficult to understand if you know the procedure code. Once the open the stage, under General tab you have to fill the database connection parameters. Same is true for Syntax and Paramete...

Does auto partition will work without flaw for any volume of data? Especially in JOIN / LOOKUP? Yes, it works all the time. In my project we process lot of data(my client is the biggest Bank of India 8)). We always use auto partitioning and till now there's no discrepancy in the data. There's NO ha...

You don't need to explicitly partition and sort the data, choosing the auto partitioning method will ensure that partitioning and sorting is done.

Increase the value of APT_DEFAULT_TRANSPORT_BLOCK_SIZE.

Actually I figured it out.
Anyways thanx Romil for your help. :D

@Chetan As I told only record with TYPE = 36 will go in the o/p. So for ACCT = 100, the RECNO will come from the just previous(larger) RECNO(in this case 10). The NAME will always come from TYPE = 36(NOT TYPE = 1) @Craig In the transformer, partitioning is on ACCT with RECNO sorted desc. stage varia...

just to add that I have tried a logic in the transformer where I partition the data on ACCT and sort on RECNO desc. Now I also used stage variables where I check the old ACCT with new ACCT. I am getting the data as I require except the RECNO is not coming correctly. I have mentioned above that the R...

Hi All, Sample Data ACCT RECNO TYPE NAME 100 11 1 Null 200 19 36 AA 200 20 1 Null 300 29 1 Null 100 10 36 BB 100 8 1 Null 300 27 36 CC 300 28 1 Null Output Data ACCT RECNO TYPE NAME 200 20 36 AA 100 11 36 BB 300 28 36 CC Conditions/Constraints Records with TYPE = 36 will go in the o/p but the RECNO ...

@Srini
The logic worked. Thanx

My Data looks like Here for ID = 3 and 4, I want date as Null.
But above logic is not working correctly.

Hi, My source is a sequential file and I am reading date columns as Varchar(10). My problem is the date fields contains \N character. I want these dates as Null so using the below logic but still logic is not working as it is supposed to work. If TRIM(Lnk_Src_To_Trf.EXTRNL_RTNG_STRT_DT) = '\N' Then ...

Hi,

Go to /datastage/IBM/InformationServer/Server/DSEngine/bin path and execute dsjob -run command then it'll works.


Thanks & Regards,
Chandra Shekar