Search found 53125 matches

by ray.wurlod
Wed Nov 19, 2014 3:22 pm
Forum: General
Topic: Where Do I find the 'dsexport' command?
Replies: 14
Views: 8344

C:\IBM\InformationServer\Clients\Classic\dsexport.exe
by ray.wurlod
Tue Nov 18, 2014 10:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to use an environment variable
Replies: 7
Views: 3329

Check that you've spelled the environment variable name correctly, and that you've set its value correctly, then involve your official support provider.

No-one here is able to help with "it's not working as documented" problems.
by ray.wurlod
Tue Nov 18, 2014 10:44 pm
Forum: IBM QualityStage
Topic: Multiple variables not working
Replies: 14
Views: 8338

Is Supressedsub the actual name in the file dictionary, rather than (for example) SuppressedSub, Suppressedsub or SupressedSub?
by ray.wurlod
Tue Nov 18, 2014 8:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Leading Zero in RCP Job
Replies: 14
Views: 11722

I should like to point out that the zeroes are perfectly correct; the correct decimal value will be stored in Oracle, irrespective of how it is displayed using View Data.
by ray.wurlod
Tue Nov 18, 2014 8:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Finding where a user defined Data Element is used
Replies: 1
Views: 1237

Seems you've already found the Where Used report, Ross.
by ray.wurlod
Tue Nov 18, 2014 8:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Creation of sequential files using a dynamic parameter
Replies: 3
Views: 1698

The functionality in the Big Data File stage was incorporated into the Sequential File stage too.
by ray.wurlod
Tue Nov 18, 2014 8:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is Orchestrate record schema structure the best to use
Replies: 3
Views: 2565

It should do, even to a column view data lineage report.

Try it, and see.

If not, you can create extension data assets and mappings for them for the purposes of complete lineage reporting.
by ray.wurlod
Tue Nov 18, 2014 8:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TIME CONVERSION
Replies: 12
Views: 6632

I'd use a Fmt() function. Something like

Code: Select all

Fmt(DIGITS(InLink.TheValue), "R##:##")
by ray.wurlod
Tue Nov 18, 2014 8:27 pm
Forum: IBM QualityStage
Topic: Multiple variables not working
Replies: 14
Views: 8338

Try escaping the comma in the first pattern.

Code: Select all

+ | + [ {} != "OF" "ON" ] | \, | B | B | $ [ {multisuburb} = "Y" ] 
by ray.wurlod
Mon Nov 17, 2014 10:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date Conversion (YYYY-MM-DD to MM-DD-YYYY)
Replies: 6
Views: 3348

If the source is in YMD order, then your Iconv() function must also specify YMD order. Yours specifies MDY order.

Try

Code: Select all

Oconv(Iconv(InLink.TheDate, "DYMD"), "D/MDY[2,2,4]")
by ray.wurlod
Mon Nov 17, 2014 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is Orchestrate record schema structure the best to use
Replies: 3
Views: 2565

It's still relevant, but may be incomplete. I would prefer, wherever possible, to import table definitions, so that they are untouched by human hands and, therefore, devoid of transcription errors. I guess you could automate the generation of record schemas, but what would you use as the metadata so...
by ray.wurlod
Mon Nov 17, 2014 3:46 pm
Forum: General
Topic: DataStage 9.1 comes with one other component
Replies: 3
Views: 1525

There is no such thing as DataStage only. You have to buy Information Server, and license DataStage.

You get, as well as DataStage, anything that's free in Information Server. This includes, for example, Blueprint Director.

What is the "one other component" to which you refer?
by ray.wurlod
Mon Nov 17, 2014 3:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Substring function when find a dash
Replies: 7
Views: 3923

One solution

Code: Select all

Oconv(Field(InLink.Customer_cd, " ", 1, 1), "MCN")