Search found 53125 matches

by ray.wurlod
Wed Feb 15, 2006 5:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job being monitored eror
Replies: 11
Views: 2766

HOW did you "check for locks"?
by ray.wurlod
Wed Feb 15, 2006 5:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Need Help w/Frmtg Float Data fr: 37.169151 to: 37.169151000
Replies: 3
Views: 1013

Try

Code: Select all

Fmt(TheValue, "L%20")
by ray.wurlod
Wed Feb 15, 2006 5:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MQ plugins
Replies: 2
Views: 1092

No. I wasn't even aware that there is a version 6.2. Can you please verify? Use Help About from the Administrator client, and post results here.
by ray.wurlod
Wed Feb 15, 2006 5:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Parallel (Enterprise Edition) Training
Replies: 7
Views: 2963

Private email from dsrules: Hi Ray, Just wanted to know if the EE lab is for a guy like me who has knowledge of DataSets, Joins, Lookups, node pools, orchadmin, dsrecords.. etc but does not know about Parallel Routines, Custom Stages and complex buildops. I have done simple test buildops. Please sug...
by ray.wurlod
Wed Feb 15, 2006 5:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Parallel (Enterprise Edition) Training
Replies: 7
Views: 2963

This class is called Server to Parallel Transition - it's aimed at experienced server job developers and aims to enhance their skill set so that they can create parallel jobs. Part of the deal includes lab exercises and manual, another part of the deal includes access to the server for a while after...
by ray.wurlod
Wed Feb 15, 2006 4:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to find the Hash file as table in UV Stage
Replies: 9
Views: 3749

If this is a UV statge:
(a) you DO need SETFILE if the hashed file was created in a directory
(b) you DO need a DSN - localuv is appropriate for the current project
(c) then the warning about the ODBC characters are non-fatal (but you really should fix them)
by ray.wurlod
Wed Feb 15, 2006 4:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Track ups and downs of DataStage Services
Replies: 4
Views: 1189

You been hacked? "Not ME" is a VERY suspicious name! The fundamental services do not record their startup/shutdown, but you could always edit the reconfiguration script (ds.rc) so that they do. The background processes that run server jobs always create an entry (name begins with DSD.RUN) in the &am...
by ray.wurlod
Wed Feb 15, 2006 4:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple values in parameter
Replies: 4
Views: 1440

Problem with Index() is that it will "find" 1 if 1 isn't in the list but 21 or 17 is in the list. You really need to convert the list into a dynamic array and use Locate as the search mechanism. Since Locate is a statement rather than a function you will need to do this in a Routine.
by ray.wurlod
Wed Feb 15, 2006 3:59 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sqlldr Password visible at Unix level
Replies: 9
Views: 5373

Plus I know for a fact that this was solved at RIL last time I was there. You will be able to find examples where the password is not visible. Think about environment variables, think about "here scripts" that actually prompt for passwords, where the value can be provided from the environment variab...
by ray.wurlod
Wed Feb 15, 2006 3:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: hOW CAN i IMPLEMENT A SQL 'BETWEEN' IN AN TRANSFORMATION
Replies: 1
Views: 945

Create a transform function (Routine). Best is to use searchable structures - dynamic arrays or Btree files - that are cached in memory (declared as COMMON).
by ray.wurlod
Wed Feb 15, 2006 3:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL query with IN clause
Replies: 14
Views: 4137

There is a limitation to my job - I have to do this in one job only and I can not use temp storage at all.. strange but ya its the requirement.... If you're going to be a DS professional you need to learn to challenge requirements (politely - get their reasons - then post them here, we could do wit...
by ray.wurlod
Wed Feb 15, 2006 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Prob in Fixed width generation
Replies: 4
Views: 1164

Have you tried setting the widths in the Display Width column? In fixed-width, of course, you can't use @NULL - you will need some representation that is the correct number of characters.
by ray.wurlod
Wed Feb 15, 2006 3:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Remote exec
Replies: 5
Views: 1331

elavenil wrote:Hi Arnd,

Thanks for your response.

Managed to do this by enabling few flags available in load command itself.

Regards
Saravanan

We like to share solutions here. Which flags, in what load command?
by ray.wurlod
Wed Feb 15, 2006 3:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get of job parameter in Sequence UserActivity stage.
Replies: 2
Views: 1146

Use the mouse, Lance!

Select the parameter from the presented list, rather than typing it in.

(If you already are, then you've uncovered a bug.)
by ray.wurlod
Wed Feb 15, 2006 3:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error when validating a job
Replies: 1
Views: 813

Is this the same problem about which you've already started three other threads? :roll: