Search found 53125 matches
- Wed Jul 02, 2008 4:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with lookup condition continue
- Replies: 4
- Views: 1318
- 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 ...
- 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
- 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...
- 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
- Wed Jul 02, 2008 4:09 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Before-job routine
- Replies: 3
- Views: 1031
- Wed Jul 02, 2008 4:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Permissions to groups
- Replies: 6
- Views: 1942
- 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...
- 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
- Wed Jul 02, 2008 4:00 pm
- Forum: General
- Topic: Is Datastage compliant with Oracle RAC?
- Replies: 6
- Views: 3142
- Wed Jul 02, 2008 3:58 pm
- Forum: IBM QualityStage
- Topic: Problem in running the QSRT
- Replies: 7
- Views: 3109
- Wed Jul 02, 2008 1:17 am
- Forum: IBM QualityStage
- Topic: Problem in running the QSRT
- Replies: 7
- Views: 3109
- Wed Jul 02, 2008 1:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Permissions to groups
- Replies: 6
- Views: 1942
- 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...
- 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>>');