DSXchange

I am encountering a strange issue here. When i run the job in parallel mode (using configuration 2x2) the job is failing with the following error message: main_program: Error when checking operator: Key field "ID" was not found in the input schema. main_program: Internal Error: (status == ...

No. You could look at the job sequence log in Director (or using API functions or dsjob command) - from memory a regular run request has "job run requested" while a reset has something different. ... Thanks Ray. What i am trying to accomplish here is, if the Sequence is executed from a pr...

Hi All,
Is there any DataStage Macro/variable that can be used inside the Sequence, to determine if that particular run is normal run or a restart.


Thanks in Advance.

You cannot stop creation of an empty dataset and there is no builtin function for use in jobs that would give you that information. You can use the UNIX command "orchadmin" to list the number of recor ... Thanks ArndW. We have 2 scenraios here: 1. Dataset is not getting created at all in ...

Is there way to differentiate 'DataSet with no records' vs 'DataSet with some records'. Is there a function or command or routine avialable. Is it possible to control the dataset creation - if i don't have any data going to dataset, is there a way to stop the empty dataset creation. If not, can i us...

even though i see a space in the dataset, datastage does not recognise this a EmptyString. A little lost. A space? If there's a space then you don't have an empty anything ... Chulett, Sorry for the confusion. I don't see a space , i see it as empty string without any spaces. Even if i do the Len(L...

We are reading data from XML file using XML Stage and loading into dataset. In the XML stage specified the option 'Replace NULL's with EmptyValues & Replace EmptyValues with NULL's' For ' MissingAttributes ' in the XML file, we are getting NULL's in the dataset. For EmptyString's (Code ='') we a...

chulett wrote:Do you have the 'Automatically handle activities that fail' option enabled in the Sequence job? ...

Yes.

Cool. Make sure you include one of the "wait" options with dsjob so that you know if it runs ok or not. ... Hi Chulett, Now i am running into a different problem. jsTestSeq.JobControl (@Execute_DataStageLog): Command dsjob -run did not finish OK, reply = '2' Since my actual job is finishi...

chulett wrote:Get rid of the spaces around the equal sign in the parameter name/value pairs. ...

Thanks Chulett.

It worked after removing the spaces around the equal sign in the parameter name/value pairs.

Hmmm... ok. How "dynamic" are we talking about? If the number of different jobs are a small number, consider just branching to multiple Job Activity stages using triggers or the Nested Conditon stage. ... Hi Chulett, The no of jobs are very high, that's the reason i am trying this method.

ArndW wrote:What happens if you enter the command as "dsjob" and parameters as "-run -mode NORMAL -param paramRecLmt = 10 DEV TestdsjobExecute
" ...

Hi ArndW,

I am getting the same error, even after trying the way you mentioned above.

chulett wrote:Why in the heck would you not use a Job Activity stage for this? :? ...

For testing purpose, i had hardcoded the jobname here,
but my actaul intention was to run 2 different similar jobs (for 2 different process) generating jobname dynamically based on some parm values.

I am trying to execute a job using Execute Command Activity inside the Sequence. When i don't specify any parameters, the job executes fine. When i specify the parameters, Sequence aborts does not execute the job. It looks like some syntax error, but not sure where the error is: ********************...

Hi All,

Iam having problems bringing in a DateTime field coming from Oracle which as some NULL values and trying to load into Teradata DATE field (which allows NULL's).

what is the best way to load a NULL value into a DATE field?

Thanks in Advance.