Search found 7201 matches

by admin
Fri Jan 18, 2002 5:53 am
Forum: Archive of DataStage Users@Oliver.com
Topic: help on Use Named Pipes
Replies: 1
Views: 1996

Vincent That is not a good use for named pipes. If you are on UNIX you can use the split command to split a text file into 4 or more parts. It is very fast. the dd command will do a similar thing. If you need the syntax for split then let me know. Thanks Kim. -----Original Message----- From: mb30945...
by admin
Fri Jan 18, 2002 4:14 am
Forum: Archive of DataStage Users@Oliver.com
Topic: AW: Invoke Job Run Options
Replies: 0
Views: 767

AW: Invoke Job Run Options

This is a topic for an orphaned message.
by admin
Fri Jan 18, 2002 1:06 am
Forum: Archive of DataStage Users@Oliver.com
Topic: what update action to set for OCI with 2 input links
Replies: 9
Views: 2610

Thanks for your answers David. I too donot use these constructs very often. Just curious. I use "Clear table" only for my staging area tables. From: "David Barham" on 01/17/2002 04:17 PM Please respond to To: cc: bcc: Subject: RE: RE: what update action to set for OCI with 2 input links A transactio...
by admin
Fri Jan 18, 2002 12:17 am
Forum: Archive of DataStage Users@Oliver.com
Topic: what update action to set for OCI with 2 input links
Replies: 9
Views: 2610

A transaction size of zero means to commit after ALL rows are processed I might be wrong on this as I tend not to use these, but it is my understanding that the DELETE or the TRUNCATE in these actions would get executed when the first record is presented to that link. An input record to a transform ...
by admin
Thu Jan 17, 2002 6:24 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: what update action to set for OCI with 2 input links
Replies: 9
Views: 2610

It isnt there, confirming that theres no Output Link Exec. Order available in DataStage 3.6. Thanks again. bxdatta@regenc e.com To: cc: 01/17/2002 Subject: RE: what update action to set for OCI 01:00 PM with 2 input links Please respond to datastage-user s Terri Go to the Transform and look for a bu...
by admin
Thu Jan 17, 2002 6:00 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: what update action to set for OCI with 2 input links
Replies: 9
Views: 2610

Terri Go to the Transform and look for a button in the row of icons at the top that says : "Output Link Execution Order". Bibhu From: "Theresa M. Petner" on 01/17/2002 07:25 AM Please respond to To: cc: bcc: Subject: RE: what update action to set for OCI with 2 input links Thanks to you & the others...
by admin
Thu Jan 17, 2002 5:08 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DS 5.1 - server start/stop with "dsadm"
Replies: 0
Views: 459

DS 5.1 - server start/stop with "dsadm"

Hi Kathi,

We had the same problem starting / stopping version 5.1 on Sun Solaris 2.7. Ascential tech support sent us a modified S99ds.rc script. Call them and have them refer to case # 306087.

Ed

Ed Purcell
(805) 652-3021
edwardp@kinkos.com
by admin
Thu Jan 17, 2002 3:25 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: what update action to set for OCI with 2 input links
Replies: 9
Views: 2610

Thanks to you & the others for feedback! to "B" (bxdatta@regence.com): Im getting information that this is not in our 3.6 DS version. Would you tell me how you execute the "Output Link Execution Order" from the transform, so I can just try it in our older version to confirm it does or doesnt exist? ...
by admin
Thu Jan 17, 2002 1:56 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job control error
Replies: 0
Views: 447

Job control error

Hi All We are Running DataStage 4.0.3r1 on a SUN E1000 with Solaris 7. One problem that I have been fighting for months hit me again today. This is the message that I get in the Job Log: Batch::DC200MakeBestand.JobControl (fatal error from DSWaitForJob): Job control fatal error (-99) (DSGetJobInfo) ...
by admin
Thu Jan 17, 2002 1:51 pm
Forum: Site/Forum
Topic: job postings
Replies: 1
Views: 2130

Thanks for your input. We have made modifications based on your request.
by admin
Thu Jan 17, 2002 7:51 am
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

Hi Mike, Ime interesting to the example of program. Could you pls send me it?? Thank you Ciao Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: "Michael Hester" To: Sent: Tuesday, January 15, 2002 10:59 PM Subject: Re: SQL ...
by admin
Thu Jan 17, 2002 3:26 am
Forum: Archive of DataStage Users@Oliver.com
Topic: SQL in a routine
Replies: 9
Views: 2985

Luiz Here is a way to shell out of Universe and execute sqlplus. The truth is there are too many ways to do this in UNIX. You should really not shell out to do this. It is really not necessary. Here it is anyway. ---------------------------------------------------- USERID=??? PASSWD=??? SID=??? cmd=...
by admin
Thu Jan 17, 2002 2:09 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DS 5.1 - server start/stop with "dsadm"
Replies: 2
Views: 1540

Glenn, Thanks for your reply. able to find out the problem , a similar case that had already been logged with support. scirpt u.rc has some problem , while sourcing the temporary file to create the exported variable. ### lines from ds.rc script # source the exported environment . ${dshome}/${SUBFILE...
by admin
Thu Jan 17, 2002 1:51 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Import datastage jobs in Unix environment
Replies: 2
Views: 2482

winston, would you share on how to auto-generate, compile and execute .. Warm Regards Karthi ---------------------------------------- Message History ---------------------------------------- From: winstontanpascual@amcorp.com.au on 17/01/2002 12:11 ZE11 Please respond to datastage-users@oliver.com T...
by admin
Thu Jan 17, 2002 1:11 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Import datastage jobs in Unix environment
Replies: 2
Views: 2482

Import datastage jobs in Unix environment

Hi All Ive been importing jobs via DataStage Manager. It is all well and good. However, the project Im currently working on requires to auto-generate some 300 datastage jobs, import, compile and execute them on the Unix or server side. The auto-generation, compile and execute are coming together nic...