DSXchange

Does your job design have 13 columns, one of which is Key ?

will generate the time in DataStage internal format. I'm not certain whether the Teradata stage expects internal for external format.

What we have here is a violation of the "law of least astonishment".

If you design jobs that perform "hidden" tasks - such as via before/after subroutines - place an annotation on the job canvas to alert future developers that invisible behaviour is happening in the job design.

Check that you're using exactly the same name for the stage variable in the stage variables grid and in the column derivation expression that employes it. Both spelling and casing must match.

Look in the job log for warnings of the form "variable not assigned, zero length string used".

The first time, for whatever reason, the job compilation on promotion failed to add a DEFFUN for the Routine, possibly because the Routine had not properly been promoted/compiled.

With mkdbfile the option has a hyphen ( -64bit ).

The 64BIT option belongs with CREATE.FILE or CREATE TABLE.

Click on Help while there. If you don't understand the explanation given, please post it and where your remaining question lies.

What I was referring to is the ability to work with more than one partition. Your processing has been managed on more than one partition - did you collect all rows into a Sequential File stage running in sequential mode? Only in that case will executing cat via ExecSH make any sense.

Most of the difference is in the network, as you can verify by comparing local versus remote users' experiences. With only 100 jobs per project, there is little within DataStage that would be causing such delay. Sometimes I use a similar (non-Citrix) connection between Australia and the USA (just co...

There is a CoSORT plug-in stage that gives access to CoSORT functionality. "Plug-in", of course, simply means "optionally installed". In this case - due to licensing issues - it also means "separately chargeable". I can not comment on its use, as I have not used it. However, if you visit the sister ...

Perhaps you could raise another request with IBM (it's not Ascential any longer) to test their patches?

Filter stage is only available in parallel jobs. You posted on the parallel forum, which is why folks replied as they did. Your only possible choice of stage in a server job is the Transformer stage.

Then you can't use NEXTVAL in the INSERT statement, and need to use some other mechanism. CURRVAL is not available within the job, which is probably (a) using NEXTVAL on all partitions, (b) implementing row buffering, (c) not committing every row. Probably the most efficient mechanism for your parti...

By whom? Please attribute your sources. Otherwise you may have been told by a stand-up comedian: we have no way of knowing.