DSXchange

Use ODBC or Universe stage to return multiple row for lookup

Hi shyju,
You have answered your question!. Make the parameters required for database connectivity as job parameters for e.g. in OCI stage the database name, UserName and password. Discussion on setting this job parameters as project specific parameters and more is in FAQ posted by Vincent.
HTH

If your DBA still couldn't help you, then you could consider splitting your load into smaller segments. Load the data into sequential files and then you could bulk load them into Oracle. Thus overcoming the rollback segment constraints. If you think that would be useful search for posts by kcbland o...

In the sequential file stage you have option to define your quotes. If you have given single quotes change it to double quotes and request whoever that provides you the files to maintain consistent quote character. I suppose the quotes were provided in the file because of the embedded piping symbol ...

Log into the DataStage administrator, go to the Projects tab and select the project and click on the 'Command' button. In the command editor, type your basic command. HTH.

Sainath, The DSGetLinkInfo function returns the number of rows that passed down a link if you specify the infotype DSJ.LINKROWCOUNT. When the link is not in the same job then you write a routine to first invoke DSAttachJob to get the rowcounts as you have already found. When you have the rowcount re...

You should be able to connect to Oracle 10g from a OCI9 plugin. Did you mean, you uninstalled the OCI plug in itself? I would guess you have to install the plug-in as thats what the error message says.
HTH.

Dynamic Relational Stage was leveraged for Peoplesoft to have a job to run on any of the supported databases. It supports ODBC connections too. Read more of that in the plug-in documentation.

Yes you can. There had been a number of discussions on this here. Sure if you searched on the topic you could find all you need.

Before that, did you have a chance to estimate the cost of the query using toad or quest central when you added a third table to the join?

Before that, did you have a chance to estimate the cost of the query using toad or quest central when you added a third table to the join?

In the logs - In the Director. You should see something like: HTH

When you installed the server in Unix, odbc is usually installed too and a dsn entry called localuv would have been configured for you. You could use that to load hashfiles as Universe tables in your Universe stage.
HTH

If you are trying to insert a BLOB in a stage that was selected from a upstream stage then you cannot do that since the pointer becomes invalid. This is true in Oracle but I am not sure how it is in DB2. Anyways you could try loading the BLOB into a seqential file and then insert into table from fil...

Hi ArndW, None of the icons of the Transformer serves this problem..If i am not wrong the link execution order is not related to this... :( The posts subject says its Output link order :? . Is your problem is one of GUI representation? If thats so try dragging the transformer's and other stage's ed...