Search found 42189 matches

by chulett
Wed Feb 01, 2012 6:51 pm
Forum: General
Topic: Execute Command activity does not run the script
Replies: 17
Views: 6671

Ah, ok... I only had an Annotation on the canvas when I had all of the "code" the job ran in the Job Control tab and possibly something before job. If literally all you have is something 'Before Job' then you could either move it from there to Job Control (easily done) and add the Annotati...
by chulett
Wed Feb 01, 2012 4:25 pm
Forum: General
Topic: Execute Command activity does not run the script
Replies: 17
Views: 6671

It also required me to add some dummy stages to my new script as system would not compile DS jobs with empty bodies. FYI - All you needed was an Annotation on the canvas to fulfill that requirement. Mine would typically note what it does and that all of the code was either in Job Control or Before ...
by chulett
Wed Feb 01, 2012 4:19 pm
Forum: General
Topic: Creating new Dynamic VOC file and replacing the VOC file
Replies: 19
Views: 5792

Sheesh... we know the answer Ray, it was meant to be answered by the OP.
by chulett
Wed Feb 01, 2012 12:22 pm
Forum: General
Topic: Creating new Dynamic VOC file and replacing the VOC file
Replies: 19
Views: 5792

And what is in this "VOC folder"?
by chulett
Wed Feb 01, 2012 10:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue while handling REJECT records
Replies: 13
Views: 3563

I was wondering how it allowed that job design but having the last link as yet another reject link is the only thing that makes sense. PX is not like Server in that it does not allow input and output links from the same target stage. If you want to 'process' that reject file, you'll need to use anot...
by chulett
Wed Feb 01, 2012 10:11 am
Forum: General
Topic: DataStage v8.5
Replies: 1
Views: 1003

Nope. You'll need to use a client that matches the server version to do anything, including any monitoring.
by chulett
Wed Feb 01, 2012 8:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help with Stored Procedure stage error
Replies: 1
Views: 1086

Unless something has changed in 8.x I seem to recall that you'll need at least one input parameter for the proc. Even if the proc doesn't use it, there needs to be something it can bind to the input link.
by chulett
Wed Feb 01, 2012 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error SybaseEE IQ write
Replies: 1
Views: 1749

:!: Please don't bump posts like that, at least ask another question - even something like "Can anyone help me with this?" is better than just "bump" or "UP". That being said, if no-one has posted a reply then perhaps no-one has the experience or expertise to help with ...
by chulett
Wed Feb 01, 2012 7:50 am
Forum: General
Topic: Error while creating job , erro on create.file command
Replies: 12
Views: 3061

Permissions. Have you checked what they are in the Project's directory for that folder?
by chulett
Wed Feb 01, 2012 7:47 am
Forum: General
Topic: Creating new Dynamic VOC file and replacing the VOC file
Replies: 19
Views: 5792

From the linked instructions: Changing the VOC file from a static file to a dynamic file speeds up the updating of the VOC. You don't have an issue, keep on going. In all honesty, if you don't understand why I don't think you should be in there doing something of this nature. ps. Your 'folder' came ...
by chulett
Wed Feb 01, 2012 7:36 am
Forum: General
Topic: Error calling subroutine DSR_EXECJOB action=4
Replies: 11
Views: 3321

Suggest you search the forums here for your error message.
by chulett
Wed Feb 01, 2012 7:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp as 19 *s
Replies: 1
Views: 1080

Posting in all caps on the Internet is considered SHOUTING... please don't shout.
by chulett
Wed Feb 01, 2012 12:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read from a changing table
Replies: 3
Views: 1476

One stage = one connection / session that all of the links would leverage. I've done that in the past for multiple simultaneous sources but never checked to see exactly how 'simultaneous' they really truly were.
by chulett
Tue Jan 31, 2012 11:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Read from a changing table
Replies: 3
Views: 1476

One option - try using a single source stage with multiple output links. Another - one query to stage the entire source table locally, then you can take your time pulling out what you need.
by chulett
Tue Jan 31, 2012 8:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DeadLock Issue with T Connector Stage
Replies: 3
Views: 1610

How are you partitioning for the target? Do an exact search here for "deadlock" to find discussions of the cause and solution for this issue.