DSXchange

Hi all, I have faced with the strange behavior of DataStage 5.2 when it connects to DB2 on NT. I have a machine with installed DB2 v7.2 and DS servers witch is not a domain controller. I have two jobs that insert data into DB2 database. If I run them sequentially all works fine but if I run them in ...

Hi, We are using Datastage/390 4.2.1 and are moving to Datastage/390 5.2. We are encountering issues in both DS worlds when casting date items that are not valid dates. (Uncontrolled source data). Our CAST results are inconsistent. ie. when invalid we are either returned a value of Null or the previ...

Hello Carol

A common problem Ive found with sequential read files is
the file type is set to DOS when it should be UNIX and
visa versa. Can you view the data in the view-data option?

This function should work for you.

Regards
Martin Battaliou
DOT Group

Hi All! It looks like Universe is using server side cursor when I connect to SQL Server. When you use server side cursor, ADO sends sp_prepare to SQL Server which involves a nText parameter. Microsoft does not support nText in its ODS library which my application is built upon. The workaround is to ...

Hi, delete.file hashfile The hashfile is case sensitive. regards, aedla. -----Original Message----- From: Benoit_Murray@dmr.ca [mailto:Benoit_Murray@dmr.ca] Sent: Wed 8/7/2002 5:26 PM To: datastage-users@oliver.com Cc: Subject: Delete Hashed File Hi everyone. How can I delete an Hashed file ? The be...

Hi everyone.

How can I delete an Hashed file ? The best & clean way ?

Thanks in advance.

Ben

In order to pass both the LOW_VAL and HIGH_VAL from the transformer stage to the UV lookup stage, you will need to define a couple of dummy columns in the UV stages table definition. These columns can be given any old derivation - eg, use a constant value of 1. Set them as keys to the table, and uns...

Carol - you dont mention a platform. Perhaps you could tell us more about your platform and how the source file was created. Maybe worth looking at the file with a HEX editor to make sure there arent any unexpected characters there. Is (are) the line termination character(s) appropriate to your envi...

This is a topic for an orphaned message.

Try doing: ps -ef |grep "uvcs" ucvs are client sessions. Chances are you have processes out there still showing as connected. A uvcs and uvapi_slave are usually associated to each login. There is an internal file (DS_LICENSE) that the DS engine puts entries into each time someone connects. Youll hav...

Hi all, Because I got a message ""All available licenses in use:406440-DSDES Limit=3" when I start DS(designer, director or manager) even NOBODY connect to server--I checked by using netstat -a |grep unirpc So I would like to know how user limit in client license work. It counts number of concurrent...

If you use a UV stage or an ODBC stage, you can tell it to return multiple rows (link properties within the transform stage). You would need to change to a user-defined query so that you use a between in the where clause of the query. You can do this in 4.1 - you dont need to wait until 5. -----Orig...

This is a topic for an orphaned message.

The fact that you are getting duplicate records tells me that you do not have a primary key defined in Oracle. You need to do this - for both functionality and performance reasons. When you do an "insert or update" it does the following: * Attempts an insert * Asks Oracle how any rows were processed...

There is no TCL command to do as you want; its manual at best. Just recreate the project account on the new hardware, then copy (using ftp or rcp) all parts of the hashed files to that new location (remember that a hashed file consists of a directory name, two visible files DATA.30 and OVER.30, plus...