DSXchange

Use a server job to perform the query. In a Transformer stage call a routine that puts the value into the job's user status area. You'll need to create the routine, which is an interlude to the subroutine DSSetUserStatus. FUNCTION SetUserStatus(Arg1) $INCLUDE DSINCLUDE JOBCONTROL.H Ans = 0 Call DSSe...

Have a look at the readme file for FixPack 1; I can't recall whether this specific issue is covered there, but there's a half dozen or so Business Glossary fixes that you'll almost certainly want to have.

What do you mean by "package" in this context? What, further, is your goal?

Read the strings as Char (not VarChar) and provide a sufficiently large precision value for the Decimal number.

Simply add $APT_CONFIG_FILE to each necessary job as a job parameter. You can set its default value to be the same as that for the project, or to the pathname of any other configuration file. Further, you can override the default value when the job run request is made.

Correct the connect descriptor in tnsnames.ora file.

For a small enough list of asset data, use in_reference_list check. For larger list use in_reference_column. Use a virtual table in IA to establish the "join".

Welcome aboard. Since it appears that the only way to access these is through one of their apps, you need to work out what's most appropriate. For example, if any of the apps is exposed as a web service, then you could use the Web Services Transformer stage (or perhaps Web Services Client stage if y...

Most operating systems allow you to set an alarm to do this.

The real question is what are you planning to do should this situation arise?

ArndW wrote:I can't check but seem to recall having to use '0001-01-01' as low-date in DataStage in a project. Months 0 and Day 0 don't exist in any case, so '0000000' is not a legal date in any case.

Year 0000 doesn't exist either.

Maybe you could just return the row number and check whether that's 1 or higher (a simpler query)?

The main governing factor is the amount of resources (including CPU, memory, I/O bandwidth) that the server can supply. Bigger server; more jobs.

This is a very simple Pivot, based on the first three columns as pivot key.

Is this database stage servicing a reference input link?

Or you could even make it a Filter command; the Sequential File stage reads stdout of the Filter command.