DSXchange

Isn't this the same topic as this thread to which you didn't respond?

The "somehow" part makes me nervous... but it seems that you still have a line break, so a derivation of "In.String<2>" should do the trick.

That machine name looks very familiar!

What stages are you using in that job?

Ray, I think if you have an executable and make it length 0 by mistake (i.e. bad copy) then you can execute it and get no error.

I would do this in 2 steps.



This would cater for changes in the line position in the future.

The leading zeroes won't exist in an integer column, only when you display or move the column to a character one. If you create a CHAR(10) column and a derivation of "RIGHT('0000000000':In.IntegerColumn,10)" you should get your required output.

Is the file format fixed width and are you sure it doesn't terminate lines with a UNIX newline? What column number is "DATBI"

The fact that the problem is urgent for you means that you should contact your support provider. DSXchange is a volunteer group and answers when and if the members find the time and energy to do so. You posted this as a server job on Windows, so you do have the option of declaring your Excel sheet a...

There are two options. You can use DS message handling to demote this warning to informational or even suppress it, or you can use a DecimalToString() conversion (I will assume that you are asking about a transform stage conversion as opposed to a modify stage one).

Server jobs are 0
Mainframe jobs are 1
Job Sequences are 2
Parallel Jobs are 3

There are references to these in various DSINCLUDE files.

Could your "dsjob" executable have been corrupted? Can you still run jobs?

What is your oracle default display date? More common than MMDDYYYY is YYYYMMDD and that might explain the error.

rsripathy, you will notice that using "my problem is urgent" is a good way to end up waiting a lot longer for any sort of a response. This is a volunteer staffed site and all of us have day jobs that pay the bills. If you need immediate support then go to the support provider you are paying maintena...

Unless you have a column separator character you won't be able to do this without a lot of work. You would then need to know the starting position of each column and match that to the position of the tilde; then insert the appropriate number of dummy characters to shift everything to the right of th...

Hello samp,

samp wrote:...(My company has not the job sequence activated)

It is not possible to disable use of job sequences in DataStage and this looks like a perfect use for this type of job.