Search found 7201 matches
- 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: 64899
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...
- 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: 18771
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...
- Sat Mar 27, 2004 2:50 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: This list is closing
- Replies: 3
- Views: 23236
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...
- Sat Mar 27, 2004 2:44 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: This list is closing
- Replies: 3
- Views: 23236
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...
- Sat Mar 27, 2004 2:42 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: This list is closing
- Replies: 3
- Views: 23236
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...
- Sat Mar 27, 2004 1:46 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: This list is closing
- Replies: 3
- Views: 23236
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 ~~~~...
- Fri Mar 26, 2004 2:13 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job info for a specific category
- Replies: 5
- Views: 27869
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...
- 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: 18209
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 _______________________________________________ ...
- 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: 24459
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...
- 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: 17449
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...
- 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: 24459
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...
- 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: 24459
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
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
- 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: 24459
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...
- Thu Mar 25, 2004 8:33 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job info for a specific category
- Replies: 5
- Views: 27869
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 ....
- Wed Mar 24, 2004 1:46 pm
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Job info for a specific category
- Replies: 5
- Views: 27869
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: ...