DSXchange

There is a single command you can use, called SETFILE. It will prompt for any argument not given. Syntax is: SETFILE pathname localname [OVERWRITING] pathname is the pathname of the hashed file (data portion) localname is the unqualified name that goes in the VOC file Example SETFILE /data03/hashedf...

Which Transformer stage reported the NLS mapping error, the one that was writing to the hashed file or the one that was reading from the hashed file? Was the NLS map for each link NONE?

Manuals for all plug-in (= optional) stages are on the DataStage CD, in a folder called Packages (sub folder Docs). Plug-in stages can be installed when DataStage server is installed or re-installed, or separately using DataStage Package Installer. Ray Wurlod Education and Consulting Services ABN 57...

A sequential file is just that. Whatever arrives is appended to it. To avoid interleaved lines the operating system prohibits two writers at the same time. There is no way that a single Sequential File stage can bypass this operating system restriction. You might experiment with the two input links ...

It's really going to depend on many variables, not least the size of the table in question, but also on what else the DB2 server may be doing at the time, what else the operating system may be doing at the time, and so on, and even on whether your two tests are genuinely comparable (in a statistical...

You can use a different text file for each job, or a different record in a hashed file. Or you can pay for a licensed ODBC driver and learn how to write code using BCI functions (consult the archives). And, to answer one of your earlier posts, BCI supports only ODBC. If you want to create C function...

This is the first time you've mentioned that you're using DB2; everyone has posted examples of using Oracle sequences. Normally the whole point of using a sequence (which is an object in the database that delivers its next number) is so that you don't have to do so within DataStage. In your example ...

My usual observation.
That kind of code only works with ASCII alphabetic characters.
It may need modification to work with alphabetic characters in other character sets (for example Greek, Russian and so on) in the NLS world.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

The correct mapping for hashed files is always NONE, since these are an internal part of DataStage (no further mapping is required). This is not part of your problem - just an observation. The ISO8859-1 map should be able to handle Ctrl-Y quite happily.

The SQL.NO.DATA.FOUND you are getting is the status of the SQLError function. It found no error information attached to the handle. When connecting to SQL Server there is almost always information attached to the connection handle; I usually specifically ignore this. ConnStatus = SQLConnect(hDBC, DS...

If you really want to do this within DataStage, you need twenty input streams each carrying E_ID and one of the other columns. Each of these has its own Transformer stage which performs a lookup and outputs a row if the lookup succeeds. The result can be inserted into the same target table from each...

While you could do this in DataStage performing twenty separate lookups the fact that all the columns are in one table and there is only one lookup table and that both these are in the same database, my suggestion would be to build a query to extract the desired result directly from Oracle, ensuring...

Depends on the database and whether you have a licensed ODBC driver to connect to it. If yes, you can create code that uses BCI (BASIC SQL Client Interface functions) - search the archives of this site for examples. If no, your code can run a small job that retrieves the value in question into a tex...

0x19 is Ctrl-Y. Has whoever created the data had to use this key to control when/where data are placed in the application and, if so, can this be prevented? It's very surprising that Ctrl-Y generates a mapping error; as it's in the C0 control set it should be included in every possible map. What is ...

In general DataStage processes do NOT run as services. The only exceptions are the resource service, which remains attached to shared memory so that it is not cleaned up, the telnet service and the rexec service. You can see these from the DataStage applet in Control Panel. Other DataStage processes...