Search found 7201 matches
- Fri Jun 13, 2003 3:29 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Sequencing
- Replies: 8
- Views: 1553
Dinesh You can do the same in a sequence. You point Job2 and Job4 to one job sequencer and have Job3 run after both of those jobs finish. That is exactly why they created job sequences is to force specific jobs to run after other jobs. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duk...
- Fri Jun 13, 2003 3:15 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Sequencing
- Replies: 8
- Views: 1553
You can define Job2 and Job4 as a batch job and call batch job in another batch job. This way you can run Job2--> job4 in parallel to Job3. Dinesh -----Original Message----- From: Bruce William [mailto:bwilliam_ds@yahoo.com] Sent: Friday, June 13, 2003 4:27 AM To: datastage-users@oliver.com Subject:...
- Fri Jun 13, 2003 2:37 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Sequencing
- Replies: 8
- Views: 1553
Bruce Real dependencies are a table being read from has to be built by a job that ran before this job. Job sequences can easily make a job follow another job. You cannot modify the code that a job sequence generates without doing some tricks. It is very ugly code too. You need MetaStage or DwNav to ...
- Fri Jun 13, 2003 2:19 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: DataStage and SAS
- Replies: 4
- Views: 2375
Surendranath The easiest way to do this is run the DataStage job from a shell script. This is documented in archive on www.tools4datastage.com. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: Surendranath Gujjala [mailto:Surendranath....
- Fri Jun 13, 2003 2:13 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: DataStage and SAS
- Replies: 4
- Views: 2375
Hi steven, is there a plug-in to extract data from Hyperion? Thank you Regards, Riccardo ----- Original Message ----- From: To: Sent: Friday, June 13, 2003 3:27 PM Subject: RE: DataStage and SAS Mark Ascential actually has two specific SAS Stages to allow DataStage Enterprise Edition (PX) users to e...
- Fri Jun 13, 2003 12:42 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: DataStage and SAS
- Replies: 4
- Views: 2375
Thanks Surendranath, however, I read in the readme files for DataStage version 6 onwards, that the DataStage Parallel Extender can access SAS. -----Original Message----- From: Surendranath Gujjala [mailto:Surendranath.Gujjala@Ingenix.com] Sent: Friday, June 13, 2003 2:28 PM To: datastage-users@olive...
- Fri Jun 13, 2003 12:33 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Hash file and Universe questions
- Replies: 2
- Views: 696
Universe is owned by IBM. Youll need to visit the IBM website to find any future support information for Universe and training. I would recommend simply buying a book or searching for websites. Your requirements are most likely hash file backgrounds and BASIC training. Universe is a database product...
- Fri Jun 13, 2003 12:28 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: DataStage and SAS
- Replies: 4
- Views: 2375
It is not possible for datastage to read sas databases, as sas databases can be read only by sas. What you can do, create a shell (if you are on Unix) that : 1) gets called from datastage 2) runs a sas program that reads sas db and creates a flatfile 3) deletes flat file, once the datastage finishes...
- Fri Jun 13, 2003 12:20 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Hash file and Universe questions
- Replies: 2
- Views: 696
Hello everyone, I have two questions. One is does anyone know how to view a hash file in Unix. I know a hash file consists of a DATA.30 and OVER.30 file but whenever I do a vi on either component, the data looks it needs a decoder to fully understand it all. Is there any way to make the data so I ca...
- Fri Jun 13, 2003 12:20 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Hash file and Universe questions
- Replies: 2
- Views: 696
Hash file and Universe questions
This is a topic for an orphaned message.
- Fri Jun 13, 2003 9:12 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: DataStage and SAS
- Replies: 4
- Views: 2375
DataStage and SAS
Hi all
Does anyone know or has anyone managed to read SAS data with DataStage? Any
comments will be appreciated.
Thanks
Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
Cell +27 83 380 2335
Does anyone know or has anyone managed to read SAS data with DataStage? Any
comments will be appreciated.
Thanks
Mark Ewart-Phipps
Centerfield Software (Pty) Ltd
Tel +27 11 462 7003
Fax +27 11 462 7392
Cell +27 83 380 2335
- Fri Jun 13, 2003 9:08 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Phantoms before Finishing
- Replies: 6
- Views: 876
Ive ever got this message also. In my case, its because there is a user-defined routine in my job that argument I passed to is NULL. And that routine seems to cannot handle the NULL values. So I look back to the routine and fix it to able to handle NULL value. HTH, --Boyd -----Original Message----- ...
- Fri Jun 13, 2003 8:27 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Sequencing
- Replies: 8
- Views: 1553
I can run jobs sequentially using Job Control. But for something like this: After Job1 finishes, start Job2 and Job3 at the same time. After job2 finishes start Job4 so on.. Job1 -> job2 -> job4 Job1 -> job3 I had gone through the code, found it difficult to customize it. Also Im looking for a gener...
- Fri Jun 13, 2003 8:10 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job Phantoms before Finishing
- Replies: 6
- Views: 876
Hi, The easiest way to find the error is to go and search for this file JOB.1097715596.DT.1283961672.TRANS1 and go to Line 217 - in that line is why the job fails. (Youll find that file under the DataStage/Projects/projectname directory and look for the RT_???187 directory) DataStage Job 187 Phantom...
- Fri Jun 13, 2003 8:04 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Integrity Users
- Replies: 3
- Views: 501
Hi Tim Im interested in the Integrity user group because we sell and support Integrity. I remember some time ago there was some mention of an Integrity user group because of the type of questions posed to this group. However, I dont remember the internet address. Any info in this regard would certai...