Search found 7201 matches

by admin
Mon Jun 16, 2003 7:40 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Server Routines
Replies: 4
Views: 987

Hi Tunde, You can call sdk/routine and a parallel job in Job Sequencer which allows you to specify the parallel jobs to run and the routines. With regards, Wilcy On Mon, 16 Jun 2003 Babatunde.Ebohon wrote : > >Can i use and sdk/routines in a parallel job? what would be the suggested way of creating ...
by admin
Mon Jun 16, 2003 7:36 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequencing Documentation
Replies: 2
Views: 616

Thanks - will do. -----Original Message----- From: Wilcy William [mailto:wilcy@rediffmail.com] Sent: Monday, June 16, 2003 1:33 PM To: datastage-users@oliver.com Subject: Re: Job Sequencing Documentation Hi Kathy, Please refer the Ascential DataStage Designer Guide. There is a chapter on Job Sequenc...
by admin
Mon Jun 16, 2003 7:33 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequencing Documentation
Replies: 2
Views: 616

Hi Kathy, Please refer the Ascential DataStage Designer Guide. There is a chapter on Job Sequences. With regards, Wilcy On Mon, 16 Jun 2003 Armstrong, Kathy wrote : >Does anyone know where can I find 6.0.1 job sequencing documentation, >preferably with examples? > >Thanks, > >Kathy Armstrong >Dex Me...
by admin
Mon Jun 16, 2003 5:16 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequencing Documentation
Replies: 2
Views: 616

Job Sequencing Documentation

Does anyone know where can I find 6.0.1 job sequencing documentation,
preferably with examples?

Thanks,

Kathy Armstrong
Dex Media
(303) 784-2021
by admin
Mon Jun 16, 2003 4:39 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Server Routines
Replies: 4
Views: 987

Server Routines

Can i use and sdk/routines in a parallel job? what would be the suggested way of creating or generating sequence numbers?

pls help?

Tunde.
by admin
Mon Jun 16, 2003 3:03 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: sequence generator
Replies: 19
Views: 46140

How can i use or access the KeyMgtGetNextValue in a parallel Job? Tunde -----Original Message----- From: Tim Walsh [mailto:tim.walsh@york.com] Sent: Monday, June 09, 2003 9:46 AM To: datastage-users@oliver.com Subject: RE: sequence generator There are a lot of ways to manage unique key generation, b...
by admin
Mon Jun 16, 2003 1:09 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage and SAS
Replies: 2
Views: 3245

Hey Riccardo sorry for the late reply on this. Thanks to our partnership with Hyperion and in order to support numerous joint customers there are actually several integration points including: 1) A Hyperion MetaBroker for bi-directional exchange of metadata between HIS (Hyperion Integration Services...
by admin
Mon Jun 16, 2003 12:22 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequencing
Replies: 8
Views: 1553

Return Receipt Your RE: Job Sequencing document : was Carlos Pimentel/Madison/GNIC received by: at: 06/16/2003 07:22:05 AM CDT
by admin
Sun Jun 15, 2003 11:42 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Hash File and Universe Response
Replies: 1
Views: 409

Hash File and Universe Response

This is a topic for an orphaned message.
by admin
Sun Jun 15, 2003 11:42 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Hash File and Universe Response
Replies: 1
Views: 409

Thanks Kenneth for providing more insight on viewing hash file
and also on Universe. Very good info was provided

Stashima Hailey
Johnson & Johnson Sales and Logistics
by admin
Sat Jun 14, 2003 11:04 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Extract SQL query from DS Jobs
Replies: 4
Views: 1884

It definitely can be done via the documentation tool. You will find that the SQL statements to be executed are properties of links, and may therefore need to construct a query joining DSJobs, DSStages, DSLinks and DSProperties in Doc_Tool.mdb. The SQL can also be reported upon using MetaStage, but y...
by admin
Sat Jun 14, 2003 8:03 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Extract SQL query from DS Jobs
Replies: 4
Views: 1884

MetaStage is really the supported way to get this kind of information, but you could also probably get it out of a dsx or xml export of the job. Either way is pretty easy to look through, also either one can be easily manipulated with a DataStage job and the xml export can be associated with an XSLT...
by admin
Fri Jun 13, 2003 7:08 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job Sequencing
Replies: 8
Views: 1553

Return Receipt Your RE: Job Sequencing document : was Craig Hulett/Englewood/GNIC received by: at: 06/13/2003 01:06:41 PM MDT
by admin
Fri Jun 13, 2003 4:27 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Extract SQL query from DS Jobs
Replies: 4
Views: 1884

Rahim It is in DSProperties in doc_tool.mdb. The PropName like "*SQL*". You need to order by all the key fields plus PropName and LineNumber. The sql is in ProvValue. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: Rahim Ladha [mailto...
by admin
Fri Jun 13, 2003 3:40 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Extract SQL query from DS Jobs
Replies: 4
Views: 1884

Extract SQL query from DS Jobs

Hello Every; Is there any way to extract SQL query from DS Jobs using scripts? Im using Oracle OCI. In MS Access Documentation tool, I was not able to find. And Im not able to run MetaStage sucessfully yet. thanks in advance Regards Rahim Ladha e-mail : rahimladha@hotmail.com Rahim Ladha e-mail : ra...