DSXchange

You need to do some research in the manuals about what "active" and "passive" mean in the context of DataStage stage types. That will guide your thinking in resolving the particular question you asked. Passive stages don't generate processes at run time. That statement should tel...

It wasn't good enough. Their manuals explicitly stated that you should never make any assumption about the data type of the job handle variable - you should treat it as opaque. Then they go and break their own rules. When IBM do change it's data type from integer row number in internal table of job ...

Everything in the same file has global scope within that file. This can result in side effects if you do not take care using GoSub.

This might be confusing. What do you mean by "in this file"? If it's a purely internal routine, within the same routine, then it is accessed via a GOSUB statement and no DEFFUN declaration is required. Otherwise, it's a separate function - has a separate entry in the Routines branch of the...

SELECT NAME, STATE, MIN(START_DATE), MAX(END_DATE)
FROM tablename
GROUP BY NAME, STATE

Did I miss something?

Good, thanks for that. You did it before I could get back to you.

Should be no problem. The Information Server products need to know where the Information Server itself (the domain server) is, and vice versa. If you set up (install) the components individually you will be asked for this information by the install script. You can NOT achieve what you are seeking to...

It's the same error you previously reported, now you know for sure that it's the ODBC stage which is generating the error. You now have to search for the exact error message in DSXchange forums, and work out what you are doing in your ODBC stage that might consume more heap memory than is available.

I typically use a "harmless" function (get job name) right after the call to DSAttachJob() function. This is a quick way to test whether the attach succeeded; if it didn't the harmless function returns DSJE.BADHANDLE. Job1 = DSAttachJob("AuxTimeFactLoad", DSJ.ERRORNONE) TheJobNam...

We never even bother to try to diagnose errors thrown by APT_CombinedOperatorController. Disable operator combination so you can learn which actual stage (operator) is throwing the error.

Download ETLstats from Kim Duke's website - which will do it all for you.

Can you try LIST DICT DS_AUDIT (without the dot)? If only one record is listed then someone at your site has stripped the metadata from DS_AUDIT. So there is no definition for CLASS or, indeed, any of the columns in DS_AUDIT. Find that person and castigate severely. If the DS_AUDIT hashed file in a ...

Get version 8 and use Slowly Changing Dimension stage, which does it all. (Well, in conjunction with Surrogate Key Generator stage.)

What type of server routine? The method is different depending on whether it's a transform function or a before/after subroutine.

For transform functions you need a DEFFUN declaration.

For before/after subroutines, which are called with CALL statement, you need to add the "DSU." prefix.