DSXchange

No. I don't know. I don't even know if it's possible, indeed I doubt that it is. You would need to compile them using the mainframe's C compiler, and construct a mainframe library out of what you've compiled (or including same in an existing library). Only then could you use an External Routine stag...

... or a recursive routine using BCI functions. It's Windows, so there are not ODBC licensing issues. It can be done, I've done it: a scheduler in which all the dependencies were in an Oracle table, nested up to seven levels deep (but potentially more).

Welcome aboard. :D

Yes, it can be written in DataStage BASIC.

Fairly sure that it will not install, and that this is picked up by the InstallShield wizard.

chulett wrote:Ah... Kim Duke, the Laura Croft of ADN.

(just kidding!)

Wrong shape, surely? Or is Laura Croft someone different from Lara Croft?

Is there a Lara Bush? (That's a frightening thought!)

Copy stage can not add columns to the record schema. Column Generator stage can.

You can create metadata in the table definition in Manager (or Repository view from Designer) to accommodate these columns.

Yes, provided that the link has metadata defined for them. (It's not necessarily four columns, and they're not necessarily at the end - I tend to have them at the start - it depends how you build your match output within QualityStage.)

You asked that question, and it has been answered, here.

One of your network administrator or possibly your SQL Server DBA will be able to help.

The other choice, of course, is to expand the vector prior to writing to the sequential file.

The only good option is to use Usage Analysis to determine in which jobs the table definition is used. Re-import the table definition then manually edit the links where that table definition is used, loading the new column definition. Following this approach means that linkages between your job's me...

Have you thought through the implications of "Folder" processing in a parallel execution environment?

Any maximum size of a sequential file is set in the operating system, not in DataStage. If you have a 32-bit operating system with a 32-bit file system then the maximum file size is, by default, 2GB.

BASIC Transformer stage? This will allow you to use Oconv() admittedly with a throughput penalty.