DSXchange

This can be done via the ODBC stage, setting the output rule to "call stored procedure". You must have earlier imported the stored procedure definition into the DataStage repository using DataStage Manager. -----Original Message----- From: Peter Oates [mailto:Peter.Oates@macquarie.com] Sent: Thursda...

Is it possible to call a Sybase stored proc or SQL from a DataStage routine - platform is Unix ? I want to call this routine from my main job control routine to update audit information about the datastage job Im currently running. regards, Peter NOTICE This e-mail and any attachments are confidenti...

Try: SELECT INSTANCE, DTC, CREATOR, DTM, MODIFIER FROM DS_AUDIT WHERE CLASS = 2; Where class is 2 (jobs), instance should be the job name. Other than that, the find the job number from DS_JOBS then look at the operating systems date/time characteristics for any of the UniVerse files (DS_JOBnn, DS_TE...

What I am finding in the Manager is the date/time modified is not changing when I import a new version of a job executable from another project. Essentially Im trying to determine which version of job is being deployed. Id rather not take the job design information over. regards, Peter -----Original...

Job name to number mapping is in the UniVerse file (table) DS_JOBS. From a UniVerse prompt, or from the Administrator clients command window, the following query would suffice: SELECT NAME, CATEGORY, JOBNO FMT 5R FROM DS_JOBS WHERE NAME NOT LIKE /%; Beware that SQL in UniVerse is case sensitive. The...

Peter You can use SQL against Universe files. The old Universe way is like this. SORT DS_JOBS BY NAME NAME field2 field3 The way to get a list of fields available then use LIST DICT DS_JOBS All of this is done at what is called TCL (Terminal Control Language). HELP SORT or HELP LIST Thanks Kim. ----...

Is there a way of getting a list of jobs across all categories and their modification date/time other than using the reporting assistant ? Can I query using one of the Universe commands ? The information contained in this email is confidential. If you are not the intended recipient, you may not disc...

Hendrik there are some very simple optimizations you need to consider to substantially improving performance. First stop using ODBC 5 months ago I got involved in a POC where we had a very similar setup. We benchmarked on a single processor box loading 500,000 rows from a flat file at 7,721 rps. (th...

Hello Everyone, I am currently running Datastage on a HP Unix box. We are running version 3.6.3 r2. We are looking to upgrade to version 4.2 r8. I believe release is the latest for version 4.2. I was wondering if there is someone else who can share his or her story who also upgraded from Datastage 3...

We are trying to use the ORAOCI87 stage. We need to know how to set up a DSN to use this. Does anyone know how to do this please? Rick Garnsey Richard Garnsey Senior Database Developer Database Products Polk Leeds Ltd. N C R House Ring Road West Park Leeds LS16 6TZ Direct Dial: 0113 386 4002 email: ...

Hi Hendrik... You didnt mention how the data was loaded....is it transactional, by requirement (SQL update/delete/insert) or bulk loader? If bulk loader, are you using the older but still workable bcp bulk load, or the OLE DB loader? Perhaps they simply invoked the bcp utility after having DecisionS...

Hi All One of our clients done some testing with datastage and Cognos DecisionStream. The test was reading from SQL Server 7.0 and writing to SQL Server 7.0 on the same box and same database. The spec for the server is a Quad 700mhz xeon machine with 1 gig ram and raid 5 disk system and Windows 2000...

Any chance you have server backups running at the time? Check you backup logs to make sure they werent backing up the DataStage project directory at the time of the error. Maybe a bit of a stretch, but Ive seen it happen. -----Original Message----- From: Huygelen, Luc [mailto:luc.huygelen@eds.com] S...

Hi, when we are running a Datastage job it gave the following error messages This does not happen frequently and it is not the first time this jobs runs. OSDStoORDSjob1.JobControl (fatal error from DSWaitForJob): Job control fatal error (-99) (DSGetJobInfo) Failed to open RT_CONFIG969 file. (DSWaitF...

DataStage has an account (the "UV project", as it is called by the Administrator client) that records the location of projects. If you destroy this by trashing the C driver, a reinstallation of DataStage will not be able - initially - to find your projects. However, simply reinstalling Windows 2000 ...