Search found 7201 matches

by admin
Fri May 07, 2004 10:45 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Please Read: Questions about Posts on Oliver list Archive
Replies: 0
Views: 53040

Please Read: Questions about Posts on Oliver list Archive

Members, Please be advised that any posts made in the <b>Archive of DataStage Users @ Oliver.com</b> forum are assigned under the username "Admin", but Admin and the DSXchange Team are not responsible for any of the content of these posts, unless a member of the DSXchange Team has included...
by admin
Mon Mar 29, 2004 10:33 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Result sets from AS400 Stored Procedure - Binary Format
Replies: 0
Views: 16848

Result sets from AS400 Stored Procedure - Binary Format

Group..I set up a job to call an AS400 Stored procedure from Test System (V5R2). The job is working fine with sending the correct result set. However when I called the procedure from production AS400 system (V5R1), the result sets are in binary format. We are running on Datastage V7. I used APPCODEP...
by admin
Sat Mar 27, 2004 2:50 am
Forum: Archive of DataStage Users@Oliver.com
Topic: This list is closing
Replies: 3
Views: 21072

This list is closing

Thanks from me, too. It's this list that provided some of the motivation to get DSXChange started. Meanwhile, let me wish for continued success for the U2 users list. ----- Original Message ----- From: Moderator Date: Sat, 27 Mar 2004 00:44:09 -0800 To: DataStage Users Discussion List Subject: Re: T...
by admin
Sat Mar 27, 2004 2:44 am
Forum: Archive of DataStage Users@Oliver.com
Topic: This list is closing
Replies: 3
Views: 21072

This list is closing

Thank you, Phil. It has been my pleasure. I think you will find the http://www.dsxchange.com/ resource to be very helpful. They have a couple of thousand subscribers. And our "own" Ray W. is even listed as the top poster! -- Regards, Clif Phil Walker wrote: > Clif, > > May I thank you on b...
by admin
Sat Mar 27, 2004 2:42 am
Forum: Archive of DataStage Users@Oliver.com
Topic: This list is closing
Replies: 3
Views: 21072

This list is closing

Clif, May I thank you on behalf of all list users over the years that you have moderated and hosted the list. Phil Walker +64 21 336294 phil.walker@infocusp.co.nz infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachm...
by admin
Sat Mar 27, 2004 1:46 am
Forum: Archive of DataStage Users@Oliver.com
Topic: This list is closing
Replies: 3
Views: 21072

This list is closing

Friends, This list will be shutting down 1 April 2004. I direct your attention to a very active venue at www.dsxchange.com. See you there. -- Regards, Clif ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678 Web: www.oliver.com ~~~~...
by admin
Fri Mar 26, 2004 2:13 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job info for a specific category
Replies: 5
Views: 25583

Job info for a specific category

The UniVerse query information can be had from UniVerse manuals, which can be downloaded from IBM's website www-106.ibm.com/software/data/u2 You could as easily have used UniVerse SQL (same site for manuals). SELECT NAME TO SLIST 9 FROM DS_JOBS WHERE CATEGORY = 'CategoryName' ORDER BY NAME; The BASI...
by admin
Fri Mar 26, 2004 8:06 am
Forum: Archive of DataStage Users@Oliver.com
Topic: datastage-users Digest, Vol 3, Issue 15
Replies: 0
Views: 16296

datastage-users Digest, Vol 3, Issue 15

Hi Dharmendra, You may want to explore the job sequencer functionality. You can set up conditions for the jobs and handling procedures to email yourself or the other parties involved at certain fail and success stages. Hope this helps. Stashima Hailey _______________________________________________ ...
by admin
Thu Mar 25, 2004 3:12 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How can a DataStage Job that is in Running State Stop itself
Replies: 3
Views: 22280

How can a DataStage Job that is in Running State Stop itself

I tried DSJ.ME, the response is DSJE.BADHANDLE (invalid handle). Thanks, Dharmendra -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com]On Behalf Of Tony Stark Sent: Thursday, March 25, 2004 1:05 PM To: DataStage Users Discussion List Subjec...
by admin
Thu Mar 25, 2004 3:05 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How can a DataStage Job that is in Running State Stop itself
Replies: 0
Views: 15577

How can a DataStage Job that is in Running State Stop itself

I will be out of the office Friday, March 26. If you need immediate assistance, please contact Cheryl Vukas at 816-926-1520. Regards, Ryan Day EDS - USDA _______________________________________________ datastage-users mailing list datastage-users@oliver.com http://www.oliver.com/mailman/listinfo/dat...
by admin
Thu Mar 25, 2004 3:04 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How can a DataStage Job that is in Running State Stop itself
Replies: 3
Views: 22280

How can a DataStage Job that is in Running State Stop itself

Can you use DSJ.ME for the job handle? Tony "Patel, Dharmendra" wrote: Hi All, Can anybody please suggest a way for a Job to stop itself, if a check condition fails within the job. There is a DSStopJob Function, but it needs to have JobHandle. According to the document, the only way to get...
by admin
Thu Mar 25, 2004 1:53 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How can a DataStage Job that is in Running State Stop itself
Replies: 3
Views: 22280

How can a DataStage Job that is in Running State Stop itself

set a flag and put it in the constraint
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
by admin
Thu Mar 25, 2004 1:18 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: How can a DataStage Job that is in Running State Stop itself
Replies: 3
Views: 22280

How can a DataStage Job that is in Running State Stop itself

Hi All, Can anybody please suggest a way for a Job to stop itself, if a check condition fails within the job. There is a DSStopJob Function, but it needs to have JobHandle. According to the document, the only way to get the job handle is through DSAttachJob function. Since the job will be in the run...
by admin
Thu Mar 25, 2004 8:33 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Job info for a specific category
Replies: 5
Views: 25583

Job info for a specific category

Thanks Ray. Adding the "From 9" worked like a champ! Scott PS Is there help information somewhere that gives what can be queried from Universes as well as information on commands like: "SELECT DS_JOBS WITH CATEGORY = 'MyCategory' TO 9" If Selectinfo(9,1) ReadNext JobName From 9 ....
by admin
Wed Mar 24, 2004 1:46 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Job info for a specific category
Replies: 5
Views: 25583

Job info for a specific category

My error. I put the job names on Select List #9, but neglected to specify this list when processing in the loop. The corrected statement is ReadNext JobName From 9 Sorry about that, Chief! ----- Original Message ----- From: "Scott Brooks" Date: Wed, 24 Mar 2004 08:53:12 -0500 To: Subject: ...