Search found 42189 matches

by chulett
Wed Sep 14, 2011 9:17 am
Forum: General
Topic: How to batch change job names
Replies: 6
Views: 1736

That's true... forgot about that little nugget.
by chulett
Wed Sep 14, 2011 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can import xls sheets
Replies: 1
Views: 1251

It's been discussed here quite a bit as an exact search for "xls" will reveal. One such example is here, there are plenty of others.
by chulett
Wed Sep 14, 2011 9:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Processing Cobol file in datastage
Replies: 2
Views: 1340

You are trying to view the data where/how exactly? Also, you should be using the Complex Flat File stage for this, are you?
by chulett
Wed Sep 14, 2011 7:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Limitation on space usage in a DataStage project
Replies: 6
Views: 2983

Space? No, not that I'm aware of. Some operating systems (like AIX) have a limit on the number of directories, however.
by chulett
Wed Sep 14, 2011 7:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml performance
Replies: 13
Views: 3232

Convert them to Server jobs. :wink:

(in the immortal words of BOC - don't fear the Server)
by chulett
Wed Sep 14, 2011 7:14 am
Forum: General
Topic: How to batch change job names
Replies: 6
Views: 1736

Or you could simply use the GUI. But yes, a dsx export can be carefully edited and reimported... but then both names will exist and you'll need to delete all of the old jobs.
by chulett
Wed Sep 14, 2011 7:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file performance issue
Replies: 11
Views: 6799

As noted, AIX is an IBM product so I can't see how it's "out of their scope". You just may need a different support organization there. Also, a System Administrator should be able to configure the filesystem to be optimal for random access of small sizes (as Ray notes) regardless of which ...
by chulett
Tue Sep 13, 2011 7:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file performance issue
Replies: 11
Views: 6799

I would think your official support provider could help answer that question, or perhaps even provide pointers on setting up ZFS appropriately.
by chulett
Tue Sep 13, 2011 2:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job abort during AGG OR SORT
Replies: 24
Views: 6267

You should just be more patient, especially if only Ray is allowed to answer. :roll:

I've used the DS.TOOLS entry in the past for that but have no clue what the actual "tool" itself would be if it is no longer there.
by chulett
Tue Sep 13, 2011 1:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Append 4 files in UNIX
Replies: 4
Views: 1829

cat A B C D > E

Do the files have header records?
by chulett
Tue Sep 13, 2011 8:25 am
Forum: General
Topic: NLS Error in DSExecute routine
Replies: 3
Views: 2182

Hard to say. First guess when Oracle things are fine from the command line but not from DataStage would be the environments each is leveraging. Perhaps your command line sessions are using different values for $ORA_HOME and your "shared library path" then they do in job? That's the first p...
by chulett
Tue Sep 13, 2011 6:29 am
Forum: General
Topic: NLS Error in DSExecute routine
Replies: 3
Views: 2182

ORA-12705 errors generally mean an invalid value in the NLS_LANG environment variable. Not sure why that would only happen in one project, but you first need to see if that is the case.
by chulett
Tue Sep 13, 2011 6:26 am
Forum: General
Topic: datastage
Replies: 4
Views: 1469

Go back to the top, edit your first post and change the subject to be something more meaningful. Then do an exact search for "The system cannot locate the resource specified".
by chulett
Mon Sep 12, 2011 9:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need some info ON .done file
Replies: 3
Views: 2149

Sounds like a pretty standard semaphore technique but you're the only one with access to 'the code' and thus the ability to track it down. They're typically used to signal that a file (or set of files) have transferred completely. Rather than polling for the actual file and risk starting to process ...
by chulett
Mon Sep 12, 2011 9:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage Convert from Old v6.1 to new V8.1
Replies: 29
Views: 10346

Still? Did you change something? :?