Search found 53125 matches

by ray.wurlod
Thu Aug 16, 2012 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Does IBM support server jobs with IS 8.7 version officially
Replies: 5
Views: 1614

No. And in many cases you don't need to.
by ray.wurlod
Thu Aug 16, 2012 3:08 pm
Forum: General
Topic: Is there a way for us to name the DSJOBREPORT file?
Replies: 8
Views: 2248

Use the supplied after-job subroutine ExecSH to execute your mv command.
by ray.wurlod
Wed Aug 15, 2012 11:35 pm
Forum: General
Topic: IOD 2012
Replies: 15
Views: 6129

I suspect that's tighter integration of Data Rules.
by ray.wurlod
Wed Aug 15, 2012 11:33 pm
Forum: General
Topic: Is there a way for us to name the DSJOBREPORT file?
Replies: 8
Views: 2248

Within the after-job subroutine if you wish. The file is closed before this is executed.
by ray.wurlod
Wed Aug 15, 2012 11:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_STRING_PADCHAR
Replies: 5
Views: 3098

You can assign "z" directly to APT_STRING_PADCHAR.
by ray.wurlod
Wed Aug 15, 2012 3:05 pm
Forum: General
Topic: Link?
Replies: 0
Views: 655

Link?

200 years ago today Detroit fell to the British in their war with the US. If that hadn't happened, Canada may not have come into existence.
150 years later (16 Aug 1962) Pete Best was kicked out of the Beatles.
Is there any link between these two events?
by ray.wurlod
Wed Aug 15, 2012 3:02 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Bad Request Error when calling a Web Service through WST
Replies: 10
Views: 9177

Ernie's recollection is correct. I'm no longer at that site so will have to dig through my notes to post more. It'll be a couple of days before I can do that - I'm at a UniVerse conference at the moment.
by ray.wurlod
Wed Aug 15, 2012 3:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Upsert mode in Oracle
Replies: 2
Views: 1374

Upsert does one of two things. 1. It attempts to UPDATE and, if that fails because the record does not exist, it performs an INSERT. 2. It attempts to INSERT and, if that fails because the record already exists, it performs an UPDATE. Which of these occurs depends on the setting of an additional pro...
by ray.wurlod
Wed Aug 15, 2012 2:58 pm
Forum: General
Topic: Is there a way for us to name the DSJOBREPORT file?
Replies: 8
Views: 2248

No, but you can rename the report immediately it has been created.
by ray.wurlod
Wed Aug 15, 2012 2:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Set row "create_date" and "last_update_date&q
Replies: 5
Views: 2527

Welcome aboard.
You can perform a lookup to determine whether the key already exists and thereby determine the derivation for create date or update date.
by ray.wurlod
Wed Aug 15, 2012 2:55 pm
Forum: General
Topic: DataStage 8.1 Client Install issue
Replies: 1
Views: 1117

What's different about that laptop? In particular check what DLLs exist.
by ray.wurlod
Wed Aug 15, 2012 2:52 pm
Forum: General
Topic: Pass date parameter
Replies: 12
Views: 5549

I suspect it needs to be quoted.

Code: Select all

WHERE UpdateDateTime > '#p_MaxDate#'
by ray.wurlod
Wed Aug 15, 2012 2:51 pm
Forum: General
Topic: Facing Error while Login into DataSTage 8.5
Replies: 3
Views: 1486

Windows 7 is not a supported operating system (except for client). Install on Windows Server 2008 R2.
by ray.wurlod
Tue Aug 14, 2012 6:23 pm
Forum: General
Topic: Pass date parameter
Replies: 12
Views: 5549

You've passed the parameter inappropriately into SQL, for example in a WHERE clause where a column name is expected.
by ray.wurlod
Tue Aug 14, 2012 3:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_STRING_PADCHAR
Replies: 5
Views: 3098

More specifically, APT_STRING_PADCHAR only applies the CHAR data types. It does not apply to Integer or VarChar data types.