DSXchange

Columns called "Month" and "Year" can not just appear out of thin air!

Can you please check your work thoroughly, even to simple things like whether you're looking at the correct file??

You missed a right parenthesis, but that's just your keyboard! What's different between development and production? Can you create a job that just does the internal SELECT, perhaps into a text file? What happens with Array Size set to 1? (1000 is ridiculously high for a query that is only going to r...

Assuming that your join/grouping keys are what are sorted (since you did not specify), as soon as any key value change is detected it is known that that value will not recur, therefore that any rows with that value can be put onto the output link and memory freed. Result is less overall demand for m...

These column changes can only be a function of the way the job is designed. There is no way an FTP process (whether FTP stage or external FTP script) could effect such changes. Please verify your job design. What are the column names in the hashed file/sequential file stage? Do the rows pass through...

Search the forum for an answer to this. There is a separate forum for DataStage TX questions. It's essentially a different product.

A job sequence (not a sequencer, which is an activity within a job sequence) is a GUI for creating a job control routine. It allows routines and external commands to be part of the execution sequence. A shared container is a subset of a job design that can be used in more than one job as a re-usable...

You basically have two choices.

One is to use OPENPATH to open the pathname. This sounds like what you need.

The other is to use SETFILE (a command, not a DataStage BASIC statement) to create a VOC pointer to the hashed file, then use OPEN to open it.

Well, since this is the server forum, a server answer was provided. Perhaps a good place to ask the parallel question would be in the parallel forum? It's not the same stage type - despite having the same name - in the parallel environment.

When a job is open for editing (in Manager or Designer) or monitoring (in Director) a row-level lock is taken in the Repository database. This lock is released when the window in which it is open is closed. This situation can also occur if the Director is open in Log view, though the lock in questio...

The two inputs are port 0 and port 1. For whatever reason you appear to have specified the same data source for each.

Don't you read the answers when people post responses the first time you ask?

What happened on the system between failure and success? Perhaps the admin running the job brought the hashed file into existence, which the other user did not have permission to do.

That would work but only to a limited degree - you don't get to search the "invisible" columns - of which there can be more than 200 depending on the object type. One solution would be to use a UV stage to select from the table. Specify only one big VarChar column, and for its derivation specify EVA...

The summary suggests that none of the possibilities in your Nested Condition activity was satisfied.

You must specify at least a project name (since dsjob is not attached to any particular project) and a job name (for which you want the newest log entry). dsjob -lognewest projectname jobname If you're connecting to a different host, then you also need the authentication information. If the log has ...