DSXchange

Hello, I have the requirement to produce the report of No. of records written in a sequential file. Till the point rows written to sequential file, I can able to take the count of no. of rows. But the problem exist when no rows are written to sequential file and i wanted to display in my report that...

kumar_s wrote:Dont you find any Transactional handling parameter in SP stage?

Well i tried to find the Transaction control, but not suceeded, Can u tell me the property and property value.

Thanks

Hello Expert, I have the DS job of Store Procedure (SP) which accept 5 input and 5 output parameter. I am executing the DB2 SP from DS STPPX stage and it execute on input parameter and returning the output parameter perfectly. In my DB2 SP, i haven't mentioned the commit explictely.But still my reco...

Hi,

I want to perform the below transformation validation on character filed.

I.e. Field should have Valid characters are Alpha, blanks, hyphens and apostrophes

How to put the above validation for character field.

Kindly help. Thankx

Hi, While Loading the data from sequential file to UDB2 stage , i am getting the below error when i am using the load as the write method because i want to trucate and load the data into db2 table. DB2_UDB_Enterprise_9,0: DB2 Load Binary Error. But when i use upsert write method and when specify the...

Hi, I want to generate & associate the sequence no from database sequence object and require to associaate to each row of sequential file. How i can generate the sequence no for each row of sequential file and associate with each row of sequential file. Please guide me for achieving above. Thank...

Hi, I want to validate the sequential file column heading & their position in the file. i.e. column heading should come in particular order. field01='Column A' field02='Column B' field03='Column C' field04='Column D' .... ... .. How i will check the metadata in transformation processing constrai...

Hi, I have the requirement of loading the sequential file data into the data set. But before tranformation of data , i have to check the input sequential file has the proper no. of columns, column sequence , proper column data type, mandatory data in a column. In short, i have to validate my input s...

Use the Remove duplicate stage, Thanks for all those who viewed..

Hi, I have multiple output links coming out from the Transformation i.e. 4 error link and 4 reject links populating error & reject dataset. I have the requirement that when i found any error in the source row i have to output that row to the reject and error dataset. There can be multiple errors...

Hi, In my job i have used StringToDecimal function in many places, while running job i am getting the below warning in DS Director , but i could not able to trace the warning raises through which transfemation stage step. xfrmLoadData,1: Conversion error calling conversion routine decimal_from_strin...