DSXchange

OKay... That generated UPDATE P.PF003T00 SET FIELD1 = ?, FIELD2 = ?, FIELD3 = ?, SOURCE_SYSTEM = ?, CUST_NBR = ? WHERE (FIELD1 = ? AND FIELD2 = ? AND FIELD3 = ?); without the quoted variable. So even though the FIELDx colums were defined as indexed, it wants to update them. No problems, I can live w...

Hi Ray, thanks for the hints. I tried quoting the ? as indicated, but this did not work. I have tried with and without specifying Key=Yes for the FIELD1 etc. I have tried reordering the column names in the record description so that SOURCE_SYSTEM, CUST_NBR are first, and FIELD1 etc are first (clutch...

I am trying to execute an update statement in an ODBC stage, and get a message 'SQLExecute failed...'. The update statement is: UPDATE P.PF003T00 SET SOURCE_SYSTEM = ?, CUST_NBR = ? WHERE ( RTRIM(NVL(FIELD1,'~~~~')) = ? AND RTRIM(NVL(FIELD2,'~~~~')) = ? AND RTRIM(NVL(FIELD3,'~~~~')) = ?) The full me...

Jim,
the full membership list CAN be sorted by the number of posts. The number 6 to 10 are as follows:

6. Teej 375
7. roy 222
8. ariear 173
9. JDionne 162
10. mhester 156

Cheers,
Neil.

thanks Craig and Kenneth. I will digest these posts and do some experimenting.

Are there any ROTs with respect to hash file performance? For example, if I have a hash file with the following attributes: RL= 180 approx (includes a 100 char varchar name field) Records - 750,000 Dynamic, Min modulus = 1. DATA 30 file size 30MB approx OVER 30 file size 9MB approx. Assuming that th...

Unfortunately, this approach will break down if you have more than one non-null value. What would the best way be to handle data such as:

1234 NULL
1234 5678
1234 6789

The answer will probably be "It depends". Will a generated rowid be useful?

You don't need the rows with NULL in col2.... . Yes you do need the NULL values. What Rahul wants it to return a NULL value with a FOUND condition, if this is the only row availabe for the particular value of col1. If there are rows as specifed above, with NULL and also a value of 8888 in col2, the...

Well, I have given the ClientSwitcher a good shot, but have failed to come up with a working solution. I still get the RPC message. As TJ says, perhaps it will only work for v 5, 6 and 7 (for me). Vladimir's comment on the difference in RPC program names may have something to do with my problem. Whe...

thanks Tony. I did try this, and the C:\Program Files\DataStage... files happily go into their own directory. It is the C:\Ascential\DataStage... files that you don't have any control over.

Wow, this forum is quick! Thanks Ray. I did not want to have two PCs on my desk, but I have the need now. Cheers. (and some amunition to get us off 4.2...).

Is it possible to run multiple version of DataStage client on a Win2K machine? I have installed DataStage 6.0 over 4.2 and get the RCP not started message when trying to run 4.2. Version 6.0 runs fine (as you would expect). Failed to connect to host: neon, project: apmptst (The connection was refuse...

On v5 I think you will find it is named dsexport. This is what we use on v4.2.

Cheers, Neil

I found the answer in the archives. Thanks to whoever put the answer on someone elses thread. Works a treat.

I am running SQL using DS Server 4.2, Oracle Transparent Gateway, with a target system running DB2 v6.1 on OS/390. When joining several tables I have found many situations where DB2 is executing the SQL one table at a time, using a table space scan, and transferring ALL of the data back to the serve...