Craig,
Thanks for your reply!
Yes, these are still server jobs in DS 8.1 Enterprise Edition. Yes, target OCI stage has 8 column mapped from XFM stage. Executing user has proper grant to the sequence object as well.
Search found 38 matches
- Wed Aug 24, 2011 11:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DATASTAGE Upgrade from Server 7.5.2 to Parallel 8.1
- Replies: 5
- Views: 4193
- Wed Aug 24, 2011 10:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DATASTAGE Upgrade from Server 7.5.2 to Parallel 8.1
- Replies: 5
- Views: 4193
DATASTAGE Upgrade from Server 7.5.2 to Parallel 8.1
Hi, We have migrated server jobs which were in DS 7.5.2 to DS 8.1 parallel version. Both of these versions installed on same Linux server. Some of the DS server jobs with OCI stage has user defined SQL. These SQLs first column is the oracle sequence next val for surrogate key and the remainder colum...
- Wed May 25, 2011 10:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reading 2GB CLOB Data from Oracle table through DataStage
- Replies: 7
- Views: 10070
- Fri Feb 25, 2011 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EXTRACT Numbers only
- Replies: 8
- Views: 5386
chulett - Thats exactly what I am looking for a new function which would do what the DIGITS does. But I dont know how to go about it. Writing a C program for this would be a too much to ask. There has to be a simpler way to check for numbers. Ray. I am not sure how to read the data in Hex format in ...
- Thu Feb 24, 2011 4:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EXTRACT Numbers only
- Replies: 8
- Views: 5386
- Thu Feb 24, 2011 4:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Performance Statistics of a job
- Replies: 5
- Views: 4310
- Thu Feb 24, 2011 4:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset corruption, SIGSEGV while reading
- Replies: 21
- Views: 18861
- Thu Feb 24, 2011 3:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EXTRACT Numbers only
- Replies: 8
- Views: 5386
EXTRACT Numbers only
We have data on a Teradata table and it contains Numbers followed by some thing (seriously something.. not space..not tab ..not sure what). Trim while selecting the data or Trim / StripWhitespace in datastage wont get rid of it. It was loaded from mainframe.. so may be someone goofed up. Thats not m...
- Tue Feb 22, 2011 11:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error using Built in transform
- Replies: 2
- Views: 1547
- Tue Feb 22, 2011 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error using Built in transform
- Replies: 2
- Views: 1547
Error using Built in transform
I am trying to use built in transforms in the transformer stage on Version 8.1 Parallel Job and keep getting the error variable not defined. I tried using different transforms to see if other works and the erorr is the same. DataTypeEbcdicPic9 --> Link DSLink40, Column NewColumnTest: DataTypeEbcdicP...
- Fri Mar 05, 2010 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: version 7 and 8
- Replies: 5
- Views: 3473
- Thu Mar 04, 2010 2:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: version 7 and 8
- Replies: 5
- Views: 3473
- Wed Apr 22, 2009 10:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Create table& Create index under User-Defined DDL
- Replies: 7
- Views: 3182
- Wed Apr 22, 2009 9:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Create table& Create index under User-Defined DDL
- Replies: 7
- Views: 3182
Create table& Create index under User-Defined DDL
I crearted this script which runs fine from SQL Navigator.But When I use it under User Defined DDL, I am getting a runtime error. The error is TEMP_TABLE_OCI: ORA-00911: invalid character How can I make it work ? here is rthe script I am using CREATE TABLE SCT003_CASE_BNFT_TEMP ( GRP_CASE_ID DECIMAL...
- Fri Apr 10, 2009 9:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multi valued Column in Hash File
- Replies: 20
- Views: 15760
I Created it using the hash file stage. But I did not see that option to make it multivalued, and I thought that was ok as per Ken's post , but he made a mentioned about later updating the dictionary. As you mentioned in your post about using the ED command for updating the dictionary, a sample woul...