Search found 53125 matches

by ray.wurlod
Wed Oct 05, 2011 3:09 pm
Forum: General
Topic: XMETA DATABASE TABLES
Replies: 7
Views: 4846

If you break anything you're on your own. Read your licence agreement carefully, particularly the section about reverse engineering.
by ray.wurlod
Wed Oct 05, 2011 3:08 pm
Forum: General
Topic: List of DS command
Replies: 4
Views: 1853

No.
by ray.wurlod
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 /....
by ray.wurlod
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...
by ray.wurlod
Wed Oct 05, 2011 2:49 pm
Forum: General
Topic: Status code = -99 DSJE_REPERROR from unix shell
Replies: 1
Views: 1957

Welcome aboard.

-99 is a general repository error; that message doesn't tell us (or you) very much. Double check the syntax of your dsjob command, particularly if you are passing shell variables to it.
by ray.wurlod
Wed Oct 05, 2011 2:55 am
Forum: General
Topic: uvodbc.config
Replies: 2
Views: 957

As they say, "there's no place like 127.0.0.1".
by ray.wurlod
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') 
by ray.wurlod
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

What is "DATES ""INSTRUMENT(MNEMONIC)"" ""DATATYPES"" doing? Is this the entire first line or is it the first three columns in a longer first line? Is "DATES ""INSTRUMENT(MNEMONIC)"" ""DATATYPES"" ""1...
by ray.wurlod
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

This looks like a vertical pivot requirement to me.
by ray.wurlod
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

Leave 64BIT_FILES set to 0. The "bittage" setting in hashed files affects only the internal pointers in the hashed files - there is no interaction with the operating system. Many hashed files require only to be small, and contain small records. With 32-bit pointers the storage overhead is ...
by ray.wurlod
Tue Oct 04, 2011 11:50 pm
Forum: General
Topic: clearing &PH& directory in production environment
Replies: 45
Views: 11992

Thanks Craig! And i have some more queries based on your previous responses. Those sh entries which you told are only specific to 8.7? And what's the role of datastAge copy command? In which case dsd.oshmonitor entry will be created in &ph& directory?if we give monitor in director, will it ...
by ray.wurlod
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...
by ray.wurlod
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

Welcome aboard. What are you comparing against in the Change Capture stage? How are you ensuring that, for example, txn1 has been committed into that data set when processing txn2?
by ray.wurlod
Tue Oct 04, 2011 4:58 pm
Forum: General
Topic: clearing &PH& directory in production environment
Replies: 45
Views: 11992

I have just checked in version 8.7 (beta) and found that there is one file per job run in &PH&. I am not using multi-instance jobs, however. As well as RUN entries there are also SH entries when errors occurred communicating with OSH, DOS entries when errors occurred communicating with servi...
by ray.wurlod
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:

Code: Select all

If IsNotNull(InLink.SDate) And IsNotNull(InLink.EDate) Then DateFromDaysSince(7,InLink.EDate) Else InLink.EDate
Apply appropriate conversion functions where needed.