DSXchange

Another possibility is to reverse engineer the xml file generated. Then, based on some template job (for example) you can create an xml file that suit you needs and import it using the manager... This way, you can create job without using designer, but it is really tricky Ok, I don't know if I unde...

direct=FALSE on the sqlldr command invocation Hi Kenneth, I must be missing something.... :? I have an ORAOCIBL icon in a DS job and I do not see where I can set direct=FALSE in any of the settings for the icon. I see properties like service name, user name, password etc but I do not see 'direct'??...

Just some quick points... "Direct path" *is* sqlldr, it is one of two load options - Conventional or Direct Path. Conventional is the slower of the two, obeys constraints and indexes as it goes. Direct Path is faster as it (in essence) defers the constraints during the load which makes it...

Hi, Can any one please tell about about features what Ascential Data Stage MVS provides that can help with the following for very large data loads that will require initial loads plus incremental updates: Describe the checkpoint/restart safeguards we are putting place in the conversion that will en...

Hi, I'd like to know how can I generate job's structure without using DS Designer. Do you know any language or method to do that? I know that we can import .dsx or .xml files but first we have to create nad export jobs from DataStage to create this files. For example, I would like to build this fil...

Surely it's the Oracle DBA's job to know about these things? That's the person whom you should ask. Did you try Ask Tom ? And, no, I've never seen that message. Here's output from oerr . $ oerr ORA 26028 26028, 0000, "index %s.%s initially in unusable state" //* Cause: An index is in IU s...

Hi I have a developed job which checks for space and also ??(which i cant interpret) if stringisspace(input.column) or inp.col="" then trim(lkp.column) else " " does that above statement mean its checking for NULL ? If thats NULL, whats an empty string ? does empty string has an...

Hi All, just wondering if anyone has ever seen this message before. I haven't. Situation is we are loading a couple of years worth of history for a transaction file. We have split the work into pieces because daily updates will be incremental so we only allocated the disk for incremental updates and...

I also notice that when a table load has failed then sometimes there are no records in the table. And I would have expected/guess that some rows multiple of 10,000 rows should be there (rows per transaction * parameter array size). I am not sure how often the ODBC stage commits. Just an FYI - 'Rows...

Could anybody please suggest or pass on some info about how they dealt with a situation like the one below. We are in the process of loading the data from PeopleSoft financials to the PeopleSoft DataWarehouse, we have some huge tables which have millions of rows of data sitting in and millions of r...

Ray, This is what I found... When I try create a flat file from Mainframe DB2, system was able to create a file at the rate of 600 rows per second... The same file I used and outputted to other flatfile on the sever, it was processed at the rate of 3900 rows per second. It seems like ODBC/network i...

Hi Guys, I am running initial loads of a DW and running millions of millions of rows at a time....in some cases rows are written away to the same oracle table. I have set Rows per transaction to 1000 and parameter array size to 10 and isolation level to 'None'. I am getting occasional deadlocks in O...

Hi dzdiver, we are using the data direct drivers and they do in fact document the fact that they truncate significant digits to 15 digits for a float.....The problem is with ASCL and they have agreed they have a problem and have even replicated the problem. We will probably just have to convert the ...

Hi Craig, thanks, I heard about this from another source. The last time I talked to these guys they said they 'replicate' and not 'propagate'. We are currently still recommending to the client to go with triggers... Peter - on the off chance you are still in search of information on this topic, you ...

Hi All, Is it possible to invoke a DataStage Job from outside its environment using any other job control tools (Tivoli or Control M) or independantly like an executable script. Thanks , Tom Tom, I have published the C++ code required to invoke DS jobs. (I've also published a scheduler to run any c...