DSXchange

This is all pretty simple string manipulation since you aren't working with variable length strings. Try doing it in 2 steps, one to right-align the numeric, then the second to do the string insertions

1. In.Col[1,1]:FMT(In.Col,"11'0'R")
2. do you explicit positional changes.

Just to confirm - by saying the "same job" you mean one that was exported and reimported by yourself so that there is no chance of a mistake? Are DEV and PROD the same version with the same configuration files?

Try using an actual delimiter, i.e.

This might be an argument for a BASIC transform stage and the ICONV()/OCONV() functions.

I you know this limitation and understand it, just deprecate the warning message (or suppress it completely) using the message handler facility in DataStage.

Try "gullible". If that doesn't work, ask your local DataStage administrator for it, or ask the system administrator for it

It might be easier, though, to just do what I suggested in the first post. It is simpler, quicker and doesn't require dsadm access.

Please post your first couple of lines, BEGIN HEADER is not DS/BASIC code. Also, read up on the OCONV() function with date conversion, look at the examples, try them and then ask any remaining questions. Few people are willing to write a lengthy answer to an open-ended question when you know the ans...

...I am using DSGetLinkInfo(DSJ.ME,"Transformer1","DSLink2", DSJ.LINKROWCOUNT) to find the record count. I use this function in transformer 2. You will not get the correct row count this way. You need to call the DSGetLinkInfo() function from the after-job subroutine or from outside of the job itse...

I'm confused by your answer - do you not wish to use the FTP stage in your job or can you not find it in your palette? The common methods of NFS Mount, SCP, RCP and FTP are all available to you from DataStage using shells. You need to decide which method you should use and then implement that in Dat...

Great - you (and we) are now certain that the error is in the transform stage. Make a copy of the job and start removing derivations until the error goes away - that way you can find out which exact column derivation is causing the problem.

Does the file exist and if so, what are the permissions? Does your userid have write permission to that directory?

This looks like the classic use of the FIELD() function. I'm not sure exactly what you are trying to do ("between the commas" is vague).

But would return the string 'fee'.

Is that what you are looking for?

If you do the REINDEX and log into the Director/Designer/Manager to find that you can see no jobs - don't despair, it means that there were users logged in during the REINDEX and you just need to do it again.

These are program FUNCTIONs, and thus need to return a single value. The correct syntax in these is "RETURN({value})". I'm not going to look at your code in detail, but probably you want a "RETURN(Ans)"

Please check the UNIX access rights to the DataSet descriptor file and to the partfiles referenced by the descriptor - do you have delete rights? When you used the "orchadmin -rm {dataset}" command what messages did you get?