Search found 34 matches

by pnpmarques
Thu Oct 22, 2009 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reject records=No Warning, so how to detect rejected
Replies: 3
Views: 1839

Reject records=No Warning, so how to detect rejected

Hello, I have a job that loads data with Oracle Enterprise Stage, Upsert mode. For some reason, like Foreign Key constraints or inserting Null into a Not Null column, I get rejected records, but it generates no warnings. It just shows a Info message: "ORA_TABLE,0: Records inserted: 0 Records us...
by pnpmarques
Wed Aug 19, 2009 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rnd function always returns the same value
Replies: 2
Views: 3310

Rnd function always returns the same value

Hello! I have created a Server Routine that has this single line: Ans=Rnd(1000) I tested this routine several times and it always generates a random number as expected. BUT when I execute this routine inside a Transformer stage, for each job execution I always get the same number (513), it's not gen...
by pnpmarques
Wed Jul 15, 2009 5:32 am
Forum: General
Topic: How to differentiate a Job from a Job Sequence in script
Replies: 22
Views: 13691

In DS8 you could try:
dssearch -ljobs -uses -oj <PROJECT> <JOB>
by pnpmarques
Wed Jun 15, 2005 10:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clickpack - Routine CPIPToDomain
Replies: 1
Views: 1392

Clickpack - Routine CPIPToDomain

Hello, I'm working with Clickpack to treat weblogs. I am trying to convert an IP adress to a domain using routine CPIPToDomain. The problem is that it doesn't do any conversion (Testing returns nothing, as well using it in a job). I'll try to give you more information hoping that it helps you to hel...