DSXchange

Edit the user definitions in Web Console for IBM Information Server. Assert the new passwords (twice, as usual).

That looks suspiciously like an interview question.

DataStage is still a 32-bit application, so you need the 32-bit switch on the compiler options.

This is not part of your routine. It is a query to prove that ODBC.H exists in UNIVERSE.INCLUDE.

What happens if you rename the routine? What happens if you make a copy of the routine?

Based on what Kryt0n reported, you are wrong.

Welcome aboard.

There are command line commands UVread and UVwrite that you can use.
For example:

Slashes in a file name are probably illegal, as they are interpreted as pathname delimiters. You may want to rethink the format of your requirement.

I would always counsel the "create the file with the base name and rename it to include the data subsequently" approach.

Yes, that's about it. A search on DSXchange will give it to you. To execute the uvregen command you must be attached to the DataStage Engine folder in a CMD shell.

DataStage only reports how many records it sends to the database. If you can't use a reject link (because of Load method, for example) then you need some other mechanism, such as reviewing the log of the bulk loader. You can, of course, automate this if you know the format of that log.

It does matter, and would in server jobs as well. You can not read a file defined to be fixed width if the records are not all the same size. A single VarChar column is NOT fixed width - I usually set both the field delimiter and quote character to 000 in these cases.

When's the interview? There is no such thing as a hash file, other than a tool for shaping a block of hash. The correct terminology in DataStage is "hashed" file. It is so called because it uses a hashing algorithm, rather than a primary key index or other mechanism, to determine the uniqu...

The OLE server referred to here, I am guessing, is the one that exposes objects that the DataStage clients - in particular the Designer - use. You have experienced an OLE Automation error - probably Windows has lost the handle between your application (DataStage Designer) and the OLE server (dsobjec...

I think everyone is barking up the wrong tree here. Remember that this is a server job. In server jobs active stages are the drivers, so that here the Transformer stage is reporting the error. But it's coming from a passive stage - one that's reading data. Passive stages are libraries that expose fi...

Hidden data embedded in electronic public records must be disclosed under Arizona's public records law, the State Supreme Court ruled. The unanimous decision overturned lower courts' rulings and is one of the first decisions by a state appellate court on whether a public records law applies to so-c...