Search found 15603 matches

by ArndW
Mon Feb 12, 2007 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal field with Trailing negative signs
Replies: 18
Views: 3915

Have you tried declaring it as a decimal field, then giving it a "unpacked, separate" and "trailing sign" in the attributes?
by ArndW
Mon Feb 12, 2007 10:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal field with Trailing negative signs
Replies: 18
Views: 3915

Adam, how this question is answered depends upon whether is a server job (as per your "Job Type") or a PX one (as per your select forum). Which is it?
by ArndW
Mon Feb 12, 2007 9:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Nodes in Parallel Extender
Replies: 3
Views: 707

Craig - it would be tough with a default PX configuration in Japan, since "4" is considered to be the unlucky number. I walk under ladders, after black cats cross my trail and have flown on a Friday the 13th. Which probably explains why I've go so many issues :)
by ArndW
Mon Feb 12, 2007 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Nodes in Parallel Extender
Replies: 3
Views: 707

Sure, there is nothing against an odd number of nodes.

When doing performance testing I start with 1 and work my way up to see which gets the best throughput. Heck, I even use 13 nodes...
by ArndW
Mon Feb 12, 2007 8:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fetch value for APT_CONFIG_FILE value in Unix environment?
Replies: 12
Views: 3617

Your project will be in the directory DSGuru2B mentioned if you used the default installation paths; but note that project directories can (and are) put anywhere on the machine. If you login using the Administrator it will show you the path to a project and you can use that to find the project's DSP...
by ArndW
Mon Feb 12, 2007 5:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: update columns dynamically
Replies: 9
Views: 1514

The name of column in the metadata becomes irrelevant in this case, you can use whatever name you wish.
by ArndW
Mon Feb 12, 2007 5:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem obtaining Performance Stats for one Project
Replies: 11
Views: 6718

poonamgoyal, you have just posted to a thread last updated in May 2005.

Are you having the same problem?
by ArndW
Mon Feb 12, 2007 5:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: update columns dynamically
Replies: 9
Views: 1514

You can pass the column name into the job as a parameter and use the parameter as a placeholder in custom SQL to read/write/update your database.
by ArndW
Mon Feb 12, 2007 5:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: environmental variable in a rountine
Replies: 12
Views: 3810

The "UnixOutput" will also contain @FM characters. If it is empty, try echo-ing a value that you know is set, such as $DSHOME.
by ArndW
Mon Feb 12, 2007 4:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: update columns dynamically
Replies: 9
Views: 1514

Ah, now I understand the question. You want to pass the column name dynamically, not the column's value. You cannot do it by putting a parameter in place of a column name.

Are you writing a PX or a Server job (you posted in Server but specified a PX job)?
by ArndW
Mon Feb 12, 2007 4:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: update columns dynamically
Replies: 9
Views: 1514

Peter, it sounds like it would be easy to do this in one job, unless there are difficulties that you haven't mentioned.
by ArndW
Mon Feb 12, 2007 4:33 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: how to get values from an xml file to a variable in routine
Replies: 3
Views: 1951

Is this a server/parallel job or a TX job? If the former, you can use DSGetStageInfo() using the DSJ.STAGECPU key to get CPU time used in a stage. There is still a bug in this value, it doesn't actually return the CPU time used, but the CPU percentage; so you have to use the stage runtime computed b...
by ArndW
Mon Feb 12, 2007 2:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run Multiple Instances
Replies: 25
Views: 7993

Pravin - this is almost a new subject, so normally it would be best to start a new thread. You need to pass the instance name to the jobs you are calling from the sequence - this can be done via parameters.
by ArndW
Sun Feb 11, 2007 10:20 am
Forum: General
Topic: DataStage best Practices doc
Replies: 20
Views: 10460

And for those who think that this document is desirable because of it's restricted status, please remember that even the U.S. government has kept documents such as "a 1962 telegram from George F. Kennan, then ambassador to Yugoslavia, containing an English translation of a Belgrade newspaper article...
by ArndW
Sun Feb 11, 2007 6:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file creation problem in the Lookup Job
Replies: 14
Views: 2904

UNC is Universal Naming Convention and it would be \\server/dir/dir for you on windows.