Search found 53125 matches

by ray.wurlod
Sun Aug 15, 2010 2:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Server routine compile error in Version 8
Replies: 7
Views: 1943

The code compiles perfectly well on my machine too (I changed dukOpenFile references to OpenSequentialFile, since that's obviously what it's based on - I do trust that you kept my copyright notice intact as instructed in the original code!). Try copying and pasting the code from this thread into a n...
by ray.wurlod
Sun Aug 15, 2010 2:27 am
Forum: General
Topic: Error when creating any job after project is created.
Replies: 1
Views: 1211

Can you prove that the project was created successfully? A partially-created project will probably not allow creation of jobs. The next thing to look for might be permissions. What user created the project? Is the user trying unsuccessfully to create a job the same user? What is each of those users'...
by ray.wurlod
Sun Aug 15, 2010 2:24 am
Forum: General
Topic: Rebooting the server
Replies: 1
Views: 926

Can you connect to the server? If you can ping the server, then the server is back up, but not necessarily all the required components. To find out if the WebSphere Application Server is up, there is a command serverStatus.sh that can be executed. You need to know the name of the default profile ser...
by ray.wurlod
Sun Aug 15, 2010 2:20 am
Forum: General
Topic: Transformer Stage Editor deletes the wrong column
Replies: 2
Views: 795

Hmm...

Not to mention "erk!"

Nice catch. Lucky you have a slow system (or super fast vision)!
by ray.wurlod
Fri Aug 13, 2010 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to remove control M or special character by ds jobs
Replies: 8
Views: 11732

I expect you will end up setting the Record Delimiter String property to "DOS style".
by ray.wurlod
Fri Aug 13, 2010 6:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Julian day
Replies: 5
Views: 2324

Look at the incoming date/time at around record # 400,000. Report if there's anything different about it.
by ray.wurlod
Fri Aug 13, 2010 6:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error reading Excel worksheet
Replies: 5
Views: 4219

The ODBC stage has a property for quote character on the Stage properties. Click "Get SQL Info" to have this populated with the correct value from the database. You could also apply double quotes around the table name in the Table Name property.
by ray.wurlod
Fri Aug 13, 2010 6:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Transformer in Datastage 8.1 Parallel job
Replies: 7
Views: 6851

There's never time to do it right, so they have to take more time to do it again some time in the future.
by ray.wurlod
Fri Aug 13, 2010 6:19 am
Forum: General
Topic: DSLogFatal using in a sequencer
Replies: 1
Views: 1020

You can't do it that way. DSLogFatal() only ever aborts the job from which it was invoked. Therefore you need to do something like detect the failure of S2 in S1 and react accordingly, or not fail S2 at all and detect the job failure in S1.
by ray.wurlod
Fri Aug 13, 2010 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ( RT_SCTEMP/jobname.fifo); file is locked
Replies: 2
Views: 5047

There's already an open thread on this question. Opening a second thread won't help.
by ray.wurlod
Fri Aug 13, 2010 6:15 am
Forum: General
Topic: My loop stopped working
Replies: 6
Views: 1883

Can you create a Routine activity on an output link from the End Loop activity - call UtilityMessageToLog() to report anything you like, but also perhaps the value of the loop $Counter activity variable.
by ray.wurlod
Fri Aug 13, 2010 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error setting up internal communications
Replies: 6
Views: 7446

Does the name of the fifo file include just the job name, or does it include the invocation ID as well? If it's only the job name, then you've bumped up against a limitation of multi-instance running.
by ray.wurlod
Fri Aug 13, 2010 12:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS v8.1 will work in Window 7
Replies: 4
Views: 2446

But it's not certified for the server components and therefore IBM would be within their rights to refuse support for that combination.
by ray.wurlod
Fri Aug 13, 2010 12:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error setting up internal communications
Replies: 6
Views: 7446

The fifo files are named pipes used (probably) for inter-process communication. Perhaps there are left-over fifo files from an earlier aborted job? Could it be that two concurrent jobs are trying to use the same fifo file?
by ray.wurlod
Fri Aug 13, 2010 12:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Change Capture Stage Warning
Replies: 4
Views: 3354

Craig has it. Search for Local.msh unless you're using named message handlers, which are stored "globally" in a MessageHandlers directory. They still have the ".msh" suffix, though.