Search found 42189 matches

by chulett
Sun Jun 03, 2012 7:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD Type 2 producing incorrect inserts
Replies: 7
Views: 3972

Off the top of my head, I'd try setting the dimension link partitioning to match the input link: Hash on BAS_NK & SOURCE_SYSTEM_ID.
by chulett
Sun Jun 03, 2012 11:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading XML file in windows through external source
Replies: 23
Views: 7738

From the link it doesn't sound like a bug but rather behaviour specific to the presence of a colon in your 'prog name'. Have you tried what it suggested to resolve the issue?
by chulett
Sun Jun 03, 2012 7:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: .rhost file location
Replies: 17
Views: 7395

Did it create any kind of log file that states why it failed?
by chulett
Sat Jun 02, 2012 9:32 am
Forum: General
Topic: Run Multiple Instance Parallelly
Replies: 6
Views: 2090

You left off the most important part of that sentence, the one that said why that happened. Read up on the -jobstatus option.
by chulett
Sat Jun 02, 2012 8:30 am
Forum: General
Topic: Run Multiple Instance Parallelly
Replies: 6
Views: 2090

There's no reason to force them to the background, that happens automatically if you don't use one of the wait options. Then check dsjob -jobinfo in a loop until all jobs have completed and see what happened to each one. It's easier from the BASIC API as you establish a handle to each job you want t...
by chulett
Fri Jun 01, 2012 10:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: .rhost file location
Replies: 17
Views: 7395

Home directory.
by chulett
Fri Jun 01, 2012 10:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: .rhost file location
Replies: 17
Views: 7395

Re: .rhost file location

I'm not sure how far you are going to get past this:
karthi_gana wrote:I have installed datastage 7.5x2 on windows 7 ultimate OS.
That version is ancient and specifically architected to run on XP.
by chulett
Fri Jun 01, 2012 8:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Facing Error while reading Excel file through ODBC connector
Replies: 4
Views: 4175

atul9806 wrote:I am not able to see what you written here. It is saying its a premium content.
Been that way for a long time here.

memberbenefits/

They don't come any more premium than Ray. :wink:
by chulett
Fri Jun 01, 2012 5:40 pm
Forum: General
Topic: DataStage Basic Routine behaves different in 8.7...
Replies: 4
Views: 4982

And the more specifics you provide, the better. Saying that the "file size and even number of files it produces is different" doesn't really help us help you. Examples, both before and after, generally don't hurt as well.
by chulett
Fri Jun 01, 2012 4:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CFF stage
Replies: 2
Views: 1717

You might want to explain what "delimited separated" means as those two words are basically synonymous in the context of a sequential file. Can you be more specific? Also - if the file isn't "complex", i.e. isn't EBCDIC or have OCCURS or REDEFINES or packed decimal fields (etc), ...
by chulett
Fri Jun 01, 2012 3:12 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job control process (pid 5976) has failed.
Replies: 3
Views: 3944

a> Just Reset the job. If for some reason it won't reset, use the Clear status file option. Both are done from the Director.
b> Possibly. Check with your DBA. Note you may need to manually roll back any partial loads, depending on your job design.
c> No.
by chulett
Fri Jun 01, 2012 1:56 pm
Forum: General
Topic: DataStage Basic Routine behaves different in 8.7...
Replies: 4
Views: 4982

Looks much more better with 'code' tags rather than 'quote' tags, yes?
by chulett
Fri Jun 01, 2012 1:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter values become hardcoded
Replies: 5
Views: 2397

Never heard of that behaviour before, did you report it to your official support provider?
by chulett
Fri Jun 01, 2012 1:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Seeking a best solution in DataStage
Replies: 28
Views: 22304

DWS wrote:If anyone in future wants to know the exactlly steps, I could post those in the forum.
It's always appreciated when people post their solutions.