DSXchange

This is a topic for an orphaned message.

>>> Craig_Hulett@rsausa.com 04/25/2002 11:41:50 AM >>> Most (if not all) of the plugins are documented in pdf format on the client cdrom. It is installed by default to a Docs folder under your DataStage installation folder. Also in there are all of the hard-copy manuals in pdf form as well, IIRC. Th...

Your old session continues to hold an update lock on the job design. You had a job open either in Designer or in the Monitor view of Director. You need to identify this lock and free it. Use the Cleanup Resources option in the Job menu of Director (you may need to enable same in Administrator first)...

Umm... I suspect you could have done all of that with a UniVerse SQL statement, rather than a DataStage job. Something like: SELECT column1, column2, column4, column7 FROM UNNEST table ON assocname WHERE column 1 IN (SELECT column1 FROM table WHERE condition ORDER BY column2); Check out the generate...

This technique is one of many taught on Ascentials "Programming with DataStage BASIC" class. Learn how to write totally bulletproof batches (ideal for RSA!) Given that Ascential rarely run training in RSA, get in touch with your reseller about doing a deal for a self-study course. Ray Wurlod Trainer...

None of our control jobs call DSRunJob directly. They call another function which calls DSRunJob. This function checks the status of a job before it runs the job and resets it first if required. This is also the technique taught in the Advanced DataStage programming course (or whatever it is called)...

Tony, Yes, I wanted to pivot what turned out to be a multivalued field. However, I didnt want to do it for every row. I also needed to sort the rows which messes up the ordering of the unnested rows. My final solution was to read the data from the UniVerse table, filter to a separate stream in my jo...

Paul, The best way to see how to get more than one link to an OCI is to try it. Just as you created the first link, you can add many more. You can also move links from one OCI stage to another. Select one of the other links, then drag the handle at one end from one OCI to another. When you edit the ...

Thats good to know. I kind of simplified things, so missed those extra steps. Here, I dont try to reset jobs in every batch as they happen. As my batch jobs only run once a day, I wrote a batch that runs in the middle of the night and queries all jobs in a project to see if any of them are in an abo...

Heres how we do it: Status = DSGetJobInfo(hJob1, DSJ.JOBSTATUS) If Status DSJS.RUNOK and Status DSJS.RUNWARN Then ErrCode = DSDetachJob(hJob1) hJob1 = DSAttachJob("MyJob", DSJ.ERRFATAL) ErrCode = DSRunJob(hJob1, DSJ.RUNRESET) * Fatal Error - No Return Call DSLogFatal("Job Failed: MyJob", "JobControl...

Sure. After checking the job status and seeing that it aborted, reset it by doing something like this: If JobStatus = DSJS.RUNFAILED Then ErrCode = DSRunJob(JobHandle, DSJ.RUNRESET) End You would probably then want to check the ErrCode to verify it was able to reset it, but thats all it takes. -crai...

Hi there, We are starting a job within a batch. If this job abort we would like to reset it within the same batch Is it possible? Thanks Theo Pieterse This message contains information intended solely for the addressee, which is confidential or private in nature and subject to legal privilege. If yo...

David, The fact that you are using a Universe table as the source begs for the question "are you trying to pivot a multi-valud field?" If so, there is a very simple way for you to do this. In the Hash File and Universe stages, on the columns tab, there is a column labeled "Type". Normally, the data ...

Most (if not all) of the plugins are documented in pdf format on the client cdrom. It is installed by default to a Docs folder under your DataStage installation folder. Also in there are all of the hard-copy manuals in pdf form as well, IIRC. The Ascential Support website has the availability matrix...

This web site is obsolete. Do you have a new one for plugins? -----Original Message----- From: Riccardo Tani [mailto:rtani@datamat.it] Sent: Thursday, March 14, 2002 04:01 AM To: datastage-ML Subject: About Datastage and Plug-in documentation Hi all, this is a request to all Ascential people. I reme...