DSXchange

The pool named "" is the default pool. Nodes not constrained to execute in a particular node pool will execute in this pool. Disk pool "export" is used by the export operator, which is invoked when writing sequential files and File Sets, for example (when a translation from inter...

Make sure your Oracle DBA has configured a sufficient number of listeners.

chandra.shekhar@tcs.com wrote:I think the simplest way to do it is in the source query itself if ur source is a database.

Ur was a city in ancient Babylonia. The second person personal possessive pronoun in English is spelled "your". Please maintain a professional standard of written English on DSXchange.

Just to be clear, when you say "pound symbol" do you mean the currency symbol (₤) or the sharp sign (#)?

Try qualifying the table name with its schema (owner) name.

Very well, thank you.

Perhaps it's urgent.

Yes, the stage description is in field #4 (DESC) of the pertinent DS_JOBOBJECTS record. You can get it with a query or with code. SELECT "DESC" FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<JobName>>') AND OLETYPE = 'CCustomStage' AND NAME = '<<StageName>>';...

Amuse yourself with this in the meantime. It verifies that DSJ.STAGEDESC returns -7 on the system where I'm working too. Both when the stage has a description and when the stage has no description. FUNCTION StageInfoTest(JobName, StageName) $INCLUDE DSINCLUDE JOBCONTROL.H hJob = DSAttachJob((JobName...

Do you have a UNIX-based ODBC driver for it? In that case, the answer is yes.

We need to see the server job metadata both for Format and Columns.

Import the table definition from the sequential file then, in the table definition, click Sync Parallel. Then use the table definition in the parallel job.

In private correspondence (we work for the same company, though on different projects) TV John assures me that the stage name is correct. Investigations continue.

No errors.

Issues of data synchronization, particularly if you clear the hashed file before writing. And definitely if you re-create the hashed file - that would cause errors.

Parallel job or server job? The error messages look like a parallel job, but there is no Folder stage for parallel jobs.

You can use standard redirection operator. For example: