Search found 32 matches
- Wed Jan 31, 2018 1:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup Failure Default Value
- Replies: 9
- Views: 4568
Jackson, When I used to teach Datastage for IBM, I used to teach that modify stage is much less expensive than the transformer stage, hence when performance is critical, it is better to use modify stage. Then, during one of the debugging sessions with IBM tech support for a client, the support guy s...
- Wed Jan 24, 2018 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup Failure Default Value
- Replies: 9
- Views: 4568
I am not sure that you can change the default value. One option is that you could make the column coming from the reference link as nullable. In a subsequent transformer stage you can build some logic to replace the nulls with the default value of your choice. Alternatively, you can send the lookup ...
- Fri May 30, 2008 11:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS Director - Job "Monitor" not showing the number
- Replies: 6
- Views: 3705
- Thu May 29, 2008 6:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS Director - Job "Monitor" not showing the number
- Replies: 6
- Views: 3705
- Thu May 29, 2008 2:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DS Director - Job "Monitor" not showing the number
- Replies: 6
- Views: 3705
DS Director - Job "Monitor" not showing the number
In the director when I right click on the job and select the "Monitor" , it is not showing the number of rows processed in the link and the status of the link is showing "ready". Though the job is perfectly fetching from the source and loading it successfully. In the designer als...
- Wed May 07, 2008 5:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to import ODBC table definitions
- Replies: 3
- Views: 2789
- Wed May 07, 2008 5:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Not able to import ODBC table definitions
- Replies: 3
- Views: 2789
Not able to import ODBC table definitions
I am not able to import any ODBC table definition. However my jobs are running fine connecting to ODBC datasources.
Whenever I am trying to import ODBC table definitions I am getting the error
"Empty DSN: list returned from host 60.192.1.64"
Whenever I am trying to import ODBC table definitions I am getting the error
"Empty DSN: list returned from host 60.192.1.64"
- Mon May 05, 2008 5:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Execute_Command.$CommandOutput value
- Replies: 3
- Views: 2775
- Mon May 05, 2008 4:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Execute_Command.$CommandOutput value
- Replies: 3
- Views: 2775
Problem with Execute_Command.$CommandOutput value
I have a sequence which runs a job to create a file showing number of rows of a table. Then I am using an Execute command stage to read the file. Then I am using user activity variable stage to read Execute_Command.$CommandOutput in a USER VARIABLE (ROWCNT) In the User Variable stage I have used the...
- Thu Nov 15, 2007 9:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: could not serialize - transaction aborted error
- Replies: 3
- Views: 3902
could not serialize - transaction aborted error
I am using a DRS stage to update a table(Before SQL in the source DRS stage) in Netezza connection through ODBC. In the before SQL tab(Source DRS stage) I have an update statement which updates all the rows of a table (number of rows around 10000). Sometimes I get the error "could not serialize...
- Wed Nov 14, 2007 9:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in ODBC enterprise stage while updating Decimal fields
- Replies: 1
- Views: 1524
Error in ODBC enterprise stage while updating Decimal fields
I have a job which reads from Teradata and update a Netezza table using ODBC enterprise stage. Mapping is one to one. For the decimal fields the update is not happening correctly. For example if the value in the source is 80.45 it is getting updated to Netezza as 80.00. Losing the data to the right ...
- Tue Nov 06, 2007 3:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use a routine return value in job trigger in sequence
- Replies: 4
- Views: 2205
- Tue Nov 06, 2007 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use a routine return value in job trigger in sequence
- Replies: 4
- Views: 2205
- Tue Nov 06, 2007 9:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to use a routine return value in job trigger in sequence
- Replies: 4
- Views: 2205
How to use a routine return value in job trigger in sequence
I have a sequence which runs 3 jobs(A,b,c) in sequential order A --> B ---> C. A,B run everyday. C need to be run on every thursday. I have a routine which returns the day of a week. I have used UserVariables Activity Stage and called the routine to store the dayof the week in a variable(VAR1). I ha...
- Thu Oct 04, 2007 12:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting NULL value in a DATE field
- Replies: 1
- Views: 1964
Re: Inserting NULL value in a DATE field
Create this ENV variable and set its value to 1 APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL 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 i...