DSXchange

The error message suggests that the schema definition for the field STORED_FILE is in some way incomplete. Please check the schema associated with this field.

One thread, one topic, say I.

With your proposed suggestion I would never have gotten beyond one post.

It works great now but out of curiosity, is there any reason why I can't use "?" and what's the difference btw using "?" and ":1"? Because you never mentioned your database. Stages like the ODBC stage use the stoopie generic positional question mark parameter marker while Oracle uses the much more ...

Make sure you have a good backup (check it by reading its index). Make sure you have a good export of each project (check it by a "fake import" - import selected then cancel). Stop DataStage. Install new server version, licensing same (projects will be upgraded automatically). There should be no pro...

gateleys wrote:What if decide to replace the 'sharp stick' with my kung-fu technique? The one where my index and middle fingers are forked...and then I lunge at his eyes.

The Three Stooges live! Should we call you Moe?

It's a South African (Boer) and/or Dutch term meaning a small step.

ExtractLogMsgs is one of yours, not one of DataStage's. All DataStage routines have names beginning with "DS". You can post the code here (a) if your employer permits and (b) you want us to check it over. Don't forget to enclose it in Code tags so that formatting is preserved. There is a Create stat...

What exactly do you mean by "source system"? The operating system command hostname will return the name of the machine on which DataStage server is running. So will the macro referred to earlier. But the system on which source data reside is entirely a matter for your design/setup. You (or someone) ...

Prior to version 6.0 DataStage was licensed per project, so it was an expensive undertaking to add more projects than were licensed. Since version 6.0 DataStage is licensed per CPU so there is no limit to the number of projects. (This may not be the case: an enterprise licence limits to 999 CPUs - t...

It's gotta be Essential Drugs and Mmmmmm....

or a kind of cheese originating in the Netherlands.

The Terminator activity has a "wait" option, implemented as a check box. However, a Terminator is the "end of the line" - it does not support output links, so you can not then go on to any "act accordingly". You need to re-think your design.

Use a script to invoke the master control job sequence if you want to feed the overall result back to an enterprise scheduler such as Control-M, UC4, SeeBeyond, etc.

You are trying to invoke ExecSH from one of your own Routines. ExecSH is a subroutine. Both DSU.ExecSH and DSX.EXECSH should be cataloged; execute the following command to determine that they are: SELECT @ID FMT '40L' FROM VOC WHERE EVAL 'UPCASE(@ID)' LIKE '%EXECSH%'; If you do not get four ...

Perhaps your log and trc files are becoming full. Do you monitor them regularly? Do you have someone responsible for checking them for warnings and the like?