Search found 53125 matches

by ray.wurlod
Wed Sep 29, 2010 1:37 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date to gregorian Format
Replies: 2
Views: 1632

You need to know the "day zero" for your particular date format. The default is 1967-12-31. Iconv(InLink.TheDate, "DYMD") will convert into what you've called a Gregorian date with 1967-12-31 converting to 0. If this is not your day zero, simply take the Iconv() of your day zero ...
by ray.wurlod
Tue Sep 28, 2010 10:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: want to remove strip Character (|| ) in output file
Replies: 3
Views: 1983

Search DSXchange for a parallel version of the server Ereplace() function. This is precisely what you need.
by ray.wurlod
Tue Sep 28, 2010 10:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to prevent rounding off in ds
Replies: 6
Views: 4386

If you use conversion functions in a downstream Modify or Transformer stage you can use the "rtype" argument to specify rounding, truncation, etc.
by ray.wurlod
Tue Sep 28, 2010 10:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to prevent rounding off in ds
Replies: 6
Views: 4386

The Aggregator stage also has a general and a per-column DecimalOutput property. (It may not be called precisely that - I answered from memory.)
by ray.wurlod
Tue Sep 28, 2010 4:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invoke routine from another datastage routine
Replies: 3
Views: 1916

Standard C++ programming techniques, then. How you do it depends on whether you want the other routine to be dynamically or statically linked.
by ray.wurlod
Tue Sep 28, 2010 4:43 pm
Forum: General
Topic: DataStage Server v8.0.1
Replies: 5
Views: 2420

This is done using Web Console for Information Server, provided that you are logged in as a user in the Suite Administrator role. There is a Users and Groups menu on the Administration tab in this case.
by ray.wurlod
Tue Sep 28, 2010 4:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: time conversion
Replies: 3
Views: 1099

Watch out for daylight saving, particularly when the changeover dates are set to convenient values by politicians.
by ray.wurlod
Tue Sep 28, 2010 4:40 pm
Forum: General
Topic: DataStage 8 Certification Exam - Sample Questions?
Replies: 7
Views: 4593

There are sample questions on the IBM certification website.
by ray.wurlod
Tue Sep 28, 2010 4:36 pm
Forum: General
Topic: What is use of template?
Replies: 8
Views: 2178

Does have (Templates) and doesn't have (the so-called Intelligent Assistants).
by ray.wurlod
Tue Sep 28, 2010 4:34 pm
Forum: Enhancement Wish List
Topic: Data Preview
Replies: 5
Views: 9572

Server jobs already have the interactive debugger. An interactive debugger is also on the roadmap for parallel jobs, possibly as soon as the next-to-be-released version.

There are interesting questions to be resolved debugging processes that may be spread across multiple machines.
by ray.wurlod
Tue Sep 28, 2010 3:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we Migrate datastage jobs from LInux to Unix Environment
Replies: 5
Views: 1865

No, because there's no single thing called UNIX (for example there's AIX, HP-UX, Solaris and more) and there's no single thing called Linux (for example there's Red Hat, SuSe and others). DataStage functions are identical on all platforms as much as possible. The differences are minor, for example b...
by ray.wurlod
Tue Sep 28, 2010 3:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: occurring problem
Replies: 13
Views: 4543

Moderator: please move to Enterprise Edition (parallel) forum.

Done. You really don't need to call these out any more, I'll find and move them regardless.
by ray.wurlod
Tue Sep 28, 2010 3:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Output stage
Replies: 4
Views: 1267

Parallel job (as marked) or server job (as posted)?
by ray.wurlod
Tue Sep 28, 2010 3:48 am
Forum: General
Topic: Schedule Job automatically
Replies: 9
Views: 3585

No.

But, if you capture the queued commands for cron and/or at while things are good, you can resubmit directly onto the queues.
by ray.wurlod
Tue Sep 28, 2010 1:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we Migrate datastage jobs from LInux to Unix Environment
Replies: 5
Views: 1865

Yes it's possible. The usual export/import or Information Server Manager techniques will work. If you've been good, your pathnames are all parameterized, so you may only need to change their default values, or values in values files of parameter sets.