DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 29 matches
Author Message
 Topic: Update issue on Index columns:Oracle connector stage
ssreeni3

Replies: 5
Views: 375

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 07, 2017 12:47 am   Subject: Update issue on Index columns:Oracle connector stage
Thanks Chulett.

Is there any alternate way for this scenario?

Thanks,
srini
 Topic: Update issue on Index columns:Oracle connector stage
ssreeni3

Replies: 5
Views: 375

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 06, 2017 5:42 am   Subject: Update issue on Index columns:Oracle connector stage
Hi,

additional information.
Reject error code:0
Reject error text :row not updated - update mode

Thanks,
Srini
 Topic: Update issue on Index columns:Oracle connector stage
ssreeni3

Replies: 5
Views: 375

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 06, 2017 4:32 am   Subject: Update issue on Index columns:Oracle connector stage
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
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 nu ...
 Topic: Join Issue
ssreeni3

Replies: 2
Views: 744

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 14, 2013 7:46 am   Subject: Join Issue
Hi,
Pivot on Table B and Join.

I think this will work.

--------------
Sreeni
Resolved
 Topic: How to use Copy stage Force property
ssreeni3

Replies: 14
Views: 4243

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 22, 2013 8:27 am   Subject: How to use Copy stage Force property
How many OutPuts?
One or many?

-----------------------
Thanks,
Ssreeni3
 Topic: left join with between date condition
ssreeni3

Replies: 5
Views: 1254

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 13, 2012 4:55 am   Subject: left join with between date condition
Try this:
Please ensure In Sql query:
Between Minimum_Value AND Maximum_Value

Then It works properly.
---------------------------------------------------------------
Sreeni3
 Topic: Sort and Filter gives different results run to run
ssreeni3

Replies: 5
Views: 957

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 14, 2012 12:05 am   Subject: Sort and Filter gives different results run to run
Hi PPP,
Please specify the records of input,output and rejects for better understanding.
--------------------------------
Srini
 Topic: Remove unwanted character from file using any stage
ssreeni3

Replies: 6
Views: 1944

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 25, 2012 4:18 am   Subject: Remove unwanted character from file using any stage
Hi Sachin,

For column data:Transformer convert function
For entire file :unix sed command

--------------
Sreeni
Resolved
 Topic: SELECT distinct v/s Remove Duplicate Stage
ssreeni3

Replies: 6
Views: 2300

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Oct 11, 2012 1:30 am   Subject: SELECT distinct v/s Remove Duplicate Stage
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 ...
 Topic: instr in datastage
ssreeni3

Replies: 5
Views: 2199

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 05, 2012 1:36 am   Subject: instr in datastage
Hi deeplind,

That function is available in BasicTransformer stage.

---------------------------------------------------------------------------------
Sreeni
 Topic: Oracle UPSERT
ssreeni3

Replies: 9
Views: 2591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 05, 2012 1:27 am   Subject: Oracle UPSERT
Hi Experts,

Thanks for your inputs and valuble suggestions and openions.


Thnaks,
Sreeni
 Topic: Oracle UPSERT
ssreeni3

Replies: 9
Views: 2591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 02, 2012 11:41 pm   Subject: Oracle UPSERT
Thanks Ray for your reply.

My doubt is:
Which scenarios,we may give the same Select statement to the Update query also.

We are using Change Capture Stage in the Job.

Thanks,
Sreeni
 Topic: Oracle UPSERT
ssreeni3

Replies: 9
Views: 2591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 01, 2012 3:43 am   Subject: Oracle UPSERT
Correction to my post:
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 for Update?

I observed this in one ...
 Topic: Oracle UPSERT
ssreeni3

Replies: 9
Views: 2591

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 01, 2012 3:38 am   Subject: Oracle UPSERT
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 o ...
 Topic: Capture reject records
ssreeni3

Replies: 7
Views: 1693

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Sep 18, 2012 2:11 am   Subject: Capture reject records
Hi,

Oracle target stage has an option to capture the Oracle_Rejected data.

---------------
Sreeni
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours