DSXchange

Hi, We use an ODBC stage to call a stored proc. The problem we had was that we were unable to handle the results thrown out by the stored proc. So, we had to write a wrapper around this stored proc and use the wrapper. This job will remain running until the stored proc is done. We are on Version 4.2...

Good morning, gang, We have a few stored procedures that we wish to run in Oracle once certain tables are loaded via DataStage. Does anyone know how (if) I can execute/start a stored procedure via DataStage? Also, will the calling program remain "running" until this stored procedure is done? Thanks ...

Hi Peter. as i know, Hash Algorithm can not perform range selection (eg like) How about use uv stage, Uv stage also uses hashed file but inteface is different. so UV stage can do range operation. but I can not confirm to improve performance, when U using UV Stage, use Secondary Index (B-Tree Index) ...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Miguel, The MQ API is IBMs api for using MQ Series which is probably how datastage talks to MQ. To use the MQ API there are different dlls depending on whether the server is installed on the PC or the client (I think API talks to the server differentl...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sorry to chime in -- I am a UV and MQ user but not a Datastage user - -- can you not get DataStage to use the client MQ dll? The MQ API is the same, but the dlls are different. Craig Bennett -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 iQA/AwUBPI6RVd...

Doesnt the cleanup project option in Administrator reindex DS_JOBS? -----Original Message----- From: alanwms@bellsouth.net [mailto:alanwms@bellsouth.net] Sent: Wednesday, 13 March 2002 8:09 AM To: datastage-users@oliver.com Subject: Re: Re: DS.REINDEX ALL - missing jobs Ive found that DS.REINDEX DOE...

Ive found that DS.REINDEX DOES NOT include the DS_JOBS file. Also, the indices are created on the CATEGORY dict item only. Typically, DS_JOBS carries two indices, JOBNO and CATEGORY. Be sure there are no locks on DS_JOBS, then run the following commands from the UV command prompt: DELETE.INDEX DS_JO...

This is a topic for an orphaned message.

DS.REINDEX is a UniVerse paragraph (something like a script). Do you have any UniVerse knowledge? It is reasonably straightforward to edit this script to add any index you believe is missing, provided youre familiar with the UniVerse environment. For example, if youre on a UNIX platform, you can tel...

Hi Ed... Multiple Job Instances was a new capability for 5.1. The most important thing about it is the fact that it allows you to run the same job, concurrently, many times. You have to "enable" it under Job Properties while designing your job, but beyond that, its a powerful feature, and isnt very ...

Is there anyplace in the documentation where all of this is explained: multiple job instances, Parallel Extender, definitions, uses, issues, examples, etc.?

Ed Purcell
(805) 652-3021
edwardp@kinkos.com

Thank you Vincent. Leonid "Vincent McBurney" on 03/11/2002 11:51:42 PM Please respond to To: cc: Subject: RE: Job control error -14 Ive seen a similar error in version 3.6 in a job that runs a Unix execute as the first action in the job control code. The server thinks the job has failed because it h...

Our training budget is shrinking (arent they all !) and we must choose classes carefully. Can anyone shed some light on the pros/cons of this class ? Would it help set standards for code and operational procedures ? (We are a shop just beginning to use DataStage.) Is it best used for a train-the-tra...

Ive seen a similar error in version 3.6 in a job that runs a Unix execute as the first action in the job control code. The server thinks the job has failed because it has run for a couple hours and not logged a single message. The workaround was to write a log message at the very start of the job co...

Hi, DS people I recently moved oracle database to another host. Therefore I updated tnsnames.ora file to suit the settings. My OCI stage works fine. However, the ODBC stage connected to oracle database doesnt work any more, issued the error message like : AdminJob.ODBC: DSD.BCIConnect connecting to ...