Search found 53125 matches

by ray.wurlod
Fri Sep 19, 2008 1:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unable to delete job
Replies: 10
Views: 4464

NO!!! This is a database, not a set of files in a directory. Execute this command in an operating system shell. $DSHOME/bin/list_readu | grep $jobname Substitute for $jobname as appropriate. This will tell you information about the lock on the job, including the process id of the lock's owner. If t...
by ray.wurlod
Thu Sep 18, 2008 9:59 pm
Forum: General
Topic: Has the Large Hadron Collider destroyed the world yet?
Replies: 3
Views: 1300

Has the Large Hadron Collider destroyed the world yet?

People were celebrating last week when the Large Hadron Collider (LHC)was switched on and it didn't destroy the world. You fools! It won't destroy the world until the protons actually start colliding., which is still a couple of weeks away. What they're doing currently is running it in the Debugger,...
by ray.wurlod
Thu Sep 18, 2008 7:14 pm
Forum: General
Topic: Get DS INFO
Replies: 5
Views: 1473

Code: Select all

uv -admin -info
by ray.wurlod
Thu Sep 18, 2008 5:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal to Integer
Replies: 3
Views: 976

What do you want to do with the fractional part (truncate or round)? If round what rounding rule do you want to use?
by ray.wurlod
Thu Sep 18, 2008 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Listing Stages From Executable Of A DataStage Job
Replies: 8
Views: 4030

You can get three different lists of stage types (active, passive and all) using DSGetJobInfo().

If you don't have design time information, then I believe that RT_CONFIGnnn is your only choice. But I'd need to check that.
by ray.wurlod
Thu Sep 18, 2008 3:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting Run Log from Server
Replies: 2
Views: 1279

Moderator: please move to parallel forum
by ray.wurlod
Thu Sep 18, 2008 3:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Key in sequential File
Replies: 3
Views: 1025

Got your Caps Lock on too, we note.
by ray.wurlod
Thu Sep 18, 2008 3:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calling sql query from unix
Replies: 11
Views: 2856

Moderator: please move to parallel forum

I was going to suggest stored procedure stage.
by ray.wurlod
Thu Sep 18, 2008 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSSetDisableProjectHandler
Replies: 4
Views: 1357

Because job control code is created from a "one size fits all" template. These functions are ignored for server jobs.
by ray.wurlod
Thu Sep 18, 2008 3:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need to solve a small scenario which i couldn't get
Replies: 12
Views: 3678

rrsivaraghava wrote:can u reply elaborately

I doubt it. U has not even logged in for about three months.
by ray.wurlod
Thu Sep 18, 2008 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Ascential Datastage
Replies: 5
Views: 1691

Deleting jobs?!!
by ray.wurlod
Thu Sep 18, 2008 7:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Simulating AutoPurge
Replies: 6
Views: 1218

FUNCTION DeleteN(HashedFilePath) * Error handling omitted for clarity * Deletes records from hashed file where field #3 = "N". Equate FIELDNO To 3 ; * adjust as required Ans = 0 OpenPath HashedFilePath To hHashedFile Then Select hHashedFile To 9 Begin Transaction Loop While ReadNe...