DSXchange

1) Check the target table for triggers, constraints, indexes, etc. These impact performance of loading a table no matter what the ETL tool. 2) Is your SQL action insert, insert else update, update else insert, update, etc. If youre doing inserts only, you SHOULD be using SQL*Loader. If youre doing i...

Scenerio: I am writing from a source file(no transform) to a OCI stage with 20 fields. The first 7 fields are key fields and they are setup as unique constraint key fields in Oracle. Per Informix/Ascential techs, I have the array size set to 1 and rows per transaction set to 1. I am not able to ache...

Hi, my name is Sal and I am new to the list. I have a few questions and hope that someone can share their experience on the matter. Currently, I am working with Datastage and I have run into a few problems. 1st - I am extracting data from a sequential source, the only problem is that some records in...

Hi All! This is the second help request on a problem that a customer of mine found with a DS job that read data from a several Oracle Table and load data in other several Oracle Table. Maybe giving some more information somebody could help me (HOPE). He has used OCI8 stage and the designe of the job...

Good Morning, Im trying to find out who out there is using DataStage and/or MetaStage on DB2 on either the mainframe or NT Server. Thanks, deb Deb Willamson DST Systems 816.435.5754

Hi all,

With dsjob i can start a job, but if the job abort, i need to go in Director reset the job.

There is any command, like dsjob, for reset a job?

Thanks in advance,

Nuno

Hi everyone, I have problem with a job that have several OCI8 like input stage containing some select, and several Target OCI8. I have Datastage 4.1 running on Compaq. Very often happen that the job abort with "Message: Abnormal termaination of stage VasJob.DCT_SAVAS_PROVINCE.IDENT1." where DCT_SAVA...

Try: MATBUILD row FROM Data USING "" That works for the one case you give, but if you wanted to access a second row, say Data(2,1):Data(2,2):Data(2:3) you would have to use: MATBUILD row FROM Data,start,end USING "" and do some arithmetic to get the start and end variables set up. In this case it wo...

Hi Kim, The best way to do this (move project to a different directory) is to do the following: 1) export all the jobs 2) delete the project in Administrator 3) install a new project. 4) restore the exported jobs. Regards, Anthony. --- "Kim,DaeHwan" wrote: > Hi All > > I have problem to move project...

This is a topic for an orphaned message.

> Hi, > > Im trying to access a whole row in an array in Universe basic. > > Basically I store elements like this: > Data(1,1) = A > Data(1,2) = B > Data(1,3) = C > > and I want to access all of a row in array Data, without having to > say: > > Temp = Data(1,1) :Data(1,2) :Data(1,3) > > Cheers, > We...

Hi All I have problem to move project into another directory. Previouse version datastage Can move project directory Update UV.ACCOUNT SET PATH = new directory where @ID = project name; and Verify.SQL Schema new directory and after, I can use project at new directory, but this version have problem t...

Good, thanks > -----Original Message----- > From: Ray Wurlod [SMTP:ray.wurlod@Informix.Com] > Sent: Friday, 17 August 2001 13:12 > To: datastage-users@oliver.com > Subject: RE: what this warning message means > > Yes, but its not recommended because it can lead to child-to-parent > signals not being...

Yes, but its not recommended because it can lead to child-to-parent signals not being received. So I am not going to tell you. Better would be to change your after-job subroutine to filter out messages containing the string "[Done]" - the entire message can be retrieved using DSGetLogEntry() functio...

Thanks. But I have a lot of these similar jobs running overnight. I checked them, not all jobs have this message, Actually, I have a After-job subroutine to send me abnormal job log message. Every day, there is one or two jobs sent me this warning message. Is there anyway to get rid of it? Xiong > -...