Search found 102 matches
- Fri Sep 23, 2016 9:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Date - Format issue
- Replies: 2
- Views: 2142
- Fri Sep 23, 2016 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Date - Format issue
- Replies: 2
- Views: 2142
String to Date - Format issue
Hi, I need to convert incoming String to Date. The format of the string is "Month dd, yyyy" Ex: (November 29, 2012). I used below function and job got aborted with error " Invalid type: November 29, 2012." StringToDate(Input Column,"%mmmm %dd, %yyyy"). Please help on th...
- Tue Aug 02, 2016 12:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File format issue
- Replies: 1
- Views: 1724
File format issue
Hi, I need to extract data from a source file. Format of the file is as below COLUMN - A|B|C|D|E ROW1 - 45|56|67|23A|| ROW2 - 45|56|67|23A|| ROW3 - 45|56|67|23A|Sam ROW4 - 45|56|67|23A|Martin ROW5 - 45|56|67|23A|Sunny ROW6 - 45|56|67|23A|Keaubu I'm using Sequential file stage to extract the data and...
- Tue Apr 19, 2016 11:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: '#' in Where condition value of Oracle Query
- Replies: 2
- Views: 1954
- Mon Apr 18, 2016 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: '#' in Where condition value of Oracle Query
- Replies: 2
- Views: 1954
'#' in Where condition value of Oracle Query
Hi, I'm using an Oracle query where one of columns in Where condition has '#' in value. The query runs fine in Toad or SQL Developer but is failing in the Oracle Connector. Please help. Original Query: ************* SELECT * FROM TABLE_A WHERE COLUMN_A = 'AB CDE #' AND STG_ETL_BATCH_ID = 1 Query in ...
- Tue Mar 25, 2014 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query on SCD Stage
- Replies: 1
- Views: 1793
Query on SCD Stage
Hi, I'm using SCD stage for Type 1 Dimension. As part of daily load, we have inserts and updates to the Target Table. Please help on how to identify the inserts and updates from the Output of SCD stage. For Type2 dimensions, we can identify based on Change Indicator but for Type 1, i'm unable to fin...
- Thu Dec 19, 2013 10:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Error
- Replies: 2
- Views: 4941
- Wed Dec 18, 2013 1:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Error
- Replies: 2
- Views: 4941
Teradata Connector Error
Hi, We are extracting data from a Flat file and loading to Table A. In the After Sql, we wrote a Merge query to Upsert data into Table B (which is a archive of Table A). Insert statement for Table A is running fine where as the Merge query for Table B is failing with error.."RDBMS code 2802: Du...
- Tue Nov 26, 2013 9:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Deadlock Issue
- Replies: 9
- Views: 10136
- Mon Nov 25, 2013 1:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Deadlock Issue
- Replies: 9
- Views: 10136
- Mon Nov 25, 2013 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Deadlock Issue
- Replies: 9
- Views: 10136
- Mon Nov 25, 2013 9:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Deadlock Issue
- Replies: 9
- Views: 10136
- Mon Nov 25, 2013 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Deadlock Issue
- Replies: 9
- Views: 10136
- Mon Nov 25, 2013 8:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Deadlock Issue
- Replies: 9
- Views: 10136
Oracle Connector Deadlock Issue
Hi, My Datastage job loads data to Oracle table with below properties Write Mode: Update then Insert Table Action : Append Record Count : 100000 Array Size: 2000 Today the job failed (Update Query failed) with Deadlock issue "The OCI function OCIStmtExecute returned status 1. Error code: 60, Er...
- Fri Oct 04, 2013 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Connector Stage Error
- Replies: 1
- Views: 7108