DSXchange

And also, are you sure you have give the full path along with the object file in the file path?

Probably Missing out someting
If your target is not nullable, you cannot assign null to the column. If you input is not nullable, you cannot get null from the source.

Is it possible to post the C++ code you have created.
I guess you have selected the Object type as Library. Since you have created a object file select the object as the option.

May I know what is the version of DS you use. If you go to Job properties under parameters tab, you can find 'Add Enviromental variable' button. If you click on it you can find list of all available environmental variables. You can go to the last part, User Defined. And select the variable you have ...

Search in google based on the SQLSTATE gives the following INVOCATION OF FUNCTION OR PROCEDURE name FAILED DUE TO REASON rc Explanation: A routine was invoked. The routine invocation was not accepted because of DB2 reason code rc. And by db2 for SQL0471N is SQL0471N Invocation of routine "<name...

Two transformed next to next will be clubbed as a single process during runtime unless interprocess is introduced. And placeing a intermediate passive stage will increase a unecessary IO.

Can be used and can be diverted to a file for logging.

In sequential file, under Options you can find Schema file. You can give the path and name of the file which holds the metadata model for the stage. A sample structure would be record ( name:string[255]; address:nullable string[255]; value1:int32; value2:int32 date:date) If you have enabled ...

Not sure whats wrong in your case
Is your output and input is integer?
Is it a composite key?
Are you sure that your output is not messed up the partition provided?
For testing run you job in sequentiol mode.

Add $DSCAPIOP__DSN in your job properties.

Perhaps you can try to build your own logic of conversion using either SWITCH stage or by writing parallel routine.

It depends on how you define the column data type.
If you assign the column as Integer you will get as expected.
If you assign as varchar or character, you will get the result from datastage as you instructed the datastage to do.

But rather than posting in Site/Forum you can post in the appropriate forum. Either Parallel or Server. If the job in same environment (Same project) with different users with the same access given, then its not a easy task to avoid the access. The possible way would be to create a new project and m...

Ray, I have face similar issue, when holding very huge transformations. I recall I had raised a post for the same. Though none explicitly issue a SIGKILL, it implicitly gets generated, at least by the controller of the code. May be due to Conductor, not sure.

Might be you are refering to the Compiler which may not be required during run time.