DSXchange

Did you import the binaries as well or do a compile of the V7.5.2 in the V8.1.1 project? The jobs should be re-compiled at 8.1.1.

What sort of a file are you trying to open as output (or could it be reference input) to that transform stage?

They will run in sequence if you link the two, and in parallel when you don't.

Read up on transform stages and Stage Variables, I prefixed the name of my stage variable with "svar". Please read up in the BASIC manual (in PDF format installed on your client machine) for the INDEX() function.

The INDEX function takes 3 parameters INDEX(String,Substring,Position).

Has Teradata been installed on the new server (look into the designer -> stage types -> Parallel)?

reset the job and see the further details in the "from previous run..." entry. What kind of a stage is "xx_xx_File_Job..tDefaults_xfile"?

One of the Ctype values is the list of characters that are considered numerics for the locale, and also those which are not considered to be alphabetics. Since this Count() function seems to check only aphabetics the locale settings in NLS could affect the results, but I'd wager that in almost all l...

The "dsjob -lparams" call will not execute a job, but list the parameters that it uses. On a similar note, could you explain what sort of parameters you mean - particularly the parameter file. Perhaps at your site you have a written set of programs or routines that populate parameter values.

Sreenivasulu,

could you explain that? While NLS substring functions on multibyte strings need to be handled differently internally, i.e. not use the usual 1-byte boundaries, there is no general problem with NLS that I know of.

DataStage doesn't support a CASE function, but here is a solution using a stage variable svPos and output the column MonthNumber

...The Teradata API Stage(source) in server jobs is not working, but it is working fine in the parallel jobs... Could you narrow that down a bit, perhaps with an error message? The same thing applies to the warnings you are seeing. Generally NLS functions well, but one always needs to understand th...

Is this "archive" command a UNIX or a DOS one? Does it have an ending? If you "cd /fld1/fld2/fld3" and then execute "archive" or "./archive" does it work?

how about explicitly doing a "sh" in DOS, does the command work then?

COBOL has the concept of "high value" but other languages do not. You have a 0xFF value as high value coming in, but as that is not defined as a standard EBCDIC character there is also no defined conversion for it in ASCII. If you wish to convert these character high-values to spaces, do a...