DSXchange

I just checked - the c++ function doesn't use any API calls, and the other object is a buildop which uses a whole different set of calls.

Here with 8.0.1 and AIX the list is:

2809, 9043, 9080, 9100, 9403, 13400, 13401,31531, 31533, 31538

A 5 Byte COMP-3 would be a S9(9). For the example you gave, 09 06 01 13 "G" what number do you expect to get?

I am wondering about the trailing sign, the "G" in ASCII is binary 01000111 and "0111" isn't used as a sign nibble.

Once I get back to work I can get the list of include files and functions that you need

And I just implemented a c++ function in V8 today and it worked just as it has in the past.

Your error message refers to a conversion so I would go through the stored procedure and the definitions looking for an explicit or implicit conversion.

priyadarshikunal - I don't understand what you mean. VarChar fields in sequential file are always read as VarChar...

venky - what exactly is your error or problem?

Where does the "datetime" data type get used? I suspect you declared that somewhere.

What kind of jobs are you talking about - sequences might give different types of errors than server or PX jobs.

Fix the format or do an explicit conversion into the correct format. Why not define the DataStage type as VarChar(100) temporarily and see if you are getting correct values, once that works you can do an explicit conversion from string to datetime. What is your datetime string format?

Are you doing wave processing (intentionally)? What stage is setting up end-of-waves? Are you sure that you've seen all the erorr messages? If, for instance, a disk fills up you will also get the "Unable to allocate communication resources." message, but that is not the cause of the proble...

What happened to this thread?

Your routine is returning a VarChar(100) string and DataStage is trying to write that to a date time column and giving the error that it cannot convert it. This is probably due to an invalid date format.

From the TCL, issue the command "MAP" after the error occurs and see if you can find DS.GETPID and DS.SETCOL (they will be found towards the end of the list). If the aren't there, restart DataStage and then issue the command again - if they still aren't there then you have a problem which ...

I've done a couple of implementations that people called "real-time", but I much prefer to use "near real-time" or just to specify that the application needs to be synchronous. At present I am on an implementation using MQSeries for data transfer and there are host systems involv...