Search found 186 matches

by hargun
Sat Jun 04, 2011 3:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data insert issue
Replies: 4
Views: 2108

sorry craig......

i really apologize for putting post in capital letters i have changed to lower case can you please reply me know
by hargun
Sat Jun 04, 2011 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: data insert issue
Replies: 4
Views: 2108

data insert issue

hi i have question my job design is as follows: seq file..................> merge stage..............>odbc(DB2 database1) odbc......................> . SVR.PORTF . .reject . . odbcs (DB2 database)SVR.PORTF in seq file i have columns account, Collatral, markt_val amt,PORTF_NM(account:collateral) In o...
by hargun
Mon May 30, 2011 9:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data insert multiple times in target database
Replies: 9
Views: 6278

hi craig,

i want the unique record not the duplicates of record in target DB2 database.

i am doing only insert opeartion and try with other insert+update operation too giving me the same result.

Can you advice me please...
by hargun
Mon May 30, 2011 9:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data insert multiple times in target database
Replies: 9
Views: 6278

hi, My target database is DB2 .Here is my job design. Seqfile........> MERGESTAGE......>XFM...........> DB2 DATABASE ODBC .........> IN TARGET DATABASE I AM DOING ONLY INSERT OPERATION AND AFTER RUNNING JOB AGAIN SAME DATA INSERT AGAIN. IS IT THIS ONE HAPPENS DUE TO MERGE STAGE OR I HAVE TO USE LOOK...
by hargun
Sun May 29, 2011 4:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data insert multiple times in target database
Replies: 9
Views: 6278

Data insert multiple times in target database

Hi, I have a question like in my job design .Its a very simple job i am just extract the data from sequential file and load it into target database with same hard code values and the job is run fine but the problem is whenever i run the same job 2 or3 times again the same data insert in 2 and 3 time...