DSXchange

The answer is that it is not possible through script. To accomplish this with a script approach you would need to create metadata for the DataStage repository tables in question (DS_JOBOBJECTS for design-time and RT_CONFIGxx for run-time). Documentation on how to do this is not in the public domain....

Hi Rahim, You might want to investigate the new features of version 7.0 due to become available in July. The ability to create Job Templates from scratch or existing Jobs will be available. Just like MS Word you can then create a new Job from a existing Template. Cheers Stewart -----Original Message...

Do you mean at design time or at run time? -----Original Message----- From: Rahim Ladha [mailto:rahimladha@hotmail.com] Sent: Wednesday, 18 June 2003 4:21 AM To: datastage-users@oliver.com Subject: Copy Parameters from one job to another Guys; Is there a way through script, copy the job parameters f...

Guys; Is there a way through script, copy the job parameters from one job to another? Anyone, has any example or some idea how we can achieve this without doing a manual work. Thanks in advance. Rahim Ladha e-mail : rahimladha@hotmail.com >From: datastage-users-digest-help@oliver.com >Reply-To: >To:...

Guys; Thanks for your input. SQL query is part of the DSProperties table in Reporting Asst. database. We create the tables in Oracle, and our business user can do query out of it. Regards Rahim Ladha e-mail : rahimladha@hotmail.com >From: datastage-users-digest-help@oliver.com >Reply-To: >To: datast...

Hi Do you have at least the same number of column definitions as the number of expected input parameters.The column definitions are used as the input parameters to the stored procedure. With regards, Wilcy On Tue, 17 Jun 2003 Senthil Kumar B wrote : > >Hi: > >I have a doubt regarding usage of stored...

>From the information you gave, my guess is that the issue is with the query statement you are executing. Especially since you said you had expected one record, but received two. 1) What is the query ? 2) Have you tested this outside of DataStage (WinSQL, Informixs query tool, etc) ? 3) How long doe...

Return Receipt Your Isolation Level document : was Carlos Pimentel/Madison/GNIC received by: at: 06/17/2003 07:36:35 AM CDT

Hi all, We are extracting from a informix table and the query takes 25 minutes to end. Along this time the query returns two records for the same key, but in the source table only exists one record for that key. May i use the "transaction isolation"? Anyone could help me? Thanks in advance. Nuno Pim...

Hi: I have a doubt regarding usage of stored procedures in DataStage. I used ODBC stage to call a stored procedure. But when i import the metadata of the stored procedure i get an error which says that the result set has not been identified. I need some help regarding it. Regards, Senthil Kumar.B, M...

Steven, thank you for your reply. I think those points you have listed will help me to aswer a customers question. He is modifying his architeture and he will be happy to know that Datastage is able to connect directly to EssBase. Thanks again Riccardo ----- Original Message ----- From: To: Sent: Mo...

Hello World, I was hoping that someone has some experience using the SAP Load Pack for SAP R/3. My team will be responsible for migrating data from legacy systems to SAP R/3. My questions are hopefully simple, but Im sure that you will enlighten me on the subject Loading (Inserting) Data Into SAP R/...

Tunde: To be clear, are you are using DataStage Parallel Extender, writing a parallel job? Do you wish to use a Server type job function in a Parallel type job? Is your need to assign unique sequence numbers to rows allowing for parallel partitioning of the data? Are your sequence numbers starting f...

Hi, You can use the KeyMgtGetNextValue transform that is available in the category - sdkKeyMgt. The transform can be called in the Job Sequencer using a Routine Activity. With regards, Wilcy On Tue, 17 Jun 2003 Babatunde.Ebohon wrote : >Thanks Wilcy but can you send me an example of how i can popula...

Thanks Wilcy but can you send me an example of how i can populate a table with a unique id in a parallel job with a sequence generator. Tunde. -----Original Message----- From: Wilcy William [mailto:wilcy@rediffmail.com] Sent: Monday, June 16, 2003 2:40 PM To: datastage-users@oliver.com Subject: Re: ...