Search found 53125 matches

by ray.wurlod
Sat Feb 07, 2009 5:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance issues by using webservices
Replies: 2
Views: 854

That would depend on several factors, not least being who wrote the web service how efficiently, and how efficiently the service has been deployed, how efficiently that service queries the database, and how much other traffic there is on the web service machine, the database server machine and on th...
by ray.wurlod
Sat Feb 07, 2009 5:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regular expression in datastage
Replies: 2
Views: 2724

Sequential File stage. Use a Filter command, perhaps with grep, sed or awk. The stage then reads the output of the filter command.
by ray.wurlod
Fri Feb 06, 2009 6:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ulimit settings
Replies: 5
Views: 4370

In DataStage settings are inherited from dsrpcd for the agent process associated with each connected client.
by ray.wurlod
Fri Feb 06, 2009 6:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Premium Membership
Replies: 3
Views: 973

Looks like that particular problem is solved. You are showing up as Premium Member.

Please mark thread as Resolved.
by ray.wurlod
Fri Feb 06, 2009 6:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Deducting a second from a timestamp
Replies: 2
Views: 1080

Don't reinvent the wheel. Use a routine that already exists
by ray.wurlod
Fri Feb 06, 2009 3:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify
Replies: 9
Views: 2509

kittu.raja wrote:I am not using any warn specification
Would you like to try one?

It's the single word NOWARN as a separate Specification.

Still waiting for you to post your actual Specifications so we can check them to see if the problem might be there.
by ray.wurlod
Fri Feb 06, 2009 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Premium Membership
Replies: 3
Views: 973

Mail membershipdirector@dsxchange.com with a copy to editor@dsxchange.com

Maybe they're snowed in or something - hard to tell from here in an Australian summer!
by ray.wurlod
Fri Feb 06, 2009 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS/EE V8.0.1 Configuring parallel DB2 remote connectivity
Replies: 6
Views: 1339

Guessing on the first one - "same" may simply be satisfied by both machines being pSeries (and not, say, HP machines). "Same" may be satisfied by the version of AIX being 5.3. (Identical <> Same) As for the need for same location, this is because you only get one place to specify...
by ray.wurlod
Fri Feb 06, 2009 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract row wise data
Replies: 3
Views: 1181

Sequential File stage? Allow the header record to be rejected, since it does not match the metadata of a detail record. Pass the Reject link into a Column Import stage to re-parse the raw rejected record and capture the desired header information downstream of that.
by ray.wurlod
Fri Feb 06, 2009 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2_UDB_Enterprise - Warning- unable to chdir
Replies: 8
Views: 4257

Do you understand what that does?
by ray.wurlod
Fri Feb 06, 2009 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Are License keys platform specific?
Replies: 2
Views: 1072

That's actually for your own protection. The different operating systems have different system calls, therefore DataStage engine (which is effectively a virtual machine) needs to be different on different operating systems. The licence, among other things, makes sure you are on the correct one. It's...
by ray.wurlod
Fri Feb 06, 2009 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cannot understand the size of extended ascii characters
Replies: 2
Views: 1093

What if you specify nvarchar(35)?

Extended characters cover all Unicode code points, some of the character representations require more than one byte per character. This is the principal difference also between varchar and nvarchar data types.
by ray.wurlod
Fri Feb 06, 2009 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compilation error in job using SCD stage having dbsequence
Replies: 3
Views: 6492

Search DSXchange for The number of reject datasets "0" is less than the number of input datasets "1". Others have posted about this message.

Is your compiler licence valid (not expired)?