DSXchange

Hi, one of our job strucked in between a load 2 days before the situation fron the director is it gave 4 warning messages like ------------------ GetMissingSecurityID: Column REJECT_VAL_TRANS_STG_ID floating point decimal not fully supported. Adjusting scale. . . . -------------------- and then whil...

job aborted when attempting to using Unit of work stage - Unit_Of_Work,0: rollback failed with reason = 2009


Thanks for your help

yes..from diffrent places. in my new job , i have copied a Transformer stage from another existing job (which contain substrings function) and for that transformer, i am able to see all the transformer dervation functions. but the transformer which i created from pallate window doesn't show all the ...

Hi all, in the same project, in some transformer i am able to get all the transformer derivation function(s)..( i am looking for substrings function) i am not able to get all the derivation function for the transformers which i created newly from the pallate window. do i need to change any options s...

Thanks Jay!

it's working now!

Dsedi

yes! we are using column import stage.(all columns imported only as char type) in transformer we are Trim al the input fields and convert the datatype of all columns as varchar or decimal(as required) the warning msg is "Import_trn0,1: Import consumed only 844bytes of the record's 846 bytes (no...

Hi All,

while runing a parallel job, i am getting
fatel error
"Transformer_91,1: Failure during execution of operator logic."
i checked the design twice and found everything correct.

any idea?

Thanks in advance
Dsedi

Hi All, In one of our Jobs, we are using MQ messages as source. we haven't mension any length for messsage column and mention trype as varchar. it's showing compailation error "Precision of Varchar column must be greater then zero" but some other jobs in the same project running without er...

Server running in UNIX and i tried to transfer a 200+MB .dat file..

Thanks
Dsedi

Hi All,

Is it any File size Limitation for sequential file?
one of our Job failed while transfer 200+MB.

Thanks in advance.
Dsedi

Thanks mike!

dsedi

any comments on this Ray?

Thanks
dsedi

Hi all, Do you have more information about DataStage Engine commands? i need to fetch the job name, categroy,update action, and the array size and Rows per trasaction information for a list of jobs. what could be the command that i need to issue in command interface of Ds administrator? Thanks in ad...

Thanks a lot for the responses. Firstly, we are calling the routine in the derivation part of the Transformer. Moreover when we use DSLogFatal, indeed we need to do a manual clean up, then is there anyway we can stop the job and still have it in the reset state. More importantly we need to do this w...

Hi, We have a routine which connects to a Oracle Database and calls an Oracle Function. If the routine fails becuase of reasons like failing to connect to database then the routine fails. When this routine fails, it is required that the job, in which this routine is being called in a Transformer, al...