DSXchange

A quick, little-thought suggestion is to write a generic before-job subroutine that could detect a value in a file, or something like that, set by the job control job. The before-job subroutine can then set its ErrorCode argument to a non-zero value to prevent the job from running. This is still an ...

The job control code in question is actually in the controlled job. These jobs have both job control code (which is executed before the stages start) as well as stages. -----Original Message----- From: Ray Wurlod [SMTP:ray.wurlod@informix.com] Sent: Tuesday, 15 August 2000 11:21 To: informix-datasta...

There are two separate pieces. DataStage is an extract-transform-load (ETL) tool. It uses specific metadata elements ("technical metadata") such as table definitions, functions, and so on to specify exactly how data are to be extracted, transformed and loaded. These metadata are stored in ...

I have a number of jobs (about 6 or 7) which are all fairly similar in structure. Basically, they have job control code which copies the source files from a remote system to a local directory. The stages in the job then use ODBC to read these files. Very occasionally (except for the last week when i...

I will be doing the same thing in a few weeks, I will let you know if I have any problems. Mark Griffin AMP Sr. Application Developer Data Warehouse Systems CIGNA Healthcare Two College Park Drive, 454 Hooksett, NH 03106 Phone: 603-430-7610 603-268-7239 Fax: 603-268-7909 email: griffimk@hlthsrc.com ...

Hello All I apologize in advance for my curve English? I have read some .pdf-s from Ardent (data-movement.pdf & meta-data.pdf). And there are some questions about their content. Lets read some quotations: data-movement.pdf ----------------- p.3 "Repository Manager Graphical browser used to ...

I wouldnt have thought that anything changes in your configuration, ie DataStage client still runs on the client PC. However, Id be interested in performance. DataStage is passable on a 28.8k dial up, but over the Internet?? How about you let this group know how it goes when you have it set up. Good...

We currently maintain our offsite support of our DataStage applications via a traditional dial-up to a network. Our support laptop has DataStage Client installed and away we go. We will soon have our dial-up method replaced with a Virtual Private Network (VPN), that were supposed to all check with v...

I have found following observation in &PH&, for all the jobs which complete successfull I get this kind of message message. DataStage Job 701 Phantom 26099 Program "DSD.RUN": Line 274, Nonnumeric data when numeric required. Zero used. DataStage Phantom Finished ( the middle line is...

I unscribed to datastage and continue to get individual messages from people on the list, please eliminate totally from datastage list only. Thanks

I unscribed to datastage and continue to get individual messages from people on the list, please eliminate totally. Thanks

You need this function. Here it is. There is an internal-to-DataStage function that you could call instead - I leave this as an exercise of your ingenuity. (Note, too, that the ArchiveJobLog function is not optimal - it can be improved in a number of ways.) Function: GetJobNumber Short Description: ...

This is a topic for an orphaned message.

Brad, if you need the data in the hashed files, and I assume that you do otherwise you wouldnt have asked your question, you can physically copy the files from one machine to the other. A hashed file is by default a dynamic (type 30) file which consists of a directory by the name of the hashed file ...

We have installed DS 3.6+ on an NT PC as a "test" server. Our production server has DS 3.1. In order to test some jobs, I need to copy some hashed files from the production to the test machine. What is the recommended method? If the answer is by using some Universe commands in Telnet, some...