Search found 188 matches
- Wed Feb 04, 2009 10:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Key field "ID" was not found in the input schema
- Replies: 1
- Views: 5872
Key field "ID" was not found in the input schema
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 == ...
- Thu Dec 04, 2008 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restart variable in Sequence
- Replies: 4
- Views: 3121
- Wed Dec 03, 2008 3:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restart variable in Sequence
- Replies: 4
- Views: 3121
Restart variable in Sequence
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.
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.
- Thu Nov 06, 2008 7:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Empty DataSet vs DataSet with records
- Replies: 2
- Views: 2398
- Thu Oct 16, 2008 7:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Empty DataSet vs DataSet with records
- Replies: 2
- Views: 2398
Empty DataSet vs DataSet with records
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...
- Tue Sep 30, 2008 8:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NULL vs EmptyString
- Replies: 3
- Views: 3245
Re: NULL vs EmptyString
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...
- Mon Sep 29, 2008 8:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NULL vs EmptyString
- Replies: 3
- Views: 3245
NULL vs EmptyString
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...
- Wed Aug 13, 2008 11:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSJE_DSJOB_ERROR
- Replies: 12
- Views: 11313
- Tue Aug 12, 2008 11:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSJE_DSJOB_ERROR
- Replies: 12
- Views: 11313
- Mon Aug 11, 2008 11:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSJE_DSJOB_ERROR
- Replies: 12
- Views: 11313
- Mon Aug 11, 2008 11:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSJE_DSJOB_ERROR
- Replies: 12
- Views: 11313
- Mon Aug 11, 2008 11:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSJE_DSJOB_ERROR
- Replies: 12
- Views: 11313
- Mon Aug 11, 2008 10:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSJE_DSJOB_ERROR
- Replies: 12
- Views: 11313
- Mon Aug 11, 2008 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSJE_DSJOB_ERROR
- Replies: 12
- Views: 11313
DSJE_DSJOB_ERROR
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: ********************...
- Thu Oct 04, 2007 9:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting NULL value in a DATE field
- Replies: 1
- Views: 2033
Inserting NULL value in a DATE field
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.
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.