DSXchange

I have a multiple instance batch job for that i need to create variable InstanceName or Number.so how can i do that. Any suggestions.

as i have said,we are not created any invocation Ids separately for the job.We cant guess how many instances of the jobs should be triggered.so we are not gone into that.When i invoke MYJOB,how i will come to know about FirstInstance(Myjob.FirstJobName).just what i am doing right now is Running Job ...

I have a server job which should execute as multiple instances.So i have enabled the Multiple instances check box from job properties of the same.This mutiple instance job is inturn invoked from some other job using the following routine. * Reset the Job before Run hJob1 = DSAttachJob(JobName, DSJ.E...

Hi ray, Below is the log message can u please tell me what shall I do in the next step. From previous run DataStage Job 4674 Phantom 14945 Job Aborted after Fatal Error logged. Program "DSD.WriteLog": Line 239, Abort. Attempting to Cleanup after ABORT raised in stage J0Bsm..JobControl Data...

Hi all, When I am trying to run the job from top sequencer it starts executing initially but As the execution proceeds Job gets Aborted saying ""Abnormal termination of stage J1PduXfm..T detected". So please suggest any Idea regading this issue to solve. I agree there must be some loa...

HI ,
Try it using iconv and Oconv function..
ex:if the date is 2007032 which represents 2007-02-01
use the below mentioned function in the transformation stage


OCONV(ICONV('2007032','DYD[4,3]'),'D-YMD[4,2,2]')

Thanks for the suggestion
But what I want is Can we call a procedure in Orabulk Stage .WE DONT HAVE TRUNCATE PRIVILAGE.All we want to do is to create a store procedure and call the procedure in the stage

We can even create table in OraBulk Stage By making
'insertion mode=TRUNCATE'

Hi all,

Can we call procedure (for Truncating Table )from OraBulk Stage? If so Please let me know how to implement it.