DSXchange

Obviously an ERROR occurred.

(The message tells you no more than that.)

Have a look at the imported table definition then compare that with what's actually in the file. Don't use DataStage for this latter activity.

Double is the same as dfloat.

I think you need to investigate the Sybase data a bit more thoroughly. DataStage can't "invent" data values. For example, are there any newline characters in these raw data? You could check using a Transformer stage. Incidentally, ^@ is a representation of ASCII NUL, often used as a termin...

How many jobs are there in the project? How long is it since you purged &PH&?

What encoding is used for your source data?

The float and dfloat data types are not guaranteed to store data to the final significant digits accurately. Research the IEEE specifications for storing these data types for the reasons why. I'd suggest you specify at least a scale value (ideally a precision value also), and perhaps treat the data ...

It's impossible to tell from what you've provided. It might be a glitch in your I/O subsystem, maybe a badspot on the disk. Can you reproduce it? What precisely do you mean by "cut"?

My Source have sql server datatype has number,target have sql server datatype has sql server.When i am loading soure to tartget,data will be truncated. Ex:Source has 16.8 target loaded to 16.799992372605. i am not use any convertion function.Please let me know have idea in this. Can you please repo...

Inserts and deletes should not be a problem if you are using row-level locking, since you can't delete a non-existent record and you can't insert an existing record.

If, however, you are using page or table level locking, then you may encounter lock contention.

Another possibility is to use CREATE INTO command to populate a work table from the IXF file, and then move the data from there to wherever you need it to be.

I wrote a routine to unpack IXF file formats very many years ago - doubt that I would be able to find it again but, as I recall, it was not difficult.

Use a server Sequential Fille stage in a server shared container. This stage type can handled line terminators in text fields.

Then how about a unique UNC pathname?

Try changing your logged drive in the command.