DSXchange

This is a topic for an orphaned message.

Thanks Becky for the reply back. I just want to make sure I am understanding &COMO&. Would you say that this command is pretty much just like the print screen function? If this is so does this mean this is not really a method of trying to get more feedback from some jobs that abort? Also where would...

Dirk, There are a set of routines that are used that allow you to run jobs, wait for them to complete, and pass parameters. The routine you are looking for is DSSetParam. Heres some example code * Setup EGARPCroReconCroLoadIds, run it, wait for it to finish, and test for success hJob2 = DSAttachJob(...

Hi Dirk, you are welcome!! If you have to pass parameters to a job from a job control you have to use DSSetParam before performing DSRunJob: ErrCode = DSSetParam(jobHandle, ParamName, ParamValue) You can find more documentation in Datastage help on line. Regards, Riccardo ----- Original Message ----...

Excellent, I am now subscribed ! Ok, Im sitting with a problem. I am very new to Datastage. I am writing a control job that will run another job by sending a parameter to the job. My problem: how do I send a parameter from one job to another ? I am busy reading the manuals, but havent found a soluti...

Testing ! Dirk Moolman Database Administrator Reach Technologies South Africa www.thefuelgroup.co.za "No pessimist ever discovered the secret of the stars, or sailed to an uncharted land, or opened a new doorway for the human spirit." -Helen Keller ===================================================...

Hi, We store all jobs in a control table and create a scheduler job, which will call all jobs from control table. All parameters can be defined in scheduler job and write a code in the job control of scheduler job to assign a value to the parameter by calling DSSetParam function and scheduler will b...

Hi all, a customer of our have to load/download data from several remote DB (Oracle, SyBase, Access...) and they have a wide network with firewalls and routers. Whats Datastage behaviour in this configuration? I think that if Datastage server is able to access to DB server there will be not problems...

Hi Rui, we had the same problem with DS 4.1.1 and we solved it creating another file in mainframe with fixed size. I know (i hope) that DS 5.1 solve this problem. Bye Riccardo ----- Original Message ----- From: "Rui Miguel de Sousa Soares (Novabase - IGestao" To: "Datastage-Users (E-mail)" Sent: Tue...

Hi, We have facility in datastage to acept input from the end user as a parameter.And some parameters will be common across all the jobs.So Is there any way to define a global constant with value .So that all the jobs will take the same value from the global constant.Can anybody help me. Thanks Tina

If you use an scheduller (ad hoc or standard) you can get the value across a table or a file. The end user can easily define the value of the parameters using a common tool like Access or VB. Then the scheduller, using some tables (eg. JOB and JOB -PARAMETER-INSTANCE) , knows that the parameter to l...

Most of the sites Ive worked with use a hashed file to store these. One row per global constant, the key is the constant name and the single non-key column is the constants value for this particular run. Its very efficient. The hashed file can be loaded by the first job in a sequence that gets the v...

Thanks for prompt response. I am collecting person who are interested and send to my boss. I will give you more information soon. Regards, Kittisak. -----Original Message----- From: Hendrik Kotze [mailto:hendrik.kotze@ascentialsoftware.com] Sent: Wednesday, September 26, 2001 1:29 PM To: datastage-u...

&COMO& is also used to store trace files generated when server-side tracing is enabled. -----Original Message----- From: Becky Gaster [mailto:becky.gaster@deseretbook.com] Sent: Thursday, 27 September 2001 03:17 To: datastage-users@oliver.com Subject: Re: Abnormal Termination &COMO& is a file used w...

&COMO& is a file used when capturing screen output. For example, if you typed COMO ON ABC, everything that is displayed on your screen would be saved in the &COMO& file with the key ABC. COMO OFF will turn off the capture. Becky ----- Original Message ----- From: "Hailey, Stashima [SLC]" To: Sent: W...