Search found 42189 matches

by chulett
Thu Jun 03, 2010 12:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before Subroutine - Status Code = 1
Replies: 3
Views: 1334

Just to confirm, you use -wait or -jobstatus - not both. Wait means wait for the job to complete and pass back a standard zero/non-zero return code while jobstatus means wait for the job to complete and pass back an internal 1/2/3 (etc) return code.
by chulett
Thu Jun 03, 2010 10:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Before Subroutine - Status Code = 1
Replies: 3
Views: 1334

Should work fine with the -wait instead of -jobstatus, I do believe. However, I for one would never use the Before area for something like that, really should be part of a Sequence IMHO.
by chulett
Thu Jun 03, 2010 9:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting error while running RunImportStart.sh script
Replies: 6
Views: 5623

Hmmm... looks like someone missed the NEVER in the previous post.
by chulett
Thu Jun 03, 2010 8:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting error while running RunImportStart.sh script
Replies: 6
Views: 5623

Perhaps Ernie might know how to increase the memory space for the process, but that should certainly be one way around your "OutOfMemoryError" issue.
by chulett
Thu Jun 03, 2010 7:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting error while running RunImportStart.sh script
Replies: 6
Views: 5623

Import fewer files at one time.
by chulett
Thu Jun 03, 2010 6:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to generate row numbers for each file-Job Design
Replies: 9
Views: 1989

Double-check where you posted, where we are right now. We are not in the parallel jobs forum. :?
by chulett
Thu Jun 03, 2010 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to generate row numbers for each file-Job Design
Replies: 9
Views: 1989

No, the comment from Ray is directed at your choice of forum to post in.
by chulett
Thu Jun 03, 2010 5:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to generate row numbers for each file-Job Design
Replies: 9
Views: 1989

While you may not be able to do that, you can certainly do that in a Server job. :wink:
by chulett
Thu Jun 03, 2010 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variables
Replies: 12
Views: 3990

Would make a nice addition to the FAQ forum, me thinks.
by chulett
Thu Jun 03, 2010 5:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Open failed for update
Replies: 4
Views: 2051

The problem is not "with the table" but rather with how the data is being sent to the table, something that is causing a deadlock to occur. Talk to your DBA about possible causes and solutions to that error, so you understand what is going on in the database. Typically in DataStage it invo...
by chulett
Thu Jun 03, 2010 5:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert and update DB table fails when input umlaut character
Replies: 16
Views: 6293

You mean, other than what has already been posted?
by chulett
Thu Jun 03, 2010 5:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abort after 50 Warnings with no limit
Replies: 13
Views: 6963

If by "job run level" you mean "dsjob from the command line" then you need to use the -warn option as noted in this thread. Running from the Director you will have a Limits tab where tha ... unfortunately it is not triggered from the command line. but triggered using sequence. i...
by chulett
Thu Jun 03, 2010 5:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Password Encryption.
Replies: 27
Views: 18769

Yes, the encryption is not strong and certainly not meant to be any kind of crack proof - any frequent readers here should remember it has already been "cracked"... more than once. You can compare encrypted values across jobs to ensure the original values are indentical, other than that I'...
by chulett
Wed Jun 02, 2010 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange problem about Warning Limit
Replies: 6
Views: 2807

From what I can tell, yes.
by chulett
Wed Jun 02, 2010 9:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange problem about Warning Limit
Replies: 6
Views: 2807

That is how you should do it, if that's not working you'll need to report it to your official support provider. What exact 8.x version are you running?