DSXchange

Hi friends, i m using a sequential file as source and putting the rows into a DB2 Table after validation(using transformer and hashed files).There is a link coming out of the transformer and inserting the errorneous rows into the error table with an IPC in between. First Fatal error coming is : PS_P...

Hello friends... Can we Avoid the Job Abort state even after getting fatal error while processing any Row? Actually,i want my job to process all the rows.Now my job get abort/stop when 3 or 4 fatal errors occured.But i want that the job should proceed after any fatal error also... Please guide me ho...

Hi Ray, Actually i m using a sequential file as source and putting the rows into a DB2 Table after validation(using transformer and hashed files).There is a link coming out of the transformer and inserting the errorneous rows into the error table with an IPC in between. First Fatal error coming is :...

Hello friend,
Getting this error...Please suggest...
Help is highly appreciated!!!

Thanks

Yes these Hashed files have to be reloaded everytime the Jobs run..
Job will run once in a day...What are static Hashed Files???
In my Hashed Fiel creation options i have setted 'Type30(Dynamic)' in the File Type option.

Thanx

Hello friends, I have a Job Sequence consisting of two Jobs. I am providing you with the number of stages and some expected data that the jobs are expected to handle : First Job : 17 Look-ups (12 using Hashed File and 5 using Database tables).Average Rows in a hashed file is around 2000-3000.Databas...

Hello friends, I m using many Hash files in my jobs and the size of these jobs can be huge.For Example one hash file may contain 20 million rows.But the number of these huge sized hash files are only 1 or 2. Please suggest me how should i set the parameter values while creating the Hash File like Fi...

No...these strange characters are not a part of my Data.

No..i m not using any user defined SQL.
and the error message is not same always...it keeps on changing..and evreytime it show me these starnge characters.
So no fixed error message...I m surprised to saw these error message.
And sometime it just show me all the data without any Error Message.

Thanx

Hello friends, Very frequently i m facing this error message : PS_PP_JRNL_LN..InterProcess_44.Read_PP_File_IN: ds_ipcopen() - call to OpenFileMapping() failed - The system cannot find the file specified. But i have placed the required file at the specified location.Even then it is giving me this pro...

Can you please explain me what this would do???I mean what will be the return values of this function?

Hello Friends, I m Inserting Rows into DB2 Table using 'Insert new without Clearing' SQL Action.The Source is a Sequential file.In this file we may have rows with the same Key fields.That means when a row with repeating Key Values will come my DB2 Stage will throw an error of Insert Fails.The error ...

Thanx Friends for ur replies... This problem has been resolved... The problem was with my Table Structure.I have only the key fields in the table and i was using Insert new and Update Existing Action in the DB2 Stage. Now i have changed my Table Structure and one extra non key field.Now the job is r...

Yes i m using IPC at the output end of the Transformer.
There is an IPC in between the DB2 satge and the Transformer.But this problem was there when i was not using IPC in between.