Search found 53125 matches

by ray.wurlod
Wed Jul 19, 2006 8:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Understanding Environment Variables
Replies: 4
Views: 1699

Well, you could always create message handlers to demote them to informational or suppress them from the job log. (That answer also informs you that I have no idea why you are seeing the behaviour you are seeing, and indirectly that I have no time to research it. Right now I'm in India, but the serv...
by ray.wurlod
Wed Jul 19, 2006 8:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Enterprise Transformer compile error (DSEE7.5.1A, HP-UNIX)
Replies: 6
Views: 2162

Are you certain? References to basicstring.h and RT_BP14.O in the messages do not inspire confidence.
by ray.wurlod
Wed Jul 19, 2006 7:24 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MS Access 2007 to Support Multi-Valued Data Types
Replies: 2
Views: 889

I responded to the author at The Register explaining gently why he is wrong.
by ray.wurlod
Wed Jul 19, 2006 7:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Understanding Environment Variables
Replies: 4
Views: 1699

Check the Administrator client - choose your project then click on the Environment command button to open up the environment variables grid. Maybe the environment variables in question have been added there in DEV but not in SIT and PROD. There's an entire chapter on the parallel engine environment ...
by ray.wurlod
Wed Jul 19, 2006 6:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MS Access 2007 to Support Multi-Valued Data Types
Replies: 2
Views: 889

MS Access 2007 to Support Multi-Valued Data Types

MS Access 2007 is to support multi-valued data types! "... if you are an application developer, the finer points of relational database theory often sound like just so much academic nonsense. If a new feature makes life easier, who cares if it happens to break some arbitrary rule written over 20 yea...
by ray.wurlod
Wed Jul 19, 2006 6:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: server engine status
Replies: 12
Views: 3879

You could start dsrpcd in a low-verbosity debugging mode, or even simply direct its output to some other file than /dev/null. Even this would not tell you that it's running now, but would tell you how recently it had logged anything. After all, it's a listener - it doesn't do anything unless asked t...
by ray.wurlod
Wed Jul 19, 2006 5:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need Routine Function
Replies: 8
Views: 2723

From an efficiency point of view, an Index() function looking for the first occurrence may be preferable. Index(link.column#1, "|", 1) = 0 And Index(link.column#2,"|", 1) = 0 And ... Then you could make use of the Boolean context to strip out the comparisons with ...
by ray.wurlod
Wed Jul 19, 2006 5:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MQ Stage...ds_loadlibrary: error in dlopen
Replies: 5
Views: 1066

Currently the MQ server must be installed on the same machine as the DataStage server. I believe this requirement is to be relaxed in Hawk, and only a client will be required.
by ray.wurlod
Wed Jul 19, 2006 5:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Folder stage equivalent in PX
Replies: 8
Views: 5233

You can also read multiple files in different directories by setting the Source property to Specific File and using multiple File properties. Of course the files must have identical record schema.

What Craig says about XML is true, however.
by ray.wurlod
Wed Jul 19, 2006 5:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to Transform 09302006 to a valid date
Replies: 16
Views: 3126

Server job solution

Code: Select all

Oconv(Iconv(InLink.TheDateStr, "DMDY"), "D-YMD[4,2,2]")


(I thought you were in India, Arun: how come you're dealing with MDY format dates?)
by ray.wurlod
Wed Jul 19, 2006 5:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 equivalent of substr()
Replies: 9
Views: 3895

In a Modify stage numbers are zero-based, so the third character is number 2 and the required function is either substring[2,5](field) or substring[2,3](field) as the other issue is resolved.
by ray.wurlod
Wed Jul 19, 2006 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use the structure file
Replies: 1
Views: 679

Two words: design freeze. Inform them that every change that requires you to re-work your solution is costing them more at your hourly rate, and is likely to slip the project schedule further. As a general rule, "dynamic metadata" can't be done out of the box. There was an attempt some years back to...
by ray.wurlod
Wed Jul 19, 2006 5:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: condition in sequencer / jobs
Replies: 8
Views: 1966

Be more thoughtful/specific about your requirement. You say that the branch is based on "a" value. Even though that value is in a Data Set, is it correct that it is nonetheless only a single value? So it would still be possible to use a job to extract that value and write it to a sequential file? (T...
by ray.wurlod
Wed Jul 19, 2006 5:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: J2EE in Datastage PX
Replies: 4
Views: 1058

Not all job specifications are written by knowledgable persons. We have laughed at a few in the past. The usual classic is requiring 10 years experience with a four year old product. Think "pointy haired boss".
by ray.wurlod
Wed Jul 19, 2006 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Enterprise Transformer compile error (DSEE7.5.1A, HP-UNIX)
Replies: 6
Views: 2162

Please confirm that this is a BASIC Transformer, not a regular Transformer stage.