DSXchange

What is the source of your data - database or text file?

If you are using mv then you are in a UNIX environment, where case sensitivity is imposed. Are the pathnames properly cased as well as properly spelled? Does the user ID under which DataStage jobs are executed have sufficient access to all the directories in the path (including the root directory) t...

It's probably worth either asking the vendor whether it's changed in the Hawk release or putting in an enhancement request. There's a forum here for the latter, or you can do it through your support provider.

DataStage parallel jobs are perfectly happy with CHAR as a data type.

Unlike server jobs, however, parallel jobs enforce the rules: if it's CHAR(n) then it MUST be n characters long, including the null field value.

End of story.

Basically you have to get the metadata to match. One is using string, the other is using ustring in the record schema. You could try changing the data type in the table definition so that it matches, which may work if you're using ASCII data. Note that Srinivas's advice about using hashed files is n...

What stage type? Oracle Enterprise, OraOCI, Dynamic RDBMS, ODBC or something else?

It's perfectly OK (if not recommended practice) to work on a job design while the job is running. The running job uses the compiled version (generated OSH and any C++ components) of a job (not the design components), and you will find that DataStage prevents you from compiling a job that is actually...

I think that the OP wants to generate a sequence number for INSERT, not for SELECT. RANK is a display function, used with SELECT. If a sequence exists in Teradata, then it should have a CURRVAL and NEXTVAL property (note that these are the Oracle names; the Teradata names may vary slightly). You sho...

Since you claim that the sort command works from the UNIX console, Ken Bland's advice to put the sort command in a script and invoke the script is good advice. Sometimes the transition from DataStage to the UNIX shell alters commands slightly, particularly where quote characters are used. Look in th...

Mayhap they're not text files, but files with records in Oracle storage format that were rejected. If so, there is probably some Oracle utility that can be used to read them.

Describe your job design. In particular, what stage type are you using to access Oracle, and what is your "write rule"? Can you View Data using this stage?

Definitely. In my opinion mainframe jobs are the easiest of the three types to create. And, yes, they generate JCL to compile and run the COBOL code that they also generate. You can inspect the code and the JCL, and even customize the JCL templates.

Somewhere in there you're going to need some reference to stdin. For example cat - | grep 'A' . However, obviously this grep won't do it in a generic sense; you need some way to identify just the 'A' in your val column; perhaps you need to pass the column number or some other means of recognizing th...

There is a TX plug-in that can be used from server (?) jobs to run some data through TX maps.

From memory I recall that a variable in COMMON is used to store the dynamic array, and the other function decodes it from there. But, as stated, I'm not anywhere where there's DataStage; it's Friday night and I'm going out just as soon as I've finished my DSXchange chores.