DSXchange

What is the problem with this code? What assistance are you seeking?

Well designed jobs do not generate warnings unless something goes wrong (as opposed to is wrong). Tell your developers to fix the job so that it detects problems rather than generating warnings.

You are the pathfinder here - IBM has chosen not to document the structure of XMETA. Please post your findings.

Job start time can be extended not only if the job log has lakhs of entries but also if the &PH& directory has very many entries. You should strive regularly to purge old entries from &PH& as well as from the job log.

You can use @USER0 in an expression provided it is in the same process, but it is a system variable, not a job parameter, and therefore does not take the "#" characters surrounding it.

You can, in a job sequence, use a system variable to provide a value to a job parameter in a Job activity.

So you need to detect what's different between 1 and 2 and between 2 and 3.

Don't waste your time. Since this product has gone through the hands of five different vendors the full history has been lost. Nobody preserved anything not regarded as important. There is a list of version numbers, but not of the changes that were wrought in each.

Another approach is to write the "keys" (grouping columns) into the summary table, setting the measures to null, zero or some other dummy value, then to update it with the measures in a separate DataStage job.

I would have gone with [critical missing ok] as the VARTYPE as well.

What result did you expect, and what result did you get? Was blocking on name still successful?

The square brackets are not part of the syntax; they indicate that the date format string is optional. Also the first "%" character in your example does not connect to anything and should therefore be removed. The date format string describes the string being converted to date. Your example date for...

Tools > Options in Director. You will find an option for setting the default value of that particular limit. To change the limit just for one run go to the Limits tab on the Job Run Options dialog that opens when you submit a job through Director, or use the -warn option with the dsjob command if th...

Search for "vertical pivot" to find at least three ways of implementing this.

Start by defining "performance" in an ETL context.

Not sure that tunning is what you meant either.

Not necessarily. In many cases Thai characters can be encoded in a single-byte character set. TIS620 (the "standard" Thai character set encoding on UNIX) is one example.