DSXchange

If I use InsertThenUpdate the job fails with oc_CE_NULL_REASON_CODE_load,1: [IIS-CONN-ORA-001002] The OCI function OCIDateTimeConstruct returned status -2: OCI_INVALID_HANDLE. (CC_OraRecordDataSetConsumer::writeBindBuffers, file CC_OraRecordDataSetConsumer.cpp, line 1,251)

Thanks
Raghu

Hi- I have a couple of insert records ( along with some update records too in a dataset) which make through to the table using Oracle enterprize stage. They also get inserted via the sql in toad. But when using oracle connector stage these records get rejected with ErrorCode=0 and ErrorDescription=c...

Hi Gurus- One of my Job is a multi instance job which runs fine most of the time.Some times in any one of the instance the job finishes with status=99. What are the other possible reasons for 99 status.I know one of them is compiled. if 99 is NOT RUNNABLE state ,then why the datastage log shows as f...

Thanks for your inputs Vivek

Hi - HI- I am willing to learn datastage adminstration and need a suggestion from you DSX gurus. Can I get enough material on DSX tutorial ( If I become a premium user ) to enable me to learn datastage adminstration. Just FYI- I have nearly 4.5 years of Development experience and also know UNIX to a...

I am using a 8 node configuration file which are spread across 2 servers.
How to identify the processes that are running on both the servers for my job.

Thanks
Raghu

I am unable to see your full reply as it is a premium content.

Hi Ray- I missed the point the the Job was in the compiled status.It was not yet run.After running the job, I am getting the required output from the routine. But I am also getting the following error message "> Job control error (-16) > (DSGetParamInfo) Cannot get the value of an encrypted par...

Thanks for the responce. Yes by replacing DSJ.PARAMVALUE with DSJ.PARAMTYPE I am gettiing the output as below Result = $APT_CONFIG_FILE=4 pSource_System_EDW=2 pTargetTable=0 pErrorsDir=4 pRefDataDir=4 pPROC_DT=0 pPROC_DT_MINUS1=0 pHighTimestamp=0 pUseExternalParameters=5 pErrorData=5 pSchema_EDW_SOR...

Thanks for the responce. Yes by replacing DSJ.PARAMVALUE with DSJ.PARAMTYPE I am gettiing the output as below Result = $APT_CONFIG_FILE=4 pSource_System_EDW=2 pTargetTable=0 pErrorsDir=4 pRefDataDir=4 pPROC_DT=0 pPROC_DT_MINUS1=0 pHighTimestamp=0 pUseExternalParameters=5 pErrorData=5 pSchema_EDW_SOR...

Hi My requirement is to get a list of parameters used by a job as below Parm1=Val1 Parm2=Val2 . . ..... The code I am using is as below #include DSINCLUDE JOBCONTROL.H equate me to TestRaghu ! Assign Ans='' ParmList='' JOB=Trim(JobName) !JobHandling JobHandle=DSAttachJob(JOB,DSJ.ERRWARN) !Get Parame...

By default dsjob -loginfo gets you the complete log of the job, not just the current run log. In your case if you are getting only the current run log, then you might have ristricted the number of log entries in the adminstrator.Check if it is set to 1 which might be the case for the dsjob command r...

Hi-

Can any one suggest me a document which can give me indeapth understanding of config files,How to create them ,What are section leaders,What are players,How they are associated with each other and so on.

Your Inputs are appreciated.


Thanks

Thanks Ray

Thanks for the responce. I just have one more question for you Gurus. I have a routine where the part of the code is as below JobHandle = DSAttachJob(JobId,DSJ.ERRWARN) ; If JobHandle < DSJ.ME Then Call DSLogWarn('Unable to attach the Job ':JobId:'. Job reconciliation will NOT occur',Me) What is the...