DSXchange

The WEOFSEQ writes an EOF (end-of-file) at the current location, truncating the file. And your WRITESEQ statement won't work the way you expect it either, as the file pointer is at the beginning of the file after you open it. You need to put a SEEK MyFile 0,2 after your open to position to the end o...

Make the links from Transformers B C go to a funnel stage and then output straight to F

I don't think that the correct c++ compiler from Visual Studio is installed. the path to "cxx" is in the MKS toolkit directory, which can't be right.

The only correct way is to get rid of the warning message. An alternate way is to demote or ignore the warning message. This can be done with 7.5 PX DataStage for PX jobs. See the directory tab Tools -> Message Handler Environment or look into the DataStage Manager Guide , 14-1 "Ma naging Message Ha...

thanks for catching the Server reference!

The four most common causes of the write failure:

1. NULL or @FM in the key
2. insufficient OS level access rights
3. Standard file growing beyond 2Gb limit
4. Corrupt hashed file.

You have have ruled out #4

No, it cannot be installed on that version. It will install on XP Pro, but is not supported.

I used "tend to" because I seem to recall the Informix ODBC driver was faster than the direct connection for server.

The difference is that the methods of connecting other than ODBC are usually direct ones supplied either by the manufacturer or a third party. ODBC is an open de-facto standard interface (free on windows, not always free elsewhere) to allow a common access to databases or database-like objects (i.e....

does "ping localhost" work? If you can't telnet to the local system, then the DataStage installation has most likely failed. You might be best served by reinstalling.

The normal method of reading a sequential file in a DataStage job does not let you append a row easily using that methodology.
This can be done with a simple command at DOS or UNIX, you can also open and append data to a sequential file from inside a DataStage routine (using OPENSEQ and SEEK)

From BASIC you can call DSGetJobInfo() and use the DSJ.JOBCONTROLLER InfoType.

A DataStage PHANTOM is a background process, and if that process outputs to stdio then a message is put into the log. I haven't done too much QS so I don't know what the contents could actually signify, but it doesn't look like an error.

I've installed on XP pro with no visible problems, although it isn't supported. If you did a normal install and the telnet to localhost doesn't work then it is likely that your install was either not successful or you haven't started datastage.

Try entering the folowing from either "run" on the windows taskbar or from a DOS window: "telnet localhost" then you should be prompted to enter your new userid and password. If asked for a project, enter your project name (it is case sensitive). You will be at the TCL prompt, enter "QUIT" to exit t...