Search found 7201 matches

by admin
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...
by admin
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:...
by admin
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 ...
by admin
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....
by admin
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...
by admin
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...
by admin
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...
by admin
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...
by admin
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...
by admin
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.
by admin
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
by admin
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----- ...
by admin
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...
by admin
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...
by admin
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...