Search found 53125 matches

by ray.wurlod
Thu May 31, 2007 10:21 pm
Forum: General
Topic: Are server jobs not supported in DataStage 8.0?
Replies: 3
Views: 1083

Search the forum, where you will find definitive statements - one quoting Keith Kohl, worldwide head of DataStage - that server jobs will continue to be supported for the foreseeable future, meaning at least five years. Probably forever while ever DataStage is a product. There was some FUD (fear, un...
by ray.wurlod
Thu May 31, 2007 7:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help Required
Replies: 4
Views: 998

Typically you don't. You create test data and use those data to test that DataStage is doing the right thing. Of course you can. You can use the Transformer stage with no input link as a row generator. Derive all the columns using whatever expressions you like. Include a constraint expression of the...
by ray.wurlod
Thu May 31, 2007 7:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: No of years
Replies: 11
Views: 2364

Search for AddYears or AddMonths. You will find a link to a dsx file on my website with several date manipulation routines of this type.
by ray.wurlod
Thu May 31, 2007 7:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Question regarding Sequences
Replies: 11
Views: 2717

You can sleep even easier if you make the recipient someone who doesn't know your phone number!
:lol:
by ray.wurlod
Thu May 31, 2007 7:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential files with different metadata using one stage
Replies: 3
Views: 1361

Sure. Make use of the Schema File property.
by ray.wurlod
Thu May 31, 2007 7:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding NLS to An Existing Installation
Replies: 1
Views: 728

Welcome aboard. :D

You will need to re-install. Best practice is to uninstall first. Before doing that, of course, take a backup. Then take a second backup, just in case.
by ray.wurlod
Thu May 31, 2007 7:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Config file query
Replies: 5
Views: 1144

Grammatical Note

Your most welcome WHAT?

Did you mean "you're"?
by ray.wurlod
Thu May 31, 2007 7:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS, codepages and locales on Parallel jobs
Replies: 7
Views: 1716

Welcome aboard. Bienvenue.

Install is usually only dimmed if you are logged in without Administrator privileges.
by ray.wurlod
Thu May 31, 2007 7:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference between filter stage and constraint
Replies: 4
Views: 1526

Filter stage uses an SQL-like WHERE clause.
Switch stage uses a value.
Transformer stage uses a BASIC-like expression.
by ray.wurlod
Thu May 31, 2007 7:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange warning from a sequential file load
Replies: 5
Views: 2217

The Field Width property is the Display Size, not the SQL precision.
by ray.wurlod
Thu May 31, 2007 7:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reject link in Oracle stage
Replies: 4
Views: 1049

These ones you can't. Direct them to an otherwise/log link in an upstream Transformer stage.
by ray.wurlod
Thu May 31, 2007 7:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2INSTANCE Warning
Replies: 3
Views: 1451

Either via the Server option in your DB2 stage, or via the APT_DBNAME environment variable, you've specified db2inst2.
by ray.wurlod
Thu May 31, 2007 7:14 pm
Forum: General
Topic: Training Suggestions
Replies: 3
Views: 1095

The (non IBM) training advertised on my website can be sourced through the parent company of DSXchange (DCS Strategies, also known as On Demand Strategies). Or directly.
by ray.wurlod
Thu May 31, 2007 7:07 pm
Forum: Site/Forum
Topic: download files?
Replies: 3
Views: 2796

There is one (a "leftover") at the sister site www.datastagexchange.com
by ray.wurlod
Wed May 30, 2007 11:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can get a 'byte' column data from informix?
Replies: 1
Views: 902

What happens when you import the table definition? (Use orchdbutil; it seems to be more accurate.)