DSXchange

I suggest you Search DSXchange for some or all of your error message.

Welcome aboard.

In Director, switch to Log view (right click on the job and choose View Log from the menu). In the log you will find the reason. Double click any log event for more detail.

I think you're reading too much into this. A Filter stage or a Transformer stage constraint would do the job.

The disk resource is where data files for Data Sets, File Sets and Lookup File Sets reside.

The scratchdisk resource is used by various operators for temporary workspace.

When's the interview?

Did you install the compiler before you installed DataStage server?

Are the compiler environment variables (APT_COMPILER, APT_COMPILE_OPTIONS, APT_LINKER, APT_LINKER_OPTIONS) set correctly?

What exactly is your question? Do you not know how to invoke MS Query perhaps? Or, if you can, do you not know how to link to a data source?

SDKSequences doesn't exist in any version. It is created the first time one of the SDK Key Management routines is used. Therefore, on an upgrade, it is important to copy the SDKSequences hashed file into place if you wish to preserve the extant sequence nextvalues stored in it.

No, I just happened to need to use the routine this week (on 8.0.1). Created a generic routine to retrieve a link row count. FUNCTION GetColumnHeadings(aJobName, aLinkName) DEFFUN DSGetLinkMetaData(TheJobName, TheStageName, TheLinkName) ***************************************************************...

You may be surprised how little. Obviously nowhere near as cheap as black and white but, once you get over 500 pages, the per-page price tends to plummet.

It might be useful to have the individual processes show their startup time, by setting APT_STARTUP_STATUS environment variable.

Perhaps you misspelled the URL. After all, you misspelled "Ernie". Some people are offended by that.

What happens if the hour elapses with no such file?

I'd run a job sequence with a loop containing a WaitForFile activity followed by a Job activity to process the file to determine what its date is, then probably a Nested Condition activity to check whether it's the right date.

IF LinkName is unique in the job, then StageName can be "" and it still works, at least in version 8.0.1. That means a lot less code.

In version 8 it's in the DataStage BASIC manual, but it's described with the wrong number of arguments. They left out the stage name.

Welcome aboard. What you seek to do is cumbersome in the extreme, would involve setting up GCI definitions for the function. You really don't want to go there. A much easier approach - given that you're in a server routine - would be to apply the Oconv() function to the internal form of the data, wi...