Search found 15 matches
- Mon Aug 30, 2010 2:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataStage Error
- Replies: 1
- Views: 3445
DataStage Error
This is the error message I get when I run a datastage job: main_program: Internal Error: (infld): groupby/sortgroup2.C: 402 Traceback: [6] APT_FatalPath::pureAssertion(0xfc574fe9, 0xfc574fef, 0x192, 0x0, 0xff1aca78, 0x8), at 0xff0e68f0 [7] APT_SortedGroup2Rep::processReducers(0x5fac38, 0xffbfc7a8, ...
- Mon Jul 06, 2009 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage problem
- Replies: 10
- Views: 5654
- Mon Jul 06, 2009 10:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage problem
- Replies: 10
- Views: 5654
- Mon Jul 06, 2009 9:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage problem
- Replies: 10
- Views: 5654
Thanks for the replys guys custom sql is UPDATE test_table SET col2 = ORCHESTRATE.col2 WHERE col1 ORCHESTRATE.col1 and the warning the datastage is throwing is: ODBC_Enterprise_5,0: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00920: invalid relational operator Thanks for the quick repl...
- Mon Jul 06, 2009 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC stage problem
- Replies: 10
- Views: 5654
ODBC stage problem
H; I have a job which inserts records to an oracle table through ODBC statge. I wrote a custom sql. There was a syntax error in the sql while I ran the job. But the job just showed warning message for that error and showed finished status. It never showed Failed status with fatal error. Can you plea...
- Mon Sep 29, 2008 7:29 am
- Forum: Data Quality Best Practices
- Topic: IBM Live Audit
- Replies: 1
- Views: 16246
IBM Live Audit
Hi;
I need some help to find some material on IBM Live Audit. So please let me know if any online resources available for this software.
Thanks
Rajani
I need some help to find some material on IBM Live Audit. So please let me know if any online resources available for this software.
Thanks
Rajani
- Wed Apr 09, 2008 10:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ series to send messages
- Replies: 3
- Views: 3288
SWIFT can be a bear...if it were me I'd try to use MapStage, assuming that WebSphere TX is available at the account. WebSphere TX (former DataStage TX and before that the Mercator offering), comes with built in meta data maps (called Type Trees) that are out-of-the-box aware of all the SWIFT format...
- Wed Apr 09, 2008 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ series to send messages
- Replies: 3
- Views: 3288
MQ series to send messages
A file contains a bunch of SWIFT format messages, all bundled together into a single file. We need a DataStage job that can separate out these messages into individual messages, and send it via MQ. A single swift message is a section between "{1" and "-}" identifier, and both sho...
- Wed Mar 12, 2008 2:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject rows from a OCI stage to a sequential file.
- Replies: 1
- Views: 1575
Reject rows from a OCI stage to a sequential file.
Hi; I am loading some data from a sequential file to a OCI stage. I have also placed a reject file from the output of the OCI stage. I want to collect all the the records rejected by OCI stage into the reject file. The problem is for some errors like ORA-12899: value too large for column the job its...
- Fri Dec 07, 2007 6:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scheduling a DataStage
- Replies: 4
- Views: 3452
- Fri Dec 07, 2007 5:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Scheduling a DataStage
- Replies: 4
- Views: 3452
Scheduling a DataStage
Hi all,
Can we schedule a job to run every 15 minutes?
if so...can we schedule in the director?
if we cant schedule in the director; whats the tool we need to use for this?
Thanks in advance
Rajani
Can we schedule a job to run every 15 minutes?
if so...can we schedule in the director?
if we cant schedule in the director; whats the tool we need to use for this?
Thanks in advance
Rajani
- Sat May 26, 2007 7:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove duplicates stage and sort stage
- Replies: 6
- Views: 8262
- Thu May 24, 2007 12:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove duplicates stage and sort stage
- Replies: 6
- Views: 8262
Re: remove duplicates stage and sort stage
Hi thanks for the reply. I have gone through the manual. It doesnt give much info on specific differences. Can you please post those specific differences?
Thanks
Rajani
Thanks
Rajani
- Thu May 24, 2007 12:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: remove duplicates stage and sort stage
- Replies: 6
- Views: 8262
remove duplicates stage and sort stage
Hi all, Both Remove Dulplicates Stage and Sort stages perform the following operations: 1. Both Sort the data 2. Both remove duplicates. So I was wondering whats the ideal situation where we could use exclusively Sort stage or Remove Duplictaes Stage. I mean can you please explain me when have to us...
- Thu May 24, 2007 10:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential file and data set
- Replies: 2
- Views: 1854
sequential file and data set
Hi all,
Can any one please explain me the differences between a dataset and sequential file? In what ideal conditions they are used? where can I get more information about them?
Thanks
Rajani
Can any one please explain me the differences between a dataset and sequential file? In what ideal conditions they are used? where can I get more information about them?
Thanks
Rajani