DSXchange

It's a convenient way to store a subset of a job that you may like to use in more than one job (rather than, say, copy/paste between job designs). For example, I use a standard mechanism for updating error information into a database table; since I do this from a number of different jobs, I use a sh...

The error message reports that the user ID does not have access to the DB2 database called LMS, though it once did. The message has been returned by the ODBC driver.

Check with your DBA.

Number of records will depend on how large each record is. By default, a hashed file can contain 2GB of data. Allowing for storage overheads, that's about 34 million 50-byte records. Hashed file records should, usually, be small. However, if you create or convert the hashed file to use 64-bit intern...

You also need to check the number of columns mentioned in the control file. All three must match. For automatic execution, the Informix bulk loader command must be able to be found by the DataStage user, which implies that it must be on the same machine. You could, of course, move the data file and ...

Please post the full text of one of these messages; otherwise it is impossible to diagnose whether it's important or not. It probably is; you've possibly lost some data because one or more characters could not be accurately mapped. When does this error occur? In the log, or only when you are using t...

You must create a directory within the project. Scripts and so forth go in this directory. It's OK to put links/shortcuts in this directory.
In Version Control you create a promotable folder, which is this directory.

ErrCode = DSSetParam(hJob1, "todayparam", 2005-03-21) This is an interesting (?) function call. The value with which the parameter would be set is 1981, which is the result of evaluating the arithmetic expression 2005 - 3 - 21. Whether the job would accept this would depend to some extent on the pa...

There is no automatic selection of access protocol in version 7.1; you must inform the DRS whether to use ODBC or a native type. This can be a job parameter.

It's all going to change in the next ("Hawk") release of DataStage, so don't rely too heavily on what you can do now.

There is to be a common, open, repository for all Ascential products (DataStage, MetaStage, AuditStage, QualityStage and ProfileStage).

The structure of the DataStage repository tables is not in the public domain and may change at any release. Why you you want to know? A normalized format of the repository is set up in doc_tool.mdb (for the Reporting Assistant). Open this with MS Access bypassing the startup macro (for example hold ...

Thanks for posting the solution, and welcome aboard! :D

I hadn't had time to look into this yet; remember too that Worksheets are exposed as system tables to the ODBC driver.

Create additional triggers (output links) on Job Activities, triggered by the job issuing warnings or failing. Direct these links to activities that perform your recording, perhaps a routine activity invoking the routine UtilityWarningToLog, perhaps a notification activity, perhaps both.

Types 1, 19 and 25 are not hashed files. Types 1 and 19 are directories; type 25 is a B-tree. Types 2 through 18 are static hashed files with different hashing algorithms. Type 30 is a dynamic hashed file. Static hashed files do manage their "table space" automatically; dynamic hashed files do. They...

It means you were not attached to a project directory. To use commands like this, you must be attached to a project directory because, when you create a hashed (or type 1 or type 25) file, an entry is recorded for it in that project's vocabulary (VOC file). Nor should the word "Type" appear in the s...

This could indicate that the CATEGORY index on DS_JOBS or DS_JOBOBJECTS needs re-building, or it may be a bug. What exact version are you running? Some time when you can get exclusive access, execute the following command either through the Administrator client Command window or via a telnet session...