DSXchange

Can you formulate the relationship as an expression? If so, all you need to do is to use that expression as the reference key expression in your Transformer stage. If you are trying to say that the value you want to look up exists as a non-key column in the hashed file, your best solution is to crea...

I disagree. An ETL tool that is just a client of the database server can be set up to use the best features of any database server. A lot of work has gone into making DataStage fit this category. And the "plug in" architecture makes it easy to sustain, to introduce new database-specific features wit...

Could it have been the case that your parameter array size exceeded your rows per commit setting?

It works well with both. Ascential's boast is "any source, any target".

Any attempt to compare Oracle to Teradata is akin to comparing apples with oranges. They are different, have different requirements. DataStage simply acts as a client to either (and to others).

ArndW wrote:You need local admin rights to install any DataStrange clients

Provided that the linkages between the table definition and the job are intact it should be straightforward to extract the information directly from the table definition, which is stored in DS_METADATA. This could be facilitated by creating column definitions for the file dictionary of DS_METADATA. ...

The computer is incapable of doing anything but exactly what you tell it to do. Therefore, what you have coded is not what you expected to code. That is the main reason we need to see the code of the routine. Based on your description, it appears that the code is selecting the lesser of the two date...

The main contraindicator is that, while the index is dropped or disabled, no query can use the index and therefore will be much slower if constraining on the (non-)indexed column.

Try using a function such as Quote or DQuote. CALL DSExecute('DOS', 'echo SignonMake ' : Quote(ModelSignon) : ' PromptForPassword False UserId ' : Quote(DBSignonUId) : ' Password ' : Quote(DBSignonPwd) : ' >' : SignonMDLFile, sResult, sReturnCode) Beware (search the f...

Create the target file using a generic name then use an after-stage subroutine like this one to change the file name.

The ultimate reference is a book entitled Microsoft ODBC API Software Developer's Kit and Programmer's Reference published by Microsoft Press

5242880 is larger than 32000

Help About in any of the client tools will provide this information.

Try both and let us know. There are too many variables to make a blanket statement that "method X will be faster". When you publish your results, therefore, please also include the hardware configuration (including processor speed), job design information, and number and size of rows processed. Idea...

The hashed file name is then to be found as a property of a link connected to a Hashed File stage or a UV stage. If it's an Input link then you're writing to the hashed file, if it's an Output link then you're reading from the hashed file.