DSXchange

(1) Your code takes the THEN path in the OPEN statement if the file is opened successfuly. Open "filename" To filevariable On Error ' statements to process fatal (OS?) error ' STATUS() supplies error code End Then ' file opened successfully End Else ' statements to process ...

Except that, being on Windoze, you'll need embedded <CR><LF>.

Theoretically you could remove everything specific to 6.x from the DSX file and - as needed - change revision numbers of components and the ToolsVersion designator and it would work. But there is no documentation about what you would need to take out; you could put the hours in studying the same exp...

Not in version 6.x. Right mouse click can copy/paste in many locations, but not Columns grids. You can always use Save (into the Repository) and Load.
There's more copy/paste functionality in version 7.x, though still not Columns grids.

I've been at it over 30 years. Have learned patience. There's always more to learn. Rate of learning is finite. May I quote Confucious on the secret of all this? If one learns from others but does not think one will be bewildered. If one thinks but does not learn one will be in peril. I try to make ...

If Microsoft had wanted you to use SQL Server on UNIX it would have created a version for UNIX.

The filters are set in the ODBC driver setup screen. Last time I played with this (some years back, and on Windows) it had 25 tabs! I believe it's been cleaned up a bit since. Anyway, when you're adding (or configuring) the ODBC data source, once you've chosen the DB2 driver, this is the utility tha...

StringToDate would happily convert something like "112019741" even though it have an extra digit. That's because November 20, 19741 is a valid date (if somewhat in the future!). Basically you have to look at the month, which must be between '01' and '12', the day, which must be between '01' and 'nn...

Sounds like the first skill you need to acquire is the skill of specifying a requirement with sufficient detail that you can actually be helped! Examples are good - just look at Michael's responses. You could, of course, hire experienced consultants to perform these tasks the first time. Most of the...

That one would requre a certain extra, you need to preserve the values from the first line in the file, discard the second line, and process the remainder. The first line can be preserved in a stage variable. Its derivation would be of the form IF @INROWNUM=1 THEN col1:",":col2:",":col3:",":col4 Els...

Most of them still coincide with UniVerse commands, though there are DataStage extensions. UniVese manuals can be downloaded from an IBM web site DataStage manuals are installed with your DataStage client software, in a folder called Docs. Help (described by DaeWhan Kim) falls into six categories; c...

No. It's the links that govern the sequence of operation.

There's no generic answer to that. You have particular tasks that you want to perform, maybe adding a sequence and an identifier to a file. You know what each operator does, therefore you can choose the appropriate operator - or series of operators - to perform that task. Then you build these into a...

Calculate the first of the following month, subtract one day, generate the day number of that date. FUNCTION DaysInMonth(TheDate) * TheDate is in DataStage internal format extTheDate = Oconv(TheDate, "D-YMD") extTheYear = extTheDate["-",1,1] extTheMonth = extTheDa...

Part of, or the main reason for gathering information about tables is that, in the OS/400 environment, every file is treated as a table. When you configure your client software, you can apply various filters such that, for example, only file names matching particular patters are accessed. Otherwise ...