DSXchange

The counters from which the Monitor view in Director are kept in the RT_CONFIGnn hashed file, where nn is the job number from DS_JOBS. They can be extracted from there with suitable query commands, but executing these will detract from the overall performance of the job. How you feed Control-M from ...

Hi, Yes, but i want to get this information during the execution, during the monitorization of the execution of the Datastage job. how can i do this ? regards Rui Soares Tlm : 96 347 08 40 -----Original Message----- From: J. Schatz JMS Data Management Inc [mailto:johnshot@bellatlantic.net] Sent: sex...

Hi, Hi There is anybody who use Control-M to scheduler the Datastage jobs? We would like to pass same information about the DataStage job, (such as number of rows/second, error, etc) to the Control-M. How can we do this? Control-M can received same information that we send as echo, how can I defined...

This is the error we are geting:

DEFtest1..DEFIN.RecordsIn: read_fixedwidth() - row 1, column
CYCLE_DOLLAR_AMOUNT, column unexpectedly ended by EOR

does anyone know what is the reason for it.

Thanks...Kamal

Hi, Im having some problems with the dataformating of some decimal fields. Id like to make a field with a total length of 12, with 6 significant digits. ie. 12345.123456 How should this be done in datastage ? This is what I did, and the result from different data values. SQL Type: Decimal Length: 12...

In 5.2 you can create a new Sequence Job, this lets you then drag your jobs onto the designer page. If you have 3 jobs on the page and they are not linked they will all start at once when the sequence job is run. You can do the same thing with a Control job. Control jobs and sequence jobs do the sam...

Hi all, DataStage supports the use of stored procedures (with or without input arguments) and the creation of a result set, but does not support output arguments or return values. A stored procedure may have a return value or output parameters defined, but these are ignored at run time. When writing...

In the job properties check the box that makes the job able to run as multiple instances. Allocate each instance of the job a "job instance ID" - this is simply a characters string (no spaces) that uniquely identifies the instance of the job. These job instances can be run in parallel. MyJob.Instanc...

Josy, The correct answer is that I dont know for certain, so I am posting this on another list. Certainly I have seen in/out parameters used successfully with Microsoft SQL Server, so theoretically it should be possible. Regards, Ray ----- Original Message ----- From: Date: Tue, 26 Nov 2002 05:23:32...

Hi, code 99 is a generic status code. Could you describe better your job control? Have you simply added the job test or you perform some other actions? Regards, Riccardo ----- Original Message ----- From: "Evens, Johannes" To: Sent: Tuesday, November 26, 2002 5:33 PM Subject: Job control fatal error...

I use a control job testcjob. This job calls another job test. The job test run witout error. When I run the control job testcjob I get the following error: testcjob.JobControl (fatal error from DSRunJob): Job control fatal error (-99) (DSGetNewestLogId) Error selecting from log file RT_LOG24 (DSRun...

Hi Prasad, if you are talking about executing 2 or 3 "instances" of the same job, you can use the "Allow Multiple instance" option. You can find this option into the job properties (i.e. open the Designer ---> Edit menu ---> job properties) Then you can execute those jobs or by a job sequence (using...

Hi Prasad, if you have 2 or 3 different jobs: no problem, start them at the same time. if it is the same job make as many copies of the job you need. MyJob2 MyJob3 .... MyJobn and start those jobs at the same time. Pay attention that the they dont deal with resources each job needs exclusivly. Wolfg...

Hi Prasad, Use the following code in a third job and run this job. U can see the 2 jobs running parallelling. Like this u can run as much as job u need. First Create 2 jobs which u want to run. Call this code in the third job and run that. K *Define function before use. Deffun WriteFile(A1,A2) Calli...

This is a topic for an orphaned message.