Search found 42189 matches

by chulett
Tue Oct 20, 2009 8:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading txt file with date in its name, in daily cycle
Replies: 18
Views: 3537

Ummm... moving them to another directory? An 'archive' one would be typical. Harder would be to keep a list of filenames processed and skip those filenames when you see them again.
by chulett
Tue Oct 20, 2009 7:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open project 'XYZ' - 81016. ( Job Migrated )
Replies: 13
Views: 6999

I was wondering the same thing, but all that's been mentioned is a single server. Pavan, can you confirm?
by chulett
Tue Oct 20, 2009 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC connectivity problem with Lotus Notes
Replies: 4
Views: 3355

I doubt you'll find much experience with Notes ODBC issues here, unfortunately. Where did this driver come from? Do they offer support for it?
by chulett
Tue Oct 20, 2009 7:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Create a error bucket
Replies: 10
Views: 2551

And the setting for that property would be... ? Not all methods allow reject capture.
by chulett
Tue Oct 20, 2009 7:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Sort stage
Replies: 7
Views: 1747

It's probably not set there at all. Try what Arnd suggested first.
by chulett
Tue Oct 20, 2009 7:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To skip a job for null dataset
Replies: 14
Views: 4492

If you overwrite the previous dataset each time, loading it empty should not be an issue. Is there some reason you cannot simply do that?
by chulett
Tue Oct 20, 2009 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSX Migration from V7.5.1 to IBM Information Server 8.1
Replies: 4
Views: 1402

Re: DSX Migration from V7.5.1 to IBM Information Server 8.1

Is it just a direct export-import. Would all the stages work properly after importing to the new 8.1. The short answer is 'yes', this would be a direct export/import and everything in 7.x should still work in 8.x without issue. This is provided, of course, that all 'optional' stages you are using i...
by chulett
Tue Oct 20, 2009 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading txt file with date in its name, in daily cycle
Replies: 18
Views: 3537

Then you either need to rename the file once processed so it no longer matches your pattern, or you need to move it to another directory.
by chulett
Tue Oct 20, 2009 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading txt file with date in its name, in daily cycle
Replies: 18
Views: 3537

Use the File Pattern option in the stage.
by chulett
Tue Oct 20, 2009 5:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to open project 'XYZ' - 81016. ( Job Migrated )
Replies: 13
Views: 6999

Seeing as how this happens with newly created jobs as well, I don't see how...
by chulett
Tue Oct 20, 2009 5:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To skip a job for null dataset
Replies: 14
Views: 4492

Sounds like you may just need to make sure you have 'overwrite' turned on. :?
by chulett
Tue Oct 20, 2009 5:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Migration from DS7.5.2 to IIS 8.1.1 - Possible NLS issues
Replies: 17
Views: 6212

I can see your 'newness' from your post count and no, I'm not disturbed any more than I normally am. Forum etiquette asks that you please start your own thread for your own questions rather than hi-jacking someone else's and when you do, we would be happy to provide information.
by chulett
Tue Oct 20, 2009 5:40 am
Forum: General
Topic: OT: Really useful freeware Windows utility - PathCopy
Replies: 3
Views: 2001

I assume it would as well, just more wondering if you knew seeing as how it wasn't listed as an 'official' supported operating system on the link you provided. Then there's always the Windows 7 question nowadays as well. :wink:
by chulett
Tue Oct 20, 2009 5:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To skip a job for null dataset
Replies: 14
Views: 4492

Use a sequence job to check either the size of the dataset or how many rows were written to it in the previous job and then only run the second job when that comes back non-zero.
by chulett
Tue Oct 20, 2009 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job substituting default params in place of the passed ones
Replies: 13
Views: 2671

OK. That's better than it being an 8.0.something version with all the possible bugs that brings to the table. However, for the behaviour you're describing I would open a case with your official support provider. Do you think the 'user-defined routine' plays any role in this? When you have this probl...