Search found 8 matches

by louwdata
Wed Oct 21, 2009 5:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Could not find input field "sqlcode" ERROR
Replies: 4
Views: 4225

Could not find input field "sqlcode" ERROR

I've added a reject link to a SEQ file from a ODBC stage in enterprise. When I look at the columns in the output link I find a extra columns added (columns name: sqlcode) When I run the job I get the following error "Transformer_53: Error when checking operator: Could not find input field "...
by louwdata
Tue Oct 20, 2009 11:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a error bucket
Replies: 10
Views: 3456

Thanks. The job compile fine but when I run the job I get the following error

"Sequential_File_42: Error when checking operator: Could not find input field "sqlcode"."
by louwdata
Tue Oct 20, 2009 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a error bucket
Replies: 10
Views: 3456

I don't see that option in the list. I only see the following:

1. Close command
2. open command
3. convert to native form
4. drop unmatched columns
5. insert array size
6. lenght to truncate
7. isolation level
by louwdata
Tue Oct 20, 2009 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a error bucket
Replies: 10
Views: 3456

I don't see that option in the list. I only see the following:

1. Close command
2. open command
3. convert to native form
4. drop unmatched columns
5. insert array size
6. lenght to truncate
7. isolation level
by louwdata
Tue Oct 20, 2009 7:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a error bucket
Replies: 10
Views: 3456

I've pulled the reject link to the output of my ODBC stage but get the following error when compiling

"Error: Reject Link 'ODBC_Enterprise_33.DSLink41' is not allowed with the current setting (or lack) of the 'Write Method' property"
by louwdata
Tue Oct 20, 2009 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Sort stage
Replies: 7
Views: 2588

What is you ulimit settting in the uvconfig file
by louwdata
Tue Oct 20, 2009 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a error bucket
Replies: 10
Views: 3456

I've tried to move the link to the output on the ODBC stage but can not find the reject mode option on the link. If I add the reject link to a file then the option is available but not on a ODBC
by louwdata
Tue Oct 20, 2009 6:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a error bucket
Replies: 10
Views: 3456

Create a error bucket

Hi I want to create a error bucket for records that get rejected on the database due to primary key contraint, null values ext. I know I can add a reject link in the transformer but then I need to add contraint. I need DS to automaticly move the records that get rejected on the Database to a file or...