Search found 116 matches
- Sun Jan 26, 2014 11:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to replace sort stage for huge volume data?
- Replies: 4
- Views: 4247
- Mon Oct 07, 2013 12:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while executing a sql server stored procedure
- Replies: 7
- Views: 6447
- Wed Jun 05, 2013 9:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue with Date format in SP
- Replies: 12
- Views: 6852
- Tue Jun 04, 2013 10:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue with Date format in SP
- Replies: 12
- Views: 6852
- Tue Jun 04, 2013 10:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: issue with Date format in SP
- Replies: 12
- Views: 6852
Can you post some additional information? You said your input is XML? What is the datatype and element you have given in column mapping in stored procedure stage. How the XML is sent as input to stored procedure stage? Whether column value in dataset or XML output stage? Above all this could be your...
- Mon Jun 03, 2013 11:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Upsert LOB values to Oracle table using Oracle Connector
- Replies: 8
- Views: 3756
- Mon Jun 03, 2013 11:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to solve this scenarios using Transformer
- Replies: 6
- Views: 3039
- Fri May 31, 2013 3:03 am
- Forum: IBM QualityStage
- Topic: Latest record to survive
- Replies: 10
- Views: 8534
- Thu May 30, 2013 11:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Poor performance - Extracting Oracle Table
- Replies: 9
- Views: 6356
- Tue Apr 16, 2013 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure - Forward Row Data -> doesn't work!!
- Replies: 6
- Views: 3480
- Tue Apr 16, 2013 8:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Tune a query with where clause that has a function
- Replies: 6
- Views: 2780
- Tue Apr 16, 2013 8:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure - Forward Row Data -> doesn't work!!
- Replies: 6
- Views: 3480
Doesnt it sound interesting. Your question made me to explore more on the stage, and here it is what i have read http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.conn.stp.doc%2Ftopics%2Fr_cstpref_Managing_Cursors_Correctly.html So in our case, is the cursor exter...
- Thu Apr 11, 2013 9:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transform Function
- Replies: 4
- Views: 3614
- Thu Apr 11, 2013 9:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure - Forward Row Data -> doesn't work!!
- Replies: 6
- Views: 3480
- Tue Apr 09, 2013 11:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Issue Stored Procedure Vs Datastage
- Replies: 6
- Views: 4380
the the very first Select Query (join across 3 tables) that fetches the 4.5 M records takes about 6.5 Mins Imagine what is happening here. An ODBC connection is created. The query is submitted. For array size that you have mentioned, it will get those records from the database. Database server and ...