DSXchange

Having a problem when trying to use the Update Action. 'Insert new or update existing rows'. One of the Key fields is = NULL, and when the record already exists on the file and an Update is actually required, Datastage cannot find the record, so tries to do an Insert but fails. I have noticed that j...

In the Transformer I am tring to do a division and the answer keeps truncating

ie 1 / 3 = .33330 The scale we specified was 5.

Any ideas how we could get .33333

Thanks

I was thinking of some sort of SQL to count the number of rows the reference table returned for each look up and maybe creating a Hash table with that info, but was wondering on the use of system variables such as @INROWNUM or @OUTROWNUM to calculate ??

You can look up multiple rows from the reference table. The rows are selected by a foreign key , but is there a way of counting up the number of returned rows for each key.

We need the infomation in the lookup Transformer.

Thanks

When debugging a job, I get this message randomly
'debugging client has discontected' and the deugger aborts.

What is the reason for this

Thanks

Thanks Ray,

I was looking at the wrong odbc.ini file

Have updated

OK, needs more explaination...

In development I am set up to be able to read certain databases. They used to all be in the odbc.ini file, now I just need to add a database I want to read from another server.

It is set up in the Data Sources (ODBC) in admin tools already

In Windows ???

I don't understand.

In the old days we used the odbc.ini file to define connections to different servers, so we could attach to new databases in the ODBC stage. We used uvodbc.config to change the 'dropdowns'. Now, in vers 7.2 the odbc.ini does not individually have all the connection details. Where is this entered now...

The key is NULL did not work , and we had trouble with the OCI stage, so we went with the User Defined SQL using the NVL option. Works beautifully

Thank-you

The key data is very clearly defined, is there anyone else who can help with this problem

Thanks

When inserting a record using the Oracle ODBC Stage originally, where a column of the key is NULL, the insert goes fine. But when it comes to updating this record, ODBC gets confused and can't seem to update. It is like it cannot recognise that the record exists. If the coulmn which is NULL is actua...