Search found 53125 matches

by ray.wurlod
Fri Apr 05, 2013 3:11 pm
Forum: General
Topic: Using parameters in DB2 Stage in DS 8.7
Replies: 11
Views: 5598

Try losing the semi-colon from your SQL statement. Also please post the actual error message that is generated.
by ray.wurlod
Fri Apr 05, 2013 3:09 pm
Forum: General
Topic: Not able to login to datastage
Replies: 1
Views: 1230

Has the password expired for the XMETA owner user?
by ray.wurlod
Fri Apr 05, 2013 3:06 pm
Forum: General
Topic: Sequence job
Replies: 1
Views: 1030

Are you using checkpoints in the master sequence? If so, and you want its first activity always to execute, then check the "do not checkpoint run" check box for that activity. Also, use "reset if required, then run" for the sub sequence.
by ray.wurlod
Fri Apr 05, 2013 3:04 pm
Forum: IBM QualityStage
Topic: Qualitystage Reference Match weights
Replies: 9
Views: 7374

I find it easier to explain scaled (multiplier) weight overrides to the business. An override greater than 1 adds influence for that column in the composite weight; an override less than 1 reduces that column's influence.
by ray.wurlod
Thu Apr 04, 2013 10:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Java Transformer Performance
Replies: 4
Views: 1313

Might be worth timing a call to Address Doctor in isolation. If this takes close to 1 second there's clearly nothing you can do about the throughput of the Java Transformer stage that makes the same call.
by ray.wurlod
Thu Apr 04, 2013 7:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata Variant
Replies: 4
Views: 2103

We have Teradata 14 and have not even contemplated using the lower variant.
by ray.wurlod
Thu Apr 04, 2013 7:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sql help
Replies: 6
Views: 2165

Generate a counter within each group and pass only those rows for which the counter value is less than or equal to 3.
by ray.wurlod
Thu Apr 04, 2013 7:04 pm
Forum: General
Topic: HOW TO GET THE DSN LIST IN DATASTAGE 8.5...
Replies: 4
Views: 2404

Therefore, to "get" the list, execute the UNIX command cat uvodbc.config in the project directory.
by ray.wurlod
Thu Apr 04, 2013 7:02 pm
Forum: General
Topic: DSN created in windows not appering in DS DSN drop down list
Replies: 6
Views: 1782

Will ck it, thx Moderator@ Plz move it to EE forum DSXchange is not an SMS device; there is no need whatsoever to resort to SMS-style abbreviations. These make life difficult for those whose first language is not English (and even for some of us whose first language IS English!). Please strive to u...
by ray.wurlod
Thu Apr 04, 2013 6:58 pm
Forum: General
Topic: UVTEMP Empty
Replies: 1
Views: 877

On Windows the default value for UVTEMP is the executing user's Temp folder.
by ray.wurlod
Wed Apr 03, 2013 8:16 pm
Forum: General
Topic: Reconstructing Deleted DataStage Project
Replies: 3
Views: 1269

Reconstructing Deleted DataStage Project

After a DataStage project directory was deleted at UNIX level, we were able to use SyncProject (part of ISALite) to reconstruct that project from the contents of XMETA, to the great relief of all involved.
by ray.wurlod
Wed Apr 03, 2013 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a Record based on a Pattern
Replies: 4
Views: 1264

Correct the arguments in your Field() function. For example everything after the second colon is given by

Code: Select all

Field(InLink.TheString, ":", 3, 999)
by ray.wurlod
Wed Apr 03, 2013 3:06 pm
Forum: General
Topic: not able to connect to db2 database
Replies: 1
Views: 1279

Not authorized to access database

Get yourself a user name/password that is authorised to access the database.
by ray.wurlod
Wed Apr 03, 2013 2:59 am
Forum: General
Topic: Routine C++ compiling issue
Replies: 11
Views: 4555

Is it legal to use setlocale() as an rvalue and as an lvalue?