DSXchange

What happens if you need to restart the server?

... in particular of the DB2 stage. You can alter the behaviour of the ODBC stage to be the same (convert to DataStage internal format) by specifying a Data Element of Date.

COUNT DS_JOBS will be very close, but would include a couple of control records. COUNT DS_JOBS WITH JOBNO LIKE "1N0N" will be more accurate, or COUNT DS_JOBS WITH NAME LIKE "1A0X"

If you prefer SQL, SELECT COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '\\%';

It's not DataStage that creates *.dtl files, it's rajan.n (the original poster). This is why the RMM stage was indicated.

That's the "propagation" happening.

You CAN use fixed width in parallel Sequential File stage. I did one today. Set the Record Length property to "Fixed" and do not have VarChar data types. If you import the table definition of a fixed-width text file, then Load onto the Format tab in the parallel Sequential File stage, this happens a...

Search on this forum will provide the answer!

.dtl = "detail". You obviously haven't installed the Read My Mind stage! The first two lines can be extracted using Field() functions with ":" as the delimiter. Using stage variables allows you to preserve values through other lines. svJobName: If Left(Line,21) = "STATUS REPORT FOR JOB&...

You have misinterpreted. You can not "create a Lookup File Set from a hashed file". You must use a parallel job to reference a Lookup File Set, and you can not reference a hashed file (other than through an External Source stage) from a parallel job. You need to create a new parallel job that does w...

Because your question forbade the use of message handlers, you have no choice - you have no way to stop DataStage from generating this message. Live with it. Or consider a message handler.

Depends where you're doing it. My original answer was from memory. It's Nulls position in the context menu on an input-link sort; have not yet checked the Sort stage.

You can use as many servers as you like, but will need to buy a separate licence for each unless you own an special "enterprise" licence (not the same as Enterprise edition, but one that allows up to 999 CPUs over one or more machines). Contact your vendors; they will be more than happy to hear from...

Search the forum for earlier answers. There is no hard and fast number. The XML Input stage was never intended to handle large files. Search for alternatives.

If that's the only error, allow the new project to run to completion, then execute DS.REINDEX ALL in the project.

You might need hard quotes around the wildcarded -name option for the find command