DSXchange

I installed the NT version of Datastage, and then exported my project from the Unix version and imported it to the NT version. The release notes of Datastage says that if you are using Redbrick, you must add the line DISABLE_INFO=YES to the rbodbc32.ini file, if you want to suppress informational me...

I think the file is called "uniapi.ini" in the c:winnt directory ...... -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Tuesday, November 06, 2001 12:56 PM To: datastage-users@oliver.com Subject: RE: NT ? Does this mean the NT version does not have a dsenv file ? On Un...

Hi Pedro, no unfortunatly our customer uses the update action "Truncate table then insert rows" under the OCI stage. He doesnt use user defined SQL query. Thanks Patrizia ----- Original Message ----- From: "pedro santos" To: Sent: Tuesday, November 06, 2001 1:40 PM Subject: Re: DataStage Fatal error...

Pedro, There is an option in the OCI stage "Truncate table then insert rows". It is quite different to "Replace rows completely". Patrizia, The truncate and insert option will cause a truncate (which is different to deleting all rows) to be executed before the first row is written. Im not sure of th...

Do you use the truncate statement in an user defined sql query? If so you may try removing it from the statement and chose a new update action thats under the general tab in the OCI stage, i guess the option you must choose is replace existing rows completely. Please correct-me if im wrong. Best reg...

Hi Pedro, the problem is that our customer uses the OCI option truncate then insert rows. He doesnt use truncate and insert in two separated stages. Thanks Patrizia ----- Original Message ----- From: "pedro santos" To: Sent: Tuesday, November 06, 2001 12:58 PM Subject: Re: DataStage Fatal error caus...

Hi, im no expert but, when you truncate a table you are deleting all the records in that table, so the data base engine needs to lock the table in order to clean the table, you must wait for the truncate instruction to finish. Please correct-me if im wrong. Cheers: Pedro >From: "Patrizia Vitali" >Re...

Hello everybody, I would like to know if the update action "Truncate table then insert rows" used in the OCI stage, puts locks on the table before starting the insert (Oracle NO WAIT command). We have a customer whose job aborted with the Oracle message ORA-00054 (resource busy and acquire with NOWA...

Does this mean the NT version does not have a dsenv file ? On Unix this file is used to set environment variables for Datastage, for example: DS_MMAPPATH=/usr/Ardent/tmp; export DS_MMAPPATH .... this is the directory where sort files are created. There must be a place where I can set up my environme...

Hi everyone, I have just installed the NT version of Datastage (server agent). Where do I find the dsenv file for NT? Im going through the manuals but havent found it yet. Dirk Dirk Moolman Database Administrator Reach Technologies South Africa www.thefuelgroup.co.za "No pessimist ever discovered th...

No, I have long given up hope that this feature will be added - even though in some performance tuning notes I have say that it is more performant to have one transformer stage in a stream rather then many linked togther - and you do have to duplicate logic and processing - and there is a bug in tha...

I have a couple of jobs which each have about 10 or so ODBC inputs using the Visual FoxPro ODBC driver (Windows 2000) to read from dBase files (this is the only form of export available form the source system - written by engineers). These 2 jobs will typically be running at the same time. I have a ...

We are using OCI 2.3. >What OCI plug-in are you using? > >Cheers, >Paul. > >-----Original Message----- >From: kuan@clear.net.nz [mailto:kuan@clear.net.nz] >Sent: Tuesday, 06 November, 2001 2:37 p.m. >To: datastage-users@oliver.com >Subject: RE: Reporting on rows updated in database > > >Paul > >We u...

Hi Ray, We are using OCI v3.0. I think that different versions might have something to do with it. Cheers, Paul. -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Tuesday, 06 November, 2001 2:27 p.m. To: datastage-users@oliver.com Subject: RE: Reporting on rows updat...

Well, there goes that theory then. Need to look further afield; version of Oracle perhaps, or some configuration issue. Getting outside my area of expertise, but others on the list may be able to help. -----Original Message----- From: kuan@clear.net.nz [mailto:kuan@clear.net.nz] Sent: Tuesday, 06 No...