DSXchange

I have a DS job that has three transform stages, all writing to the same hash file. The job exceute SQL to access the MAX(BATCH_ID) from a number of Oracle tables. The first stage accesses a single table and completes in a second or so, and writes this row to the hash file after a delete/create of t...

Bobby, check your indexes on tablename. If curr_flg is not the initial field in an index, then you will be doing a table space scan on the whole of tablename to do each update. If the table is large, performance will be very bad. How large is the table? Please do an explain on your SQL to find out h...

Craig, could you define 'large' please? We do not clean up &PH& (so far!) and I find that we have about 4,000 files in this directory. I would assume that this could be causing us some grief?

Thanks,
Neil Courtney

Can the location of the standard doc_tool.mdb database be changed from the default C: drive directory to another local drive or network drive? Failing this, I could try to find an Oracle database somewhere with enough space free. If so, how can I do this? If not, I may get my disk partitioning chang...

It is the caching of the WITH data that is the main bit. This query is evidently done only once per session. With the query above that I am running now, it is returning all qualifying rows, so a correlated sub query would be just as good, or nearly so, I suspect. I am just using this as a test bed. ...

I am using an ORAOCI9 stage, and User Defined SQL query. Yes, it could be coded like that, but I have been told (by someone who knows much more about Oracle than I do at this time) that the WHEN clause is more efficient than the current normal join coding. Eg. SELECT ... FROM EK.key_table EN.name_ta...

I am trying to execute some SQL on an Oracle 9i v9.2.0.5 system using the WITH clause to use subquery factoring. I get the following message from DataStage. TestWithClause..ORA_LOOKUP: ORA-00904: "A_NAME": invalid identifier TestWithClause..ORA_LOOKUP.DSLink1: DSP.Open GCI $DSP.Open error ...

works a treat. Thanks Craig.

Sorry, should have said that this is on Win2K PC.

When I use director.exe the host system, user name and project name are saved (if the save settings box is checked of course). However, if I have two DS systems that are normally used, can I set up shortcuts so that I can start either or both sessions without having to do a lot of typing? (I object ...

The -100 might indicate that there are no records in the production table.

Are there any DB2 messages on the DSNMSTR log? Perhaps you have security issues.

Error code 911 would indicate that you are getting a DB2 deadlock or timeout error. It is probably actually -911. THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR TIMEOUT. REASON , TYPE OF RESOURCE , AND RESOURCE NAME Check on the DSNMSTR log for the reason, such as who was holding t...

Hi all, is it possable to check for an EOF condition on an input file? I have a simple job that reads a sequential file and writes another, after various lookups. I would like to be able to write to a third file, to record input and output record counts, and the value of various stage variables if r...

Hmm. Spoke too soon. On setting one field to NULLs, I now get the message "ORA-00001: unique constraint (P.PF003_TEXTKEY_INDEX) violated " So this would indicate that the initial DELETE statement could not delete the record. There was no message returned to indicate that this was the case....

Problem solved. And I have now learnt about the Update action option of "Replace existing rows completly". Null values are not a problem with this option, as far as I can see.