Thanks Chulett.
Is there any alternate way for this scenario?
Thanks,
srini
Search found 29 matches
- Thu Dec 07, 2017 12:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update issue on Index columns:Oracle connector stage
- Replies: 5
- Views: 5169
- Wed Dec 06, 2017 5:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update issue on Index columns:Oracle connector stage
- Replies: 5
- Views: 5169
- Wed Dec 06, 2017 4:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update issue on Index columns:Oracle connector stage
- Replies: 5
- Views: 5169
Update issue on Index columns:Oracle connector stage
Hi, I have 6 columns in Table.No primary keys. But unique index is created on first 5 columns. I tried to update the table by taking these 5 index columns as key columns. 2 index columns have null values. I have taken Oracle connector for Update. Job went fine with no warnings.But record is not upda...
- Tue May 14, 2013 7:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Issue
- Replies: 2
- Views: 2081
- Mon Apr 22, 2013 8:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use Copy stage Force property
- Replies: 14
- Views: 10322
- Thu Dec 13, 2012 4:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: left join with between date condition
- Replies: 5
- Views: 4237
- Wed Nov 14, 2012 12:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort and Filter gives different results run to run
- Replies: 5
- Views: 3894
- Thu Oct 25, 2012 4:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove unwanted character from file using any stage
- Replies: 6
- Views: 4901
- Thu Oct 11, 2012 1:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SELECT distinct v/s Remove Duplicate Stage
- Replies: 6
- Views: 4667
Hi jerome_rajan, My opinion is: 1)Oracle DISTINCT keyword treats first record in the group as a unique record and the remaing records in that goup are duplicate records of the first record based on the value/values of key/keys used in the DISTINCT. 2)RemoveDuplicate Stage has an options Retain First...
- Fri Oct 05, 2012 1:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: instr in datastage
- Replies: 5
- Views: 6355
- Fri Oct 05, 2012 1:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle UPSERT
- Replies: 9
- Views: 6172
- Tue Oct 02, 2012 11:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle UPSERT
- Replies: 9
- Views: 6172
- Mon Oct 01, 2012 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle UPSERT
- Replies: 9
- Views: 6172
- Mon Oct 01, 2012 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle UPSERT
- Replies: 9
- Views: 6172
Oracle UPSERT
Hi Experts,
Already a select statement is there for Insert Query of Target Oracle stage whose mode is UPSERT.What happens if we write the same query with select statement for Update Query?
I observed this in one of my existed jobs.Is there any specific meaning for it?
Thanks in Advance,
Srini
Already a select statement is there for Insert Query of Target Oracle stage whose mode is UPSERT.What happens if we write the same query with select statement for Update Query?
I observed this in one of my existed jobs.Is there any specific meaning for it?
Thanks in Advance,
Srini
- Tue Sep 18, 2012 2:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Capture reject records
- Replies: 7
- Views: 5360