DSXchange

Hello, I would like to create a file and write a value in from a DataStage Routine. The I would like to read this value from another Routine. Please, Can You send me a Basic Sample of OPEN and READ statements ? Suppose that file foo.txt is: RECORD1,RECORD2 10,20 30,40 50,60 If I would like to read f...

Thanks a lot!!! It was what I thought!! ^_^ Regards, Riccardo ----- Original Message ----- From: "Phaneender Aedla" To: Sent: Monday, May 27, 2002 12:08 PM Subject: RE: Using Oracle Stored Procedure Hi, Its possible to called a stored proc using OCI Stage as well. In the Before/After tab, call the p...

Hi, Its possible to called a stored proc using OCI Stage as well. In the Before/After tab, call the proc by - Call ProcedureName(param1,param2,...etc) If there are no parameters, then Call ProcedureName() Call is a keyword and is required. Regards, A -----Original Message----- From: Riccardo Tani [m...

Hi Nilotpal, you dont need to build a basic routine (BCI routine) or use a Job Sequencer to perform a stored procedure (but if you want you can follow this way). Once you have created your stored procedure on Oracle you can call it using ODBC stage. Ive never tested if it is possible to call a store...

First at all, I think what you can to create a Routine that call the Stored Procedure. Then you can use the Routine in many point: - Stage "RoutineActive" in Job Sequencer - Before After Routine. Sorry for my english hi ----- Original Message ----- From: Nilotpal To: datastage-users@oliver.com Sent:...

In addition to adding the sort stage you also need to indicate the sort sequence in the aggregator stage. In the version of datastage we are using (DataStage 5.1 on Tru64) we fill the sort column on the input tab of the aggregator stage. Tim DeFoe -----Original Message----- From: Warren.P.Kalsow@Hea...

Try putting a SORT stage in front of the Aggregator. It solved all of our problems like this. The other thing is to limit the record length - eliminate all the fields that arent needed. From what I can guess is that there is a memory leak or something. We are on a Compaq unix(TRU/64) environment. --...

Hi, Weve done a job that performs the following steps: 1] there is an OCI stage that extract rows from DB, using an user- defined select; 2] there is a transformer that performs some simple transformations on data; 3] there is an aggregator that group the rows (these arent ordered) 4] there is an OC...

Guys, Were running DS 5.1 on AIX. We have three projects currently set up, one each for development, test and production. What Im trying to achieve for the test (and production) project is to provide access to only one user. However, Im unable to do this because as I understand it all users of DataS...

Perhaps could try export, then delete, then import the job. And pray that it works Kasia At 02:02 24/05/2002, you wrote: >Hi Christian, > >I have had this problem before. I re-imported the job with design >information from a baseline project that i keep up to-date. > >Regards, > >Damien Kavney > >Te...

(Read this using a fixed font such as Courier New) Not in SQL you cant. The SELECT statement is being executed by Sybase, not by DataStage, and Sybase doesnt know about hashed files. However, in your job design you can pick up the value from the hashed file by means of a reference lookup, and use pa...

Hi Christian, I have had this problem before. I re-imported the job with design information from a baseline project that i keep up to-date. Regards, Damien Kavney Technical Consultant Dialog Pty Ltd Contact Details (DNR) MIS Application Support Group (07) 3896 3989 Damien.Kavney@dnr.qld.gov.au -----...

The answer has to be "depends"! How do you know the job has been corrupted and do you know in which file(s) the corruption occurred? The release of DataStage that you are running will also affect whether the problem can be fixed easily, fixed but with difficulty, or not fixed at all. As a general ru...

If you use an ODBC stage to access Sybase, you can make the hash file you primary input and do a lookup to the Sybase data. Make sure you check the multirow lookup option on the link properties in the transformer stage. There may be other options, but Im not completely clear on what you are trying t...

Hello, I have a job to read from a sybase table and output its contents to a flat file. I also have a hash file where it consists of the criteria for the sybase table selection. My question is: In the WHERE tab of the sybase stage, how do I incorporate the value of the criteria from the hash file? I...