DSXchange

No, because you have not informed us how you are trying to pass the parameter values. I assume you mean to a sequence, rather than to a sequencer.

Welcome aboard. Is this an interview question?

Sure is. Use a conditional lookup. On the same screen where you set Lookup Failed rule you can build a condition (probably using IsNotNull() function) and specify Continue or Drop as the Condition Not Met rule, as appropriate to your needs.

DataStage wrote:This input-file data set does not exist:/home/abhik/tgt/sort.ds

This message suggests that you are trying to read from a non-existent Data Set.

We don't do "urgent". We especially don't do "very urgent". DSXchange is an all-volunteer site whose members post as and when they can. If you need urgent help, sign up with your official support provider for priority service and learn just how much "urgent" costs. My ...

I can't see where you said that before.

Or, slightly more simply InLink.TheField[Index(InLink.TheField, " to ",1) + 4, 999999] This method relies on the fact that the string returned by the substring operator ends at the end of the source string no matter how many characters were actually requested in the substring operator. Not...

Yes, RESIZE can accept any of the dynamic hashed file properties on its command line. RESIZE hashedfilename * * * SPLIT.LOAD 80 MERGE.LOAD 60 Your assumption about whether things will be improved or not is predicated on intelligent choices being made regarding the new settings! However, your belief ...

So, you have no text() item?

Any suggestions . :idea: Suggestion: Learn that DSXchange is an all-volunteer site whose members post as and when they can and, if they have nothing to contribute, will typically not post anything. If you insist on demanding responses, do so of your official support provider, whom you are paying to...

Generically use CAST operator. You can still use AS to create the alias.

You'd better post the exact error message because your subject ("on a not nullable field which is Nullable") is totally confusing.

Verify the data type of INDV_ID in Teradata. DataStage is having a problem with that.

APT_STARTUP_STATUS

(1) Impossible to say - depends on many other factors, such as what indexes and constraints exist. (a) Don't know, but presumably yes. (b) Array size is the number of rows sent in a single batch - that won't change. Transaction size is how often a COMMIT is issued. See next answer. (2) Commit is not...