DSXchange

Probably easiest is to write to two separate sequential files, and cat them together afterwards.

You can also construct a line containing record1 : LF : record2 and write that to a single sequential file for which you have defined just one VarChar column.

They are in a text file called DSParams in your project directory on the DataStage server machine.

Welcome aboard! :D If your source is a database you can use user-define SQL and perform SELECT DISTINCT right at source. If your source is a text file, you can pre-process it with the sort -u command (even though you are on Windows, DataStage 7.5 ships with MKS toolkit, so that you can execute most ...

It's nothing to do with DataStage; it's a configuration such as number of listeners. Ask yout Oracle DBA.
You might also execute the command oerr ORA 12540 (at the operating system prompt on the DataStage server machine) in case this might shed more light.

dsftp.so is on the server machine. It is the library supporting the plug-in stage itself.

dsftpune.dll ("une" = "United States English") supports the GUI - the client piece - of the FTP stage. It is on the client machine.

Are you finding it under Server or under Parallel?

At one site where I worked late last year the requirement was similar to yours. Indeed, the business rules depended on what data were available in addition to changing over time. We implemented a "late binding" approach, where a table-driven approach was used to select the appropriate business rule,...

there may be more than one record in existing database A hashed file is based on a primary key lookup. A primary key equality constraint can only ever return one row. You may need two separate lookups against the same hashed file, if you have two different fund identifiers. Otherwise, the Hashed Fi...

Can you create some test data files in which there are no column headings? It may be that there is some data type interference occurring with the column headings.

There is a long-term project to change the back end. In the next major release of the product the structure of the Repository database will be changed, so that all the products in the Enterprise Integration Suite can share the one repository. However, no major changes to DS Engine are envisaged in t...

First point is that both methods work. So would a design with two Transformer stages each performing three lookups. Technically one Transformer stage can have 1 stream input, N outputs and (127 - N) reference inputs. However, by cramming all of these into a single process (for larger N) you probably...

UniVerse and UniData are both database products, now in the IBM stable where they are jointly called "U2" (not to be confused with a certain group of Irish balladeers). They were created by separate companies. VMARK Software, Inc. was a public company that created UniVerse in 1984; UniData was a pri...

Fewer.

The error may actually raise on the Merge stage. However, being a passive stage, it has not reported the error but its caller, the active (Transformer) stage, has reported it. Please post exact details of the join you have attempted including the definitions of key columns in both source files. Do t...

I think I was trying to say that the design UV stage ---> Transformer stage ---> Sequential File stage could perform the required task without much (any?) code. Table name in the UV stage is RT_LOG#JobNumber# WHERE condition in the UV stage is TIMESTAMP > '#JobStartTimeStamp#' Both of these can be r...

At some point you're going to need some metadata. Since you want to persist with RCP, I would advise importing the sequential file's table definition now that it has been created, and use that in subsequent jobs. Better would be to load the metadata back into the job that creates the sequential file...