Search found 53125 matches

by ray.wurlod
Mon Mar 28, 2011 11:17 am
Forum: General
Topic: Not able to login to DataStage 7.5.2
Replies: 6
Views: 3617

There is none. The term "unsupported" is unambiguous.
by ray.wurlod
Mon Mar 28, 2011 11:16 am
Forum: General
Topic: Not able to administer projects in IIS console
Replies: 7
Views: 2798

You administer projects in the appropriate tool - DataStage, Information Analyzer, etc. Once user project credentials have been added in that tool they become visible (but not editable) in the Web Console.
by ray.wurlod
Mon Mar 28, 2011 11:15 am
Forum: General
Topic: Run all the jobs concurrently
Replies: 10
Views: 2864

It IS as simple as Craig doesn't believe. Seven disconnected job activities will run simultaneously - or as close to simultaneously as their startup times permit.
by ray.wurlod
Mon Mar 28, 2011 2:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: logic implementation
Replies: 4
Views: 1618

Why don't YOU try it first? We're not really here to solve your problems, we're here to help you with them.

And why did you choose to post a server question in the Enterprise Edition forum?
by ray.wurlod
Mon Mar 28, 2011 2:05 am
Forum: General
Topic: Datastage 7.5.1A Migration From Solaris to AIX
Replies: 39
Views: 16310

Installing is installing is installing. You need to install the AIX version. Are you installing on 64-bit or 32-bit version of AIX? (DataStage 7.5 is a 32-bit application.) Migration of DataStage artifacts is then a matter of export then import. Since export is pure text, the chipset is irrelevant t...
by ray.wurlod
Mon Mar 28, 2011 12:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date Format DD-MM-YYYY
Replies: 5
Views: 3307

In a Transformer stage, IsValid("date", inLink.TheDate, "%dd-%mm-%yyyy")
by ray.wurlod
Sun Mar 27, 2011 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unmatched records
Replies: 3
Views: 1704

Yes, just terminate it with a Copy stage that has no outputs. This will consume all its inputs.
by ray.wurlod
Sun Mar 27, 2011 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unmatched records
Replies: 3
Views: 1704

Yes, but what's wrong with the approach you have taken?

The Merge stage also allows unmatched records to be detected and handled. Properties in the stage govern the behaviour.
by ray.wurlod
Sun Mar 27, 2011 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Leading & trailing zero's in column export stage
Replies: 5
Views: 3800

Correct. Read my earlier response again.
by ray.wurlod
Sun Mar 27, 2011 1:23 pm
Forum: General
Topic: Not able to login to DataStage 7.5.2
Replies: 6
Views: 3617

Is this version 7.5.2 or version 7.5x2 ?

Make sure (in Control Panel) that all DataStage services are running.

Note, too, that Windows 7 is not a supported operating system for version 7.anything - you may not be able to succeed at all.
by ray.wurlod
Sat Mar 26, 2011 4:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Leading & trailing zero's in column export stage
Replies: 5
Views: 3800

Don't worry about it. That's now the Decimal number is displayed. It's not stored like that in a database table; it's stored in a binary format. The display format will be used if the decimal is converted to a string (e.g. for export) but, if that's the case, you can trim the leading and trailing ze...
by ray.wurlod
Sat Mar 26, 2011 4:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can aggregator stage be of some help
Replies: 21
Views: 7860

If you've got version 8.5 you can do that in the Transformer stage using the new internal loop. Otherwise use the fork join design, having created a join key (perhaps @INROWNUM in a Transformer stage would do it). If you need a nested fork join design then so be it - it works, indeed there's an exer...
by ray.wurlod
Sat Mar 26, 2011 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to longnvarchar value in datastage
Replies: 3
Views: 2530

It's not urgent. If it were urgent you would have signed up for priority service with your support provider, and learned the true cost of "urgent". DSXchange is an all-volunteer site whose members post if and when they can. If the (table definition) importer brings in a particular data ty...
by ray.wurlod
Sat Mar 26, 2011 4:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Arithmetic overflow into SQl server bulk loader
Replies: 4
Views: 2356

Perhaps the SQL Server loader stage checks the range of unsigned integers as if they were signed, and the ODBC stage doesn't. This is one for your official support provider - that was just a guess on my part. Of course, your job design could ensure that out of range values never reach the stage in t...
by ray.wurlod
Sat Mar 26, 2011 4:41 pm
Forum: General
Topic: Not able to login to DataStage 7.5.2
Replies: 6
Views: 3617

Make sure there's an entry for 127.0.0.1 in your hosts file (or try logging on to 127.0.0.1).