DSXchange

Hi, I have input records comming as ND1, ND2 and CNT1 and ND1 contains SN, Name and Address and ND2 contains SN, Birthdate, Hiredate and CNT1 contains SN, CN1 and CN2 . For example if there is a input like this ND1,123, Raju, 1502 ND2,123,19880606,20070707 CNT1,123,0000,0000 ND1,234,Srin,6666 ND2,23...

Hi, I have a job which selects the records from Db2 /Zos and Iam using Db2 /API stage to read the records from the source, previously it used to take 20 minutes for the job to finish , now when Iam running the same job it is not finishing even after one hour . I am writting records to a Sequential f...

Hi Bandish,


When I tried to use a pivot stage and try to connect from Db2 API stage it is saying stage doesnot support non reject output link whilst it has input links. How can I provide pivot stage after DB2 API it is my final stage in my job





Thanks,
Somaraju

Hi, Iam having a job with a Dataset file , transformer and Db2 API stage . Iam trying to insert 3.3 million records in to the target table , Iam missing 650 records in table but those records are present in the dataset and my Datastage Director is not showing me any warnings , there is a ID column i...

Hi, I created a message handler to suppress all the rows that fail due to RI . Iam doing an insert in to a Db2 table using Db2/API stage . I am suppressing the warning SQL0530N the insert or update value of the FK is not equal to any value of parent key of the parent table SQLSTATE =23503, Datastage...

Hi,


I have a problem in seeing job log from Director, I am having so many warnings in job due to Foreign Key failures , is there a way can I get the log through ftp . Where can I find the log files in the server





Thanks,
SomaRaju

Hi, I have a requirement like this . I have a input record like this ID NO COUNTRY PRICE VALIDFROM 9406 123 US 00 1/1/2007 9406 123 US 00 1/1/2004 9406 123 US 00 1/1/2005 Now I want to take latest VALIDFROM and assign VALIDTO as 999/12/31 and remaining records must contain Newprice.Validto - Oldpric...

Hi Ray, I have two files . First job takes first file and inserts in to Price table and it has transaction size mentioned as 2000 and there is another job with second file it will first update and then insert the same Price table . My requirement is I need to commit once my first job is finish and b...

Hi, Iam using DB2 API stage to insert data in to an X table . Iam getting an Dead locking issue. I changed my transaction size to 2000 and the job is running fine Iam not facing any issues now, is there a way so that once I finished my work on X table that I can commit the work to free the X table ....

Hi,


Thanks GUYS for helping me .








Thanks,
SomaRaju

Hi, I want to Round the decimal values to the nearest decimal value. I have a record with PRICE value = 13437.567 from input and it has Decimal (12,3) and I want output as 13437.57 and the output metadata is Decimal(12,2) . I used modify stage to achieve this In Specification I mentioned NEW_Price:D...

Hi Guys,



Thanks for your help.






Thanks,
somaraju

Hi Arnd, I am rejecting the records that fail in lookup to a Dataset . What I found was the record schema is having column names different from what the column names Dataset has in the job . Iam confused how the record schema is having different metadata and not the metadata the Dataset had because ...

Hi Arnd,

Sorry I missed that in record schema "File_TBLEID" and the record schema contains File_TBLEID: ustring[max=12]. Iam still having this problem with the dataset .





Thanks,
SomaRaju

Hi Ray , This is the schema for that dataset record ( LISTCH: string[2]; Tgt_RIDDEN: string[1]; Tgt_TABLEID: ustring[max=12]; COUNTRY: string[max=2]; PRICETYPE: ustring[max=3]; Tgt_VALIDFROM: date; Tgt_CURRENCY: string[max=3]; Tgt_RELEASED: string[1]; Tgt_PRICEUSDCALC: nullable decimal[12,2]; Tgt_PR...