DSXchange

If you have all options installed, and invoke the "File > New" menu, you get five choices: server job parallel job mainframe job shared container job schedule The job in which you're actually working will have the appropriate word in the top left hand corner of the canvas. As Craig mentioned, the st...

When writing DataStage routines whose type is "transform function", every path through the code must cause the Ans variable to have a value set. In your code you could initialize the RecordCount variable ahead of the OpenPath statement. However, this could be misleading if initialized to zero. Bette...

Have you allocated enough space in the configuration file for your job? Add additional directory space and/or scratch space. Increase or remove any disk space limits that you may have set in the configuration file.

The obvious purpose is for parallelism. The sequential file stage has a "lookahead" capability. This, combined with foreknowledge of the file's size, means that it is possible to establish the equivalent of database cursors into a text file, so as to process all of its data more swiftly.

As a workaround you could remove or rename the C:\Temp folder then create a shortcut called C:\Temp to D:\Temp. That would trick it, rather than re-configure it.

A job sequence is a graphical interface for creating a job control routine. When the job sequence has been compiled, you can inspect the job control code that has been generated. Some people use this technique to prototype job control code then modify the code to their exact requirements. Others, us...

You have access to these routines from parallel jobs if you use the "BASIC Transformer" stage (not the Transformer stage). Search the Forum for "BASIC Transformer stage" if you're having trouble finding it in Designer. This post should help; about half way down there's how to find the stage in the P...

Have you used any other debugger in the past? Debuggers allow you to step through execution at human speed rather than at computer speed. While doing so you are confirming or rejecting hypotheses about what should be happening. Your arsenal of tools, in any debugger, consists essentially of three th...

He sure did!

UniVerse (DataStage) sort has been multi-threaded for some time, and does use a parallel sort under "appropriate conditions" whatever they are.

Search for SETFILE (without a dot) rather than SET.FILE (with a dot). SETFILE creates an "F" pointer in the VOC file to the location of the hashed file. SET.FILE is used to create a "Q" pointer, which means that the hashed file must be in another project. This is not the one you want. (Don't shoot t...

DaeHwan, The NONE map is correctly used with hashed files, because these are already "inside" DataStage, so any data in them have already been mapped. The only simplified Chinese map supplied with DataStage is GB 2312 (for UNIX) or MS936 (for Windows). You've stated that you're on UNIX, but have tri...

This is a server question posted in the Parallel Extender forum. Perhaps you could think about changing your signature! Stored procedures in server jobs are called using an ODBC stage. If that ODBC stage is feeding a reference input and execution of the stored procedure is not successful, then every...

Welcome to the Forum! :D Job parameters are given default values in the Parameters tab of the job properties window. When you request that a job be executed from the Director client (or in the Debugger in the Designer client), a Job Run Options dialog opens. This has a Limits tab, where you can limi...

Constraint expression