DSXchange

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, ...

Warning

yes thats right. My sql has an error. But this error is not shown as fatal warning in the director when I run the job. It just shows as message

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...

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...

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

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...

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...

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...

Thanks for the quick replies buddies

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

Thanks for the replies. These postings really helped me.
....Rajani

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

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...

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