Search found 42189 matches

by chulett
Sat Jan 13, 2007 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage parrallel with intel or amd
Replies: 19
Views: 6214

Bah. :wink:

Does the DataStage installation or configuration care if there's an Intel or AMD chip down there? No, not really.
by chulett
Sat Jan 13, 2007 11:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: routine with readseq and writeseq
Replies: 7
Views: 2001

Sure, just 'cat' rather than 'type'... and use UNIX for the first parameter, not UV.
by chulett
Sat Jan 13, 2007 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: New EtlStats soon
Replies: 34
Views: 13529

Kim dammit - Kim. :wink:
by chulett
Sat Jan 13, 2007 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to call sqlservers stored proc?
Replies: 4
Views: 1811

Re: How to call sqlservers stored proc?

What needs to be done. please please reply soon your best comments to me. And here I was hoping I could wait for awhile and then reply with something completely off-topic and useless. Your 'and take some return parameter as output' requirement means your only choice is to follow some form of Ken's ...
by chulett
Sat Jan 13, 2007 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Table locks when loading through Teradata Enterprise stage
Replies: 19
Views: 12560

I would assume all that means is that the tpump command isn't in your path. There must be installation / configuration instructions for that stage, have you followed all the steps there to configure it properly? If you need to involve your Teradata folks in this as well, don't be afraid to do so.
by chulett
Fri Jan 12, 2007 8:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: calling Job parameters
Replies: 8
Views: 2197

No. The 'surround the parameter name with hashes / pound signs' is the rule, but as with all rules there are exceptions. Transformer derivations are one place where you don't enclose them. If you are unsure, always best to use the 'helper' tool under the ellipses (...) whenever it is available. When...
by chulett
Fri Jan 12, 2007 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding OCI STAGE
Replies: 4
Views: 1366

Experience. Native > ODBC.
by chulett
Fri Jan 12, 2007 12:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Getting Aborted, but data is getting extracted and loade
Replies: 11
Views: 2649

$ oerr ORA 00942
00942, 00000, "table or view does not exist"
// *Cause:
// *Action:
by chulett
Fri Jan 12, 2007 9:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: File Full warning
Replies: 17
Views: 4270

Disk space, as in lack of.
by chulett
Fri Jan 12, 2007 9:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSExecute failing with return code -1
Replies: 6
Views: 2811

Re: DSExecute failing with return code -1

The following message is returned in output parameter (parameter #3) before we abort the job because return code is not 0. <Jobname>..JobControl (<ProgName>): Unable to create new process. Will try again. Create Process failed (5). Why don't you post whatever code is generating this. I don't think ...
by chulett
Fri Jan 12, 2007 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: duplicate record for key column in ODBC stage
Replies: 12
Views: 2624

As noted, I don't see how in the heck that is possible. What other stages are you using in the job? :?
by chulett
Fri Jan 12, 2007 7:51 am
Forum: General
Topic: Waiting for Files to Run a Sequence
Replies: 1
Views: 1377

First by posting in the proper forum (hint, this ain't it) and since Sequence jobs apply to any job type that would be the General forum.

And if your 'multiple files' number is 7, I've already answered this on developerWorks. :P
by chulett
Fri Jan 12, 2007 7:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Accessing Datastage Universe tables via Oracle
Replies: 5
Views: 3232

Ok. Those queries can be run from a couple of places. One would be from the Administrator client - select the appropriate project from the Projects tab, click on 'Command' and then go to town. Otherwise, you can telnet in and execute them from a TCL prompt which is basically the 'Universe' command l...
by chulett
Fri Jan 12, 2007 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL Server]Statement(s) could not be prepared.
Replies: 3
Views: 1251

and in the Outputs tab, we need to give the Database Name.Owner.Table Name. 'Need' to? No, I don't believe so. Can? Yes. Isn't, it provides flexibility to use different database of the same server (server specified in the DSN) Is that a question? If it is, the answer is no - as your experiment has ...