DSXchange

You can also set up remote file pointers in a VOC. UniVerse-to-UniVerse these have the form hostname!pathname in field 2 (and field 3), which triggers the UV/Net software.
Presumably, therefore, you can include the port number in this construct too, for example hostname:port!pathname.

Informix is known to be VERY sensitive to the version of ODBC driver for any particular version of the database. Contact IBM support for details. It may be that it's the version of the driver that is causing the problem that you are seeing. Have you tried it with a non wire protocol driver?

Edited previous post. The corrupted hashed file is one that the project itself uses, not one of yours. It could be VOC or D_VOC, which would certainly render the project creation project invalid. Or it could be any of the DS_... hashed files in which design-time information is stored. Or it might be...

To be brutal, it's not a DataStage problem.

You have not been granted sufficient authority in DB2 on the AS400 to obtain a list of table names (or perhaps of a list of column names for a particular tables).

You must negotiate to get this authority granted by the DBA.

In the transitional definition don't specify that the target column is nullable, and handle the incoming null so that it is replaced with a default value (or dropped).

Development/Debug is a Category. If you'd prefer to have the Column Generator stage in a different category, customize your Palette and move it to where you want it. There is no reason whatsoever to eschew use of the Column Generator stage in production - bcarlson's site makes good use of this stage...

There is only one way using the Stored Procedure stage, and that is to be patient and wait until "they" incorporate support for SQL Server stored procedures into the stage type. Meanwhile, you can get at recordset-handling stored procedures through the ODBC Enterprise stage or the Dynamic RDBMS (DRS...

The purpose of RESET is to restore the job to a runnable state. This might involve dropping or resetting database cursors, rolling back pending transactions, closing open text files, clearing locks; anything. Best practice is as implemented in job sequences "reset if required, then run". There is ra...

That's cool. When your support provider tells you when you expect the fix, please share that knowledge with all of us here.

There isn't. You could create a job sequence to identify the hashed files then run a job to count the records in each, appending the results to a file or inserting into a database. Do you want to include all the hashed files that make up the repository? Is there a standard location for your hashed f...

It means that you have tried to create a schema while logged in as a user who does not have DBA privilege. Delete the project and start again, this time logged in with DBA privilege. To find out which users have DBA privilege execute the following UniVerse command: SELECT NAME FROM UV_USERS WHERE DB...

It means two things: (a) that you were logged in as a user who does not have DBA privilege, and (b) that at least one of the hashed files has become corrupted. Delete the project and start again, logged in with DBA privilege. To find out which user IDs have DBA privilege, execute the following comma...

If the Oracle instance is not on the same machine as the DataStage server, the hashed file will win every time. Lookups across networks are very inefficient.

The shared library path may be defined (in $DSHOME/dsenv) for DataStage processes. But, if you log in as an interactive user, does your .profile file set them for you? Possibly not. You should execute the dsenv script.

So which part of "engineering has replicated" (it's a bug), "it will be fixed in a future release" and "will get back to you" is unclear?

Given that it's a known bug, are you really expecting someone here to be able to fix it? No-one here has DataStage source code.