DSXchange

Welcome aboard.

We do not hijack threads with questions irrelevant to the thread.

Please post a new topic with this question.

DataStage clients connect using a model based on the RPC mechanism found in UNIX. The dsrpcd process listens on port #31538 (by default). When a connection request comes in from a DataStage client that request is to use the dscs (DataStage Common Server) service. The dsrpcd daemon looks in its servi...

Data Set is faster because no translation (export/import) is required. Both a File Set and a Data Set will use more space than a sequential file because, among other things, they include information related to the partitioning and sorted order of the rows they contain. Storage of unbounded VarChar d...

Ah, more information. How large are these XML files?

Check with IBM that you have a valid (that is, uncorrupted) license XML file.

What are you DOING in the Oracle stage?

Without knowing that the reason for a core dump is impossible to guess.

Have you had your support provider analyze the core file?

You can wrap your drawing in Code tags to preserve spacing.

Can you please post the generated OSH for this job? It may help to solve your issue.

Does not the ODBC Enterprise stage allow you to use user-defined SQL and, if so, why can't you use CALL in your user-defined SQL?

The DataDirect ODBC drivers that ship with DataStage have an inbuilt trap - they work for 30 days then stop working, giving you this error message instead. Yes you can call stored procedures through an ODBC stage, and the drivers are licensed for use with that stage type.

Insert the delimiters THEN invoke StringToTime(). Or specify a time format picture of "%hh%nn%ss" (without delimiters, you will observe) when invoking StringToTime() with the original string.

Not for THE most recent. Use an event type filter of "started" to get the first event ID in the current run. Then simply subtract 1 from that - you may get it immediately or you may have to step back over a couple of auto-purge entries.

Send money to DataDirect for a license to use the driver.

Yes, by looking in the job sequence's log. You can do this "by hand" or using the DataStage API - DSGetNewestLogId() find the start of the current (or most recent run) and you can backtrack from there (at most three records) using DSGetLogEvent() to find the "finishing" event from the previous run.

Do you records really have a final delimiter? (This is not the same thing as a record delimiter.)

It should be in the .odbc.ini file referred to by the ODBCINI environment variable.