Search found 53125 matches

by ray.wurlod
Tue Nov 13, 2007 11:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in Lookup
Replies: 3
Views: 1025

If the lookup key is a string that contains leading zeroes, then your Key Expression in the Transformer stage needs to add those leading zeroes so that the two values match. Probably the easiest way is

Code: Select all

Fmt(InLink.TheValue, "R%6")
by ray.wurlod
Tue Nov 13, 2007 11:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Investigating why DataStage compile is failing
Replies: 4
Views: 1000

Quick! Enrol in a DataStage Essentials class! Your questions indicate that you have a dearth of fundamental knowledge about the product. Knowledge that you will need to continue to be employed as a DataStage developer.
by ray.wurlod
Tue Nov 13, 2007 11:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing a List of Values Into SQL as Parameter
Replies: 19
Views: 8390

Then you might mark the thread as Resolved.
by ray.wurlod
Tue Nov 13, 2007 11:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Step by step instructions on bouncing DataStage
Replies: 5
Views: 2118

Step 1. RTFM.

DataStage Administrator's Guide page 3-7
by ray.wurlod
Tue Nov 13, 2007 11:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage compile failure
Replies: 3
Views: 1178

"Bounced" means restarted. This ought not to be necessary. Can you compile any other job? Any routine? Can you compile a job in a different project from that same client? What happens if you open a new Designer client?
by ray.wurlod
Tue Nov 13, 2007 11:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Logic Question
Replies: 18
Views: 3588

Stop. Step back. Ignore DataStage for the moment. Write out (in English) a complete specification of what is supposed to happen, including one or two examples. Then post that here.
by ray.wurlod
Tue Nov 13, 2007 10:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MetaData import Erro with 10g
Replies: 4
Views: 1273

Have you also checked tnsnames.ora ?

Is casing as well as spelling correct?
by ray.wurlod
Tue Nov 13, 2007 10:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: date and time in YYYYMMDDHHMISS format
Replies: 1
Views: 1947

CurrentTimestamp() with a "%yyyy%mm%dd%hh%nn%ss" format string should do it.
by ray.wurlod
Tue Nov 13, 2007 10:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Operator terminated abnormally: received signal SIGSEGV
Replies: 7
Views: 27154

Welcome aboard. There is a Search option at the top of this page. You are encouraged to use it.

This signal indicates an attempt to access a memory address that the process does not own. There are myriad possible causes.

How are you at analysing core dumps?
by ray.wurlod
Tue Nov 13, 2007 10:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Stage VS Outer Join
Replies: 12
Views: 5311

Use Monitor in Director. This can show what's happening on each partition. Then relate this to the score (you need $APT_DUMP_SCORE set) to relate the work to the node(s) on which it is being performed.
by ray.wurlod
Tue Nov 13, 2007 10:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UDB API stage hang on the job
Replies: 5
Views: 1337

If you right click on the DB2/UDB API stage, do you see "grid style" on the menu? Do you see "Properties" on the menu? What happens if you choose one of these?
by ray.wurlod
Tue Nov 13, 2007 10:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to install Datastage Command Stage Plugin
Replies: 4
Views: 2629

... hence my reference to "the Start menu on the server".
by ray.wurlod
Tue Nov 13, 2007 5:11 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Padding zeros
Replies: 1
Views: 854

This question (for width of 16) was answered less than an hour ago.
Does Search not work for you?
by ray.wurlod
Tue Nov 13, 2007 5:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Clients in a PC
Replies: 8
Views: 1482

Therefore, YES
by ray.wurlod
Tue Nov 13, 2007 5:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How would I make sense of the error RT_BP690...
Replies: 3
Views: 952

You've only reported the first line of a much longer report - it's the compiler output. The next line, for example, is a row of asterisks, one for each ten lines of source code compiled. The first line is simply reporting the locations of the source code and compiled code when compiling. The source ...