Search found 15603 matches

by ArndW
Wed Mar 19, 2008 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COBOL copy book error
Replies: 5
Views: 846

The format is still illegal in COBOL, unless the trailing "CC426687" starts in column 73 and you trimmed extra space!
by ArndW
Wed Mar 19, 2008 6:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Scheduler error
Replies: 1
Views: 1669

Re: Datastage Scheduler error

Riku wrote:...The permission on project server and on at.exe and vmdsr_sched.exe is given.
But for which user? Check your Administrotor client "Schedule" tab for the project to see which user is being used for the "at" command.
by ArndW
Wed Mar 19, 2008 6:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Format-Handling
Replies: 4
Views: 1384

I don't think that you can do this without a transform or other active stage. Have you tried to see what happens when you have a decimal 4,2 declaration but you have 3 digits after the decimal in the file?
by ArndW
Wed Mar 19, 2008 5:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance
Replies: 7
Views: 1223

If you could explain what you would like, perhaps someone could assist. The question is so broad and vague that no answer is possible on such a complex subject.
by ArndW
Wed Mar 19, 2008 4:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is theDifference Between Data Stage 7.5 & DataStage
Replies: 9
Views: 3995

The question is similar to asking "What is the difference between Windows 3.0 and Windows NT?" and expecting a good answer.
by ArndW
Wed Mar 19, 2008 4:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job running in a infinite loop
Replies: 4
Views: 1150

Perhaps it is no longer actually running, but the status still might indicate that. Can you re-compile the job?
by ArndW
Wed Mar 19, 2008 3:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: main_program: The section leader on apsp8507 died
Replies: 2
Views: 3253

That message doesn't help at all. Can you try to reset the job and see if you have a log entry titled "from previous run..." and post the errors listed there?
by ArndW
Wed Mar 19, 2008 3:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COBOL copy book error
Replies: 5
Views: 846

That syntax is invalid. You might have reformatted it, so could you post the original inside "code" tags?
by ArndW
Wed Mar 19, 2008 2:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Migration from version 7.5.2 To 8.0
Replies: 2
Views: 739

The jobs should all be upwardly compatible and, in theory, you should be able to recompile and immediately run them all. As noted in another thread, there don't seem to be as many migration sites as there are new customers at Version 8 so the breadth of experience is a bit narrow at the moment.
by ArndW
Wed Mar 19, 2008 2:14 am
Forum: General
Topic: Migration to Version 8
Replies: 13
Views: 4017

The same in my case, all of my V8 sites have been "greenfield" installations. I would guess that is most likely still the most common scenario as existing implementations at V7 will try to wait a bit longer before migrating up to V8.
by ArndW
Wed Mar 19, 2008 2:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Nested If Then Else statement strange behaviour in routines.
Replies: 13
Views: 7462

Mohammed - please, try putting "PRINT" statements in your job to debug it, right before the offending "IF" statements so that you can see what values are being used.
by ArndW
Wed Mar 19, 2008 2:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: "main_program: Internal Error: (0): odbcUtils.C: 798 &q
Replies: 2
Views: 995

I didn't now what the cause was, but I used the search facility and located this thread, perhaps that might help a bit further.
by ArndW
Wed Mar 19, 2008 2:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UCS-2
Replies: 20
Views: 5263

2ksaint - you have to specify in your job that the file you are reading is using UNICODE, not UTF-8. Specify this in the NLS tab on the sequential file stage.
by ArndW
Wed Mar 19, 2008 2:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with converting EBCDIC to ASCII
Replies: 10
Views: 9897

No, you don't need to enable NLS. Could you explain your problem with the CHAR() function - I don't see it having a problem with the full ASCII set.
by ArndW
Wed Mar 19, 2008 1:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null handling in Sequential Files for decimal fields
Replies: 4
Views: 1566

How can we answer if you don't post the warning you get?