DSXchange

Shilpa,

What I assume your table have some duplicates.. The result when writing to hasfile. It takes the last record and update.

So remove the duplicates from the table.

Regards
Neeraj

Need help. I have to read row by row and update the previous row based on the value of next row. Here is the data. 99,"997 ",20030101,20081231, 99,"997 ",20030201,20081231, 99,"997 ",20030401,20081231, The result should be 99,"162 ",20030101, 20030201 , 99,&qu...

This is regarding the DB2 Enterprise stage used within PX. The data getting populated within the table is not in proper format. A sequential file( from server job ) is read in PX job. the data in the sequential file is loaded into the dataset and Inturn this dataset loads data in to the DB2 table. T...

Can you have your database engine do the work? SELECT K1.NBR, K1.SEQ, ( SELECT MAX(EVNT_EFCTV_DT) FROM Kav K2 WHERE K1.NBR= K2.NBR AND K1.SEQ = K2.SEQ AND K2.EVNT_CD = 3800 ) AS "DT1", ( SELECT MAX(EVNT_EFCTV_DT) FROM Kav K3 WHERE K1.NBR= K3.NBR AND K1.SEQ = K3.SEQ AND K3.EVNT_CD = 6000 )...

How about some really simple SQL: SELECT NBR, SEQ, max(case when EVNT_CD=3800 then EVNT_EFCTV_DT else NULL end) "EVNT_EFCTV_DT_3800", max(case when EVNT_CD=6000 then EVNT_EFCTV_DT else NULL end) "EVNT_EFCTV_DT_6000" from Kav group by SEQ,NBR Hi I tried this query.... and i got t...

Hi, Here is my source data.. 100 1 3800 11/05/2005 10:21:01 100 1 6000 11/06/2005 10:20:02 100 2 3800 11/05/2005 10:22:01 101 1 3800 11/05/2005 11:20:01 101 2 6000 11/05/2005 11:23:01 I want my target file to be populated as 100 1 11/05/2005 11:20:01 11/06/2005 10:20:02 ( Max date for 3800) (max dt ...

Hi, When I am importing the metadeta of stored procedure having IN as well as OUT parameter in table definition branch. I am getting only one rown which is related to I/O as 'IN'. But It doesn't Provide any row for I/O as OUT.. As mentioned in my previous mail, this is my stored procedure: CREATE OR...

Hi, I have created a simple stored procdure having one input parameter and using sys_refcursor as an out variable... here is the procedure: CREATE OR REPLACE PROCEDURE test_procedure ( Test_Parameter IN DEPT.dname%TYPE, Test_Cursor OUT sys_refcursor ) AS --TYPE Test_Type IS REF CURSOR RETURN DEPT%RO...

Hi, I am facing following problem while running the PX job. Transformer_7: Failed to load the library "V0S7_parallel_seq_Transformer_7.dll". Either the directory containing the library file is not on the library search path, or the library was compiled on a system that is incompatible with...

Hi, When i am trieng to complie the simple parallel job it is giving the following error. My job consits of one sequential file stage as source one transformer and sequential file as target, it is direct mapping from source to target no functions and calculations used in trasformer stage. Output fro...

Thanxs for the help.... I have got the solution

Hi Friends, I Have one requirement like: I have a 2 columns in my Source table as follows: First_Name last_Name Rahul Verma Rahul Mahajan Mohit Khanna Mohit Aggarwal Mohit Shah And my Final Output table has three columns and after transformation, result must be as follow: First Name last_name1 last_...

Thanx..

Hi, I have one query. My Source stage has 10,000 records, While loading the record in the target database, my job gets aborted and I am able to insert 8000 records. I want when I run the job next time, the insertion should start from the same record where job got aborted. Need Suggestions Regards Ne...