DSXchange

It depends what version of DataStage and which platform you are on. If on UNIX then there used to be a problem (I dont know if it still is or not) where if you had a batch that called jobs in a loop, then the child processes that had finished would become processes. This resulted in the maximum numb...

Thanks David. It worked... Regards, YN --- "David T. Meeks" wrote: > At 02:51 AM 12/21/01 -0800, you wrote: > >Hi All, > > > >I am very new to universe. I am dropping and > creating > >a table and then inserting rows using universe > stage. > >The job crashed with this error message (the job > had >...

At 02:51 AM 12/21/01 -0800, you wrote: >Hi All, > >I am very new to universe. I am dropping and creating >a table and then inserting rows using universe stage. >The job crashed with this error message (the job had >ran fine on earlier occasions): > >DSD.BCIOpenW call to SQLPrepare failed. >INSERT IN...

Hi all Im running DataStage on an Intel platform running Windows 2000. The DataStage Server is operating satisfactorily, however, the client has become exceedingly slow. I have reinstalled the client on my workstation, but to no avail. Is there anything to look out for as far as the client response/...

Hi All, I am very new to universe. I am dropping and creating a table and then inserting rows using universe stage. The job crashed with this error message (the job had ran fine on earlier occasions): DSD.BCIOpenW call to SQLPrepare failed. INSERT INTO "XXX" ("Field01", .... SQLSTATE=S1000, DBMS.COD...

Nuno, Transaction Size exists for compatibility with versions earlier than 3.0, and is ignored for later versions where you should use Rows per Transaction on the Transaction Handling tab. It seems that if you are upgrading a job that has a value in Transaction Size, it determines the rows/transacti...

What was the verdict on this problem? We too, are experiencing DS jobs aborting, with no real error messages or reasons for the abort. We have just been resetting and restarting the jobs. Its happening primarily on jobs that we have running in a continuous loop all day long. These jobs will abort ty...

Hi Tjomme, Consider splitting the primary data in the transformer according to primary input column 3 being null and not null and pass this to different output streams. Then in the stream where the third column data is null, add the lookup and only make column 2 as the key column. In the selection w...

Thanks, it works! > -----Original Message----- > From: YN [mailto:yn_ds@yahoo.com] > Sent: quarta-feira, 19 de Dezembro de 2001 8:57 > To: datastage-users@oliver.com > Subject: Re: Informix query > > > Hi Nuno, > > To the bext of my knowledge, you need to pass the > parameter twice. > > I dont have ...

Thanks Andrew! I have understand the Array Size. But what are the differences between Transaction Size and Rows per Transaction? Rows per Transaction are the number of rows where, for example, oracle commits, and Transaction Size? Thanks all again! > -----Original Message----- > From: andrew.webb@as...

Hello, We are using Datastage 4.2.1 and IQ 12. I am thying to do lookups to IQ but I have the following problem: I cant give NULL values as lookup parameters. I tried @NULL, @NULL.STR, isnull(X,"#") in SQL, ... I have a table like this 1 A 1 2 A NULL 3 B 1 4 B NULL 5 B 2 The first column is the my I...

Hello, Question 1: Is there a way to find out in which category (directory structure) a job is in? DSGetJobInfo doesnt do the trick. I couldnt find anything on it in the documentation. Question 2: Can a job be compiled from code or from the prompt? I hoped that there was a COMPILE parameter for the ...

the array size can make a big difference.. its the amount of rows (effectively) that oracle will buffer before giving it to datastage. normally its set at 1, so oracle returns each row, if you say, set it to 500, oracle will deliver blocks of 500 rows to datastage. To give you an example, if your lo...

Its 1 (or @TRUE) if the lookup is not on file, 0 (or @FALSE) otherwise. However, you do not need to know the value. If you wish a link to be executed if the lookup succeeds enter the following constraint: Not(LookupLink.NOTFOUND) If you want to execute a link on lookup failure, enter the constraint:...

There is some great online help available from the Designer. Try pressing the Help button from inside the OCI stage, youll find (depending on your version) pretty good explainations of all of the OCI parameters. -craig "Nuno Pimenta" To: "LIST-DataStage (E-mail)" cc: Subject: Tuning processes... 12/...