Search found 53125 matches

by ray.wurlod
Wed Jul 02, 2008 4:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Age calculation from Date Of Birth
Replies: 6
Views: 2141

Yes, you really do need a tighter definition. For example Chinese practice is that a newborn has an age of 1. Do you need to incorporate this possibility in your business rules? The algorithm begins as ArndW suggests, then tests whether the day and month of birth has already occurred in the current ...
by ray.wurlod
Wed Jul 02, 2008 4:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding Zeros to string
Replies: 5
Views: 1416

... Convert() uses fewer resources than Ereplace().
by ray.wurlod
Wed Jul 02, 2008 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Container name
Replies: 15
Views: 4123

Could you please paste the code once more as i am not a premier customer now(likely to be a soon). or you can email me Premium memberships is one of the ways that the hosting and bandwidth costs of DSXchange are funded. I am not prepared to create a precedent that might threaten the existence of th...
by ray.wurlod
Wed Jul 02, 2008 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Server 7.5.1A migration issue to 7.5.3
Replies: 16
Views: 8460

*Topic Relocated- Content Editor*
by ray.wurlod
Wed Jul 02, 2008 4:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Before-job routine
Replies: 3
Views: 1031

I identified your syntax error in my previous post on this thread.
by ray.wurlod
Wed Jul 02, 2008 4:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Permissions to groups
Replies: 6
Views: 1942

Any member of the group associated with the DataStage developer role can access DataStage. What they can actually do can be controlled with operating system permissions.
by ray.wurlod
Wed Jul 02, 2008 4:06 pm
Forum: General
Topic: Version 8 to solve backup and access permission problems?
Replies: 6
Views: 3879

Version 8 gives you a Super Operator role, that can view designs read-only (and can execute all jobs). There is nothing new for backup/restore in version 8. Indeed, Version Control has been withdrawn, pending a new utility that is not yet available, but will be closer to a source code control system...
by ray.wurlod
Wed Jul 02, 2008 4:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Server 7.5.1A migration issue to 7.5.3
Replies: 16
Views: 8460

Please disable operator combination so that you can learn which operator is throwing the error.
by ray.wurlod
Wed Jul 02, 2008 4:00 pm
Forum: General
Topic: Is Datastage compliant with Oracle RAC?
Replies: 6
Views: 3142

It does not true in Oracle. That's why you need select privilege on certain Oracle system tables. So that partitioning information can be discovered at runtime.
by ray.wurlod
Wed Jul 02, 2008 3:58 pm
Forum: IBM QualityStage
Topic: Problem in running the QSRT
Replies: 7
Views: 3109

No idea, because I can not view the log. You can. Please do so.
by ray.wurlod
Wed Jul 02, 2008 1:17 am
Forum: IBM QualityStage
Topic: Problem in running the QSRT
Replies: 7
Views: 3109

Check permissions on the mngr.cfg file. Even qsrtmngr.exe is unable to open it.
by ray.wurlod
Wed Jul 02, 2008 1:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Permissions to groups
Replies: 6
Views: 1942

There are many possible reasons, not just permissions, that might cause this symptom. Search the forum for the error code 30107 to see if that sheds any light on why your problem may have occurred.
by ray.wurlod
Wed Jul 02, 2008 1:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want multiple operations executed in if condition
Replies: 4
Views: 1601

Welcome aboard. There are no necessary delimiters. The entire If..Then..Else construct can be (and usually is) a single string. If test_expression Then expression1 Else expression2 The value generated by test_expression (true or false) determines whether the result of expression1 or the result of ex...
by ray.wurlod
Wed Jul 02, 2008 1:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Container name
Replies: 15
Views: 4123

Code: Select all

SELECT NAME AS CONTAINER_NAME
FROM DS_JOBOBJECTS
WHERE (OBJNAME LIKE 'C_' OR OBJNAME LIKE 'C__')
AND OBJIDNO IN (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>');