DSXchange

Open the Transform properties from Manager. On the Detail tab is the defining expression for the Transform. It's that which you can copy/paste.

DATE.TAG, MONTH.FIRST and MONTH.LAST are Transforms and can't be loaded into routines directly. You can, however, load their defining expressions. You may still need to include JOBCONTROL.H. Or, refining Kim's routine into a single expression: Oconv(Iconv(Oconv(@DATE, "D-YM[4,2]&quo...

There's a typo in the URL - the "c" is missing from "ascential". Correct it in the address bar of your browser.

peterbaun, you need to check Disable Smilies in this post otherwise 8) will deliver the "cool" emoticon.
You can go back and edit your post and still accomplish this.

The DSObjects control exposes a Session object that has properties including HostName, AccountPath, UserName and Password, and methods including Connect and Disconnect. Is this the kind of thing you seek? You need to read the UniObjects Developer's Guide for more information. This is for ActiveX/COM...

Make sure that the FTP port isn't blocked by your firewall, especially if you're on XP with SP2.

Use user-defined SQL in the ODBC stage. If the lookup delivers N rows for a single lookup there will be N rows delivered to the Transformer stage's output (assuming no constraint).

Method 1. Use ExecSH as a before/after subroutine. In the Input Value field provide not just the shell script name but also all the command line arguments (which can be job parameter references). Within the shell script access these using standard shell variables $1, $2 and so on. You may need the s...

Use a TRANS() function. You will find this in the DataStage BASIC manual, but not in on-line help. TRANS("Maj_":InLink.ColValue:"_Tbl", Inlink.KeyValue, -1, "X") The -1 in the third argument means "return entire record", the "X" in the fourth argument means 'ret...

Welcome aboard! :D DataStage has rules for handling of two digit dates. They are converted into the century defined by the CENTURYPIVOT configuration parameter; by default the century 1930-2029. It also appears that the underlying mechanism is treating 00yy as yy. I have no explanation for '0001-01-...

Get the Plug-In Writer's Guide from Ascential. Become a very good C and C++ programmer.

I've been at a number of sites who use Vincent's "hardest" approach happily. The mainframe jobs end in an FTP stage which transfers data files to the UNIX machine.

There is no lookahead capability. You can use stage variables to compare current row to previous row, but never to next row.

The only possiblility is to create your own stage type if you want a lookahead capacity.

If the Shared Container has been changed, then all jobs that use it need to be re-compiled. This can be achieved by identidying those jobs (Usage Analysis) and using multi-job compile; it is a manual process.

Open Help from the Designer and find the topic Defining Multirow Lookup for Reference Inputs which will explain all.