Search found 42189 matches

by chulett
Wed May 10, 2006 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: stored procedure in before subroutine
Replies: 13
Views: 3647

What happens why you try running the 'Wincommand' manually? Does it work then?
by chulett
Wed May 10, 2006 6:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routine processing file
Replies: 4
Views: 1247

Arnd, PLEASE use indentation in your code to make it readable. :wink:
by chulett
Wed May 10, 2006 6:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with plugin metadata definition
Replies: 4
Views: 1297

First step would be to tell us which plug-in you are using. Second step would be to let us know if you've ever used that plug-in successfully before, like in a job. Silly things like that. Details, man! :wink:
by chulett
Wed May 10, 2006 6:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036: illegal variable name/number
Replies: 6
Views: 2150

Of course you can! That's not the problem. You've used three parameter markers in your SQL and dollars-to-doughnuts you don't have:

1) Three columns defined in the stage
2) First column marked as a Key

The first one is the real culprit, I'd wager.
by chulett
Wed May 10, 2006 6:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restarting a job with the same parameters
Replies: 15
Views: 4792

I've had no reason to handle the encrypted params - the only ones I use are always $PROJDEF - no exceptions - ever. We know you didn't need it, but others would. Tons of peoples, like my current client, started on a version that didn't support $PROJDEF so didn't have the luxury of your 'no exceptio...
by chulett
Wed May 10, 2006 6:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Doubt regarding surrogate key.
Replies: 4
Views: 1460

If you want it to start from 1 each time, there's absolutely no reason to use that function. Why not simply use @INROWNUM for the surrogate?
by chulett
Wed May 10, 2006 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: stored procedure in before subroutine
Replies: 13
Views: 3647

No. How exactly did you 'perform a stored procedure in before subroutine'?
by chulett
Tue May 09, 2006 4:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restarting a job with the same parameters
Replies: 15
Views: 4792

I suddenly find myself coveting a utility like this. Any clue what it would take to handle encrypted parameters? :wink:
by chulett
Tue May 09, 2006 2:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Call .exe file thru DataStage
Replies: 10
Views: 5557

Fully path the bat file.
by chulett
Tue May 09, 2006 11:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SEQUENTIAL FILE STAGE - GETTING STUCK :-(
Replies: 10
Views: 2429

The patch is pretty well version agnostic. I think all versions up to 7.5.1A need the patch, no clue on 7.5.2 but it couldn't hurt to err on the side of caution.
by chulett
Tue May 09, 2006 8:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compare text files
Replies: 3
Views: 703

Have you tried the UNIX command 'diff'?
by chulett
Tue May 09, 2006 8:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SOA Enabled Jobs
Replies: 2
Views: 908

Welcome! First step is that you would have to actually purchase the 'SOA Edition' of the product. This is what allows you to take a 'normal' Server or PX job and 'SOA Enable' it. Not sur how much useful information there is there, but here is a link to the official site for the product. Nothing abou...
by chulett
Tue May 09, 2006 7:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Audit Warning
Replies: 4
Views: 860

Ok... and have you looked in the log of the 'Dim' job to see why it finished with warnings?
by chulett
Tue May 09, 2006 6:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Audit Warning
Replies: 4
Views: 860

You are getting this where exactly? Sequence job? Batch job?