Search found 53125 matches
- Wed Oct 05, 2011 3:09 pm
- Forum: General
- Topic: XMETA DATABASE TABLES
- Replies: 7
- Views: 4846
- Wed Oct 05, 2011 3:08 pm
- Forum: General
- Topic: List of DS command
- Replies: 4
- Views: 1853
- Wed Oct 05, 2011 3:07 pm
- Forum: General
- Topic: Export VOC file content
- Replies: 1
- Views: 862
VOC already is a hashed file. Yes it's possible to export its contents. However, let me assure you that merely being able to see what's in VOC will not really help your understanding. You need to undertake some UniVerse training for that. Something like the following will work. export DSHOME=`cat /....
- Wed Oct 05, 2011 3:00 pm
- Forum: General
- Topic: how to get the username from userno in LIST.READU
- Replies: 9
- Views: 7185
Do not use INODE option for unlocking jobs; it's not necessary. Further, this command may not unlock the job - you really should be using Session management in Web Console for Information Server for that. A mapping from the internal user number to the corresponding execution name can be had from one...
- Wed Oct 05, 2011 2:49 pm
- Forum: General
- Topic: Status code = -99 DSJE_REPERROR from unix shell
- Replies: 1
- Views: 1957
- Wed Oct 05, 2011 2:55 am
- Forum: General
- Topic: uvodbc.config
- Replies: 2
- Views: 957
- Wed Oct 05, 2011 2:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Like operator with null handling
- Replies: 5
- Views: 1932
You don't need If expr Then 1 Else 0 because, in a Boolean context, expr returns 1 (True) or 0 (False). Use any technique you like to handle null.
Code: Select all
(NullToEmpty(Column_1)='0004400') And (NullToEmpty(column_2)='1221') And (Index(NullToEmpty(column_3),"NOG",1) <>'0') - Wed Oct 05, 2011 2:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TRANSPOSE ! is it possible?
- Replies: 19
- Views: 5010
- Wed Oct 05, 2011 12:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TRANSPOSE ! is it possible?
- Replies: 19
- Views: 5010
- Tue Oct 04, 2011 11:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Changing 64BIT_FILES to 1
- Replies: 7
- Views: 3868
- Tue Oct 04, 2011 11:50 pm
- Forum: General
- Topic: clearing &PH& directory in production environment
- Replies: 45
- Views: 11992
- Tue Oct 04, 2011 11:45 pm
- Forum: General
- Topic: Run datastage job through Tivoli scheduler
- Replies: 4
- Views: 3205
Alternative approach is to install dsjob executable and its associated DLLs on the same machine as a Tivoli agent (which could be the Tivoli server machine). The dsjob command requires -domain and -server arguments, which tell it where the machine on which the project is located is to be found and w...
- Tue Oct 04, 2011 5:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transactional Data and Change Capture
- Replies: 7
- Views: 2306
- Tue Oct 04, 2011 4:58 pm
- Forum: General
- Topic: clearing &PH& directory in production environment
- Replies: 45
- Views: 11992
- Tue Oct 04, 2011 4:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic for implementation of the req
- Replies: 4
- Views: 1764
Derive EDate as something like:
Apply appropriate conversion functions where needed.
Code: Select all
If IsNotNull(InLink.SDate) And IsNotNull(InLink.EDate) Then DateFromDaysSince(7,InLink.EDate) Else InLink.EDate