Search found 53125 matches

by ray.wurlod
Thu Jul 09, 2009 4:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of Jobs across Projects
Replies: 13
Views: 5520

I've added the missing Perform statement into the code.

I used @USERNO in case more than one user runs the code at the same time. This can be any system-wide-unique identifier.
by ray.wurlod
Thu Jul 09, 2009 4:25 pm
Forum: General
Topic: Problem with permission
Replies: 11
Views: 4274

This is a really strange error. When connected (to AIX) via telnet, I have seen this message using the du . command. # Let's start somewhere $ cd /home/dsadm/projects/eswm/dev/data/reject $ du . du: can't find current directory $ du /home/dsadm/projects/eswm/dev/data/reject du: can't find current di...
by ray.wurlod
Thu Jul 09, 2009 4:17 pm
Forum: General
Topic: Error while importing table metadata by using plugin
Replies: 3
Views: 1267

Do you have SELECT privilege to the pertinent system tables in which the table and column metadata are stored?
by ray.wurlod
Thu Jul 09, 2009 4:16 pm
Forum: IBM QualityStage
Topic: Ruleset for standardinzing Mexican Ta Payer ID/ IFE/ etc
Replies: 7
Views: 2331

Even an "all T" word investigation might be enough for this particular requirement.
by ray.wurlod
Thu Jul 09, 2009 4:14 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Conversion of Hex Value to equivalent Decimal & ASCII Va
Replies: 5
Views: 5417

Unfortunately I have no TX skills so can't advise how to contruct the map to manage the conversions.
by ray.wurlod
Wed Jul 08, 2009 10:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Licence
Replies: 2
Views: 1291

Provided you have been paying the annual maintenance charge on your 7.5.2 licence, there is no charge for the licence upgrade to 8.1.

(You will, however, probably incur costs related to heavier-duty hardware.)
by ray.wurlod
Wed Jul 08, 2009 10:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repository Migration from 7.5.2 to 8.1
Replies: 2
Views: 1830

It happens automatically as your projects are upgraded or, if you prefer export/clean install/import, as your components are being imported.
by ray.wurlod
Wed Jul 08, 2009 10:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of Jobs across Projects
Replies: 13
Views: 5520

ProjectJobNames = "" Ans = @NULL * Open VOC file - error handling omitted for clarity Open "VOC" To fVOC Else GoTo ErrorExit TempVOCName = "JOBS_" : @USERNO * Get list of project names Query = "SELECT SCHEMA_NAME TO SLIST 9 FROM UV_SCHEMA WHERE SCHEMA_NAME <> 'CAT...
by ray.wurlod
Wed Jul 08, 2009 8:47 pm
Forum: IBM QualityStage
Topic: Ruleset for standardinzing Mexican Ta Payer ID/ IFE/ etc
Replies: 7
Views: 2331

From where I sit, the answer is "almost certainly not" unless you can track down someone who has already built one. If IBM had one they probably would have shipped it.
by ray.wurlod
Wed Jul 08, 2009 5:05 pm
Forum: IBM QualityStage
Topic: Standardization job along with WISD IP/OP
Replies: 12
Views: 6208

During real time you pass back the standardized result, "for better or worse".
by ray.wurlod
Wed Jul 08, 2009 5:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ability to view logs in Director but not start/stop jobs?
Replies: 10
Views: 5212

Operator role can not start most jobs. Operator role can only start "released" jobs, which almost nobody uses any more.
by ray.wurlod
Wed Jul 08, 2009 4:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SFTP with FTP stage version 8.1
Replies: 8
Views: 7126

Unfortunately the original requirement was to get it working in a server job.
by ray.wurlod
Wed Jul 08, 2009 4:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: List of Jobs across Projects
Replies: 13
Views: 5520

Your routine could create a temporary VOC entry that points to DS_JOBS in each other project in turn.
by ray.wurlod
Wed Jul 08, 2009 4:45 pm
Forum: General
Topic: Stage type information and partition information
Replies: 12
Views: 4185

I don't have that information readily to hand, and it's not published. In DS_JOBOBJECTS you need to look at those objects whose OLETYPE is like 'C%Input'. I have no idea where in the record the partitioning information is actually located. And it may well be enumerated.