DSXchange

ray.wurlod

So now you look at your database stage, in particular its dboptions property, and figure out what you've put in there to cause a syntax error - in particular there's a "." that was not expected to appear where it does appear, and where the expected character is "," or "}". You may find it useful als...

ray.wurlod

You can set APT_DISABLE_COMBINATION for project-wide or job-wide disablement, or you can disable any stage's combinability on the Advanced tab.

ray.wurlod

The second person personal pronoun in English is spelled "you", not "u".

ray.wurlod

Yes. It's called a consultant.

There is no software tool of which I am aware.

ray.wurlod

bman wrote:Is there a way we can reset the loop counter value from inside a looping sequence.

No.

ray.wurlod

We do not even attempt diagnosis of errors thrown by APT_CombinedOperatorController.

Disable operator combination and reproduce the error, which will now be reported by the actual operator (stage) that generated it.

ray.wurlod

I don't believe so. Even the Data Set Management tool uses orchadmin under the covers.

ray.wurlod

Interesting. There's no DEFFUN declaration for it in DSJOBCONTROL.H, which is the basis for my earlier non-existence statement. However, it is cataloged in the VOC file, so I guess it does exist after all. To use it in a routine you will require your own DEFFUN declaration, or you will need to call ...

ray.wurlod

No passive stage is permitted to open its output link(s) until its input link is closed.

You need to re-think your job design.

Code: Select all

OCI ----->  HashedFile
                |
                |
                V
OCI -----> Transformer -----> OCI

ray.wurlod

There is no DSGetStageLinks.
You must use DSGetStageInfo to get a list of all the stages, then use DSGetLinkInfo on each link to determine what kind of link it is.

ray.wurlod

Stop thinking like a server job developer.

Parallel jobs CAN finish even though one of the components has logged a fatal error. That is because the Conductor process, which almost never has a fatal error itself, finishes normally.

ray.wurlod

Code: Select all

SELECT * FROM SYS.MESSAGE WHERE @ID = '081016';

SYS.HELP.  081016
MESSAGE..  dsrpc: The TCP/IP connection was refused.
           dsrpc: The dsrpcd is probably not running.

ray.wurlod

Code: Select all

If (IsNull(InLink.col1) Or IsNull(InLink.col2) Or (IsNull(InLink.col3)) Then "N" Else "Y"

ray.wurlod

There are various aspects to administration that are allowable only to the administrator. Setting up the security is one of them. Licensing is another. If you're not the administrator, these functions are disabled.

ray.wurlod

Craig has been working with DataStage and Oracle since nineteen mumble mumble. Who are we to counter his sage words? I am currently working on such a configuration (with the Oracle client software co-resident with DataStage server) and it's perfectly happy. It's not broken, so I have no intention of...

DSXchange

Search found 53125 matches

Re: Loop activity - How to reset the loop counter