Search found 42189 matches

by chulett
Tue Jun 23, 2009 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting record - two behaviours
Replies: 16
Views: 6254

Use a Sequential File stage to capture rejects, not a Hashed File, you could be losing records due to the 'destructive overwrite' nature of hashed files depending on the keys you've defined.
by chulett
Tue Jun 23, 2009 6:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting record - two behaviours
Replies: 16
Views: 6254

You already know the "full syntax", you've used it correctly just on the wrong "file". Your log file's name was explicitly mentioned in the error message, however to look it up simply query DS_JOBS:

Code: Select all

SELECT JOBNO FROM DS_JOBS WHERE NAME = '<YourJobName>'
by chulett
Tue Jun 23, 2009 6:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: More jobs through Sequencer
Replies: 6
Views: 1649

Never heard it called that, are you perhaps thinking of the Nested Condition stage? :?
by chulett
Tue Jun 23, 2009 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: logic for grouping
Replies: 5
Views: 1290

In other words, you need to ensure each partition includes all values for the grouping keys in that partition.
by chulett
Mon Jun 22, 2009 6:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC is not installed on the system
Replies: 23
Views: 7230

shareeman wrote:I've resolved this issue.

My issue pertained to a specific library file that was missing.
Could you please share the library file's name and what you needed to do to bring it back from the missing? It would help future searchers who come here with the same issue.

Thanks!
by chulett
Mon Jun 22, 2009 6:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to delete folder from director
Replies: 16
Views: 4170

Right... but it was news to me that you can rename categories there now, that was not possible in earlier versions.
by chulett
Mon Jun 22, 2009 6:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Invocation ID to multi-instance job
Replies: 3
Views: 2973

Sure! Simply append it after the job name using a period (aka 'dot') as the separator:

JobName.InvocationId
by chulett
Mon Jun 22, 2009 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to delete folder from director
Replies: 16
Views: 4170

All of the information that would have been strictly in the 'Universe' repository is now in the 'open' XMETA database repository as well (including folders AFAIK) and so most of the UV solutions we have from the 7.x world no longer work or may not be the complete solution. Especially if the two get ...
by chulett
Mon Jun 22, 2009 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to delete folder from director
Replies: 16
Views: 4170

It won't help, as the issue sounds like it's in the XMETA (relation database) repository, hence the need for a patch. Sounds like you should contact your official support provider.
by chulett
Mon Jun 22, 2009 2:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC is not installed on the system
Replies: 23
Views: 7230

Interesting... I should have added that my reply was strictly referencing pre-8 installations and could very well have changed in the new release. I'll need to test that when I get some time on our 8.1 server.
by chulett
Mon Jun 22, 2009 1:45 pm
Forum: General
Topic: Shell script to start a job using dsjob
Replies: 13
Views: 37036

QuestExpert: :!: Please don't quote the entire contents of every message you reply to. There is a perfectly lovely Reply to topic button at the bottom of the post that will start you off with a clean slate. It's fine to do so to make a point or to ensure people know exactly who / what you are replyi...
by chulett
Mon Jun 22, 2009 1:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need Help_ My jobs aborted in the middle of loading
Replies: 9
Views: 1966

I actually meant to delete them from the target not the source and then rerun everything... but either way could work.
by chulett
Mon Jun 22, 2009 1:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read lookup file into memory using basic routine
Replies: 15
Views: 4431

How you access something isn't changed by the fact that it is in COMMON. So if what you've got in there is a dynamic array, you can certainly iterate thru the elements there just like you would any time / place else. Etc.
by chulett
Mon Jun 22, 2009 1:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ODBC is not installed on the system
Replies: 23
Views: 7230

I've never had to change or add anthing to that 'header' area. :?
by chulett
Mon Jun 22, 2009 1:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Field function
Replies: 6
Views: 1776

Sure, you could replace it with pretty much anything as long as you can guarantee that it isn't used anywhere in the data. Hence Kim's choice. That or just use my fancy pantsy formula. :wink: