Search found 7201 matches
- 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 ...
- 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...
- 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...
- 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
preferably with examples?
Thanks,
Kathy Armstrong
Dex Media
(303) 784-2021
- 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.
pls help?
Tunde.
- 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...
- 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...
- Mon Jun 16, 2003 12:22 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Sequencing
- Replies: 8
- Views: 1553
- 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.
- Sun Jun 15, 2003 11:42 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Hash File and Universe Response
- Replies: 1
- Views: 409
- 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...
- 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...
- Fri Jun 13, 2003 7:08 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Sequencing
- Replies: 8
- Views: 1553
- 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...
- 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...