DSXchange

Output from COMO goes into &COMO& subdirectory in project. Syntax for DIVERT.OUT command is: DIVERT.OUT action [ filename record ] [ parameter ] where action is one of ON, OFF, FILE.ON, FILE.OFF, TTY.ON, TTY.OFF filename is the name of an existing Type 19 or Type 1 (directory) file, such as ...

With that design, no.

DataStage reports what DataStage did; that is, the number of rows it actually sent to Oracle.

Your design is not capturing any failures so there is no way within DataStage for you to know how many records were successfully updated.

DSGetStageInfo(hJob, StageName, DSJ.STAGEVARLIST) will return a list of the stage variable names. The derivation of a stage variable is not part of the retrievable information using these functions, since it's design-time information only. You would need to recover them from DS_JOBOBJECTS, in which ...

Can you set up a list in your email system, and send to that list name?

RT_STATUSnn and RT_CONFIGnn are good choices because they are always small and static. To get a rough idea of how big to make the static hashed files, look at how big the DATA.30 and OVER.30 files are. For example: ls -l RT_CONFIG11 total 56 -rw-rw-r-- 1 aoprxw dsdevt 4096 Jan 24 11:48 DATA.30 -rw-r...

IBM would be very happy to sell you a newish tool they have called, if my memory serves, Information Integrator. Vincent has posted a couple of times about it. It does exactly what you ask - you enter SQL and don't have to worry about where the table or database actually is.

It's more flexible than COMO imho.

You can even post the job control code here, surrounded by Code tags.

3. Using Director set new defaults for the new project. Choose Set Defaults from the Job menu in Director.

... and did you read the post about needing a patch to fix this problem?

Whether you do it that way, or via a Stop request issued from Director, remember that both run and stop are asynchronous requests made to the server. A signal is sent to the running job in the case of a stop request. If the job is in a hung state where it is unable to get any CPU cycles, it will not...

You can save some work by constraining Kim's suggested query WHERE OBJNAME LIKE '%P%' so that only link ends are reported. Beyond that, however, you will need to hack as he indicated. For example: SELECT @ID, OLETYPE FROM DS_JOBOBJECTS WHERE OBJIDNO = '11' AND OBJNAME LIKE '%P%'; DS_JOBOBJECTS OLETy...

I think this one is within the CFF stage. I don't think that EXACTNUMERIC (the parameter in uvconfig) affects parallel job operation at all. There may be APT... environment variables that affect precision; I am not presently in a position to check.

This post came in immediately ahead of yours, and explains that you don't need to recompile after an abort. There is nothing in your job log to indicate that the job sequence is checkpointed. You do need to recompile after checking this box. What happens if you just try to re-run the job sequence a...

can you suggest some fonctions or routiens to direct the values from the source to the respective columns in the target based on the conditions. No. Because you have not documented the algorithms required. Because right now the main problem is that we can satisfy the conditions creating a file havi...