DSXchange

Show us how - and where - you specified the range lookup.

The last line of at least one of your source files is missing its line terminator. The "eof" that was encountered unexpectedly is the operating system's "end of file" marker.

No.

REJECTCODE gives you DataStage's code. Other link variables are SQLSTATE (for ODBC), DBMSCODE and LASTERR. LASTERR is the text of the error corresponding to DBMSCODE. Make sure you have plenty of room for this, say VarChar(2000).

Research "derivation substitution" to reduce the cumbersome aspect.

I am not aware of any setting that changes the string pad character in server jobs - you could try setting APT_STRING_PADCHAR to 0x00 but I doubt that that would have any effect in server jobs.

In version 7 the MQ Series server must be co-resident with the DataStage server. Is this requirement satisfied? (The requirement is relaxed when you upgrade to version 8 DataStage.)

Functions ...To... belong in the Transformer stage. Functions in the Modify stage mainly include ..._from_... for example Timestamp_from_String. There are errors in the Parallel Job Developers Guide chapter on the Modify stage. The best reference for the Modify stage is the Orchestrate Operators Gui...

Use something other than View Data.
The data browser, being a compromise across all data sources, is notorious for not always displaying data correctly.

This was posted 01:20am my time. Curiously enough, I was asleep at the time. What happens after you re-boot the client? If you want urgent help, sign up with your official support provider for priority service and learn just how much "urgent" costs. DSXchange is an all-volunteer site whos...

We also have a philosophical objection to answering what are clearly interview questions, stemming from a belief that people should interview based solely on their individual merits.

hema177 wrote:How would you know I am not?

Because you are getting a different error code.

You're very close. The first job stores the result set somewhere, perhaps in a text file or a record in a hashed file. Your sequence then uses a command or routine to read this as a single string. Include a user variables activity to convert the field marks (line terminators are converted into field...

If you specify Date as the Data Element, DataStage will expect an internal format date.

You need to mention the stage type you are using; I am assuming that it is an ODBC stage or a Dynamic RDBMS stage set to ODBC. SQLColAttributes() is called while the stage is opening; the fact that DBMS code is zero suggests that the problem is reported by the driver being unable successfully to int...

Projects don't grow that much; obviously it's a factor of how many jobs you create in the project, and whether you keep your logs purged nicely. No data are stored in projects. The next question is whether or not you are going to stage data. You will need sufficient space to do that, whether in sequ...