Search found 53125 matches

by ray.wurlod
Wed Sep 25, 2013 12:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row Generator stage in 9.1
Replies: 5
Views: 2486

The Limit property is not a date. It is a number of days since the beginning of your chosen epoch. Try (for example) using an Epoch of 1990-01-01 and a Limit of 20000.
by ray.wurlod
Wed Sep 25, 2013 12:34 pm
Forum: IBM QualityStage
Topic: Removing a word from the name
Replies: 6
Views: 3932

Continuing that theme, you could also parse it into the AdditionalName field.
by ray.wurlod
Tue Sep 24, 2013 1:48 pm
Forum: General
Topic: Process Condition by Date
Replies: 2
Views: 731

Welcome aboard.

It may be easier to use an Execute Command activity to read the first line of the file (head -1 filename command), extract the date, and effect whatever comparison is needed in a trigger expression in that activity.
by ray.wurlod
Tue Sep 24, 2013 12:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connector Before SQL not deleting records
Replies: 8
Views: 6812

What error/warning messages appeared in the job log?
by ray.wurlod
Tue Sep 24, 2013 12:24 am
Forum: General
Topic: DSU.UTLGetLinkCount
Replies: 2
Views: 1078

You have failed to import your UTLGetLinkCount routine, or you have not compiled this routine.
by ray.wurlod
Tue Sep 24, 2013 12:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage connection with DB2 v2 for OS/2
Replies: 5
Views: 4708

Usually by asking the DBA nicely.
by ray.wurlod
Tue Sep 24, 2013 12:19 am
Forum: General
Topic: Sequence Jobs - Errors and Questions
Replies: 5
Views: 2475

The fact that you can't find it may itself be the problem. Was the job imported from somewhere else, where that routine does exist?
by ray.wurlod
Mon Sep 23, 2013 11:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Downcast numeric field without warnings
Replies: 4
Views: 1875

Add handling of this warning to the project-level default message handler in production. Or cause this to be done. "Make it so."
by ray.wurlod
Mon Sep 23, 2013 10:56 am
Forum: General
Topic: ERROR: Failed to open project
Replies: 6
Views: 2344

Identifiers such as project names and job names are case sensitive, even though you're on a Windows platform. Check that you have spelled and cased all identifiers correctly.
by ray.wurlod
Sat Sep 21, 2013 11:02 am
Forum: General
Topic: ERROR: Failed to open project
Replies: 6
Views: 2344

Try a search for the DS RPC error 80011.
by ray.wurlod
Sat Sep 21, 2013 11:00 am
Forum: General
Topic: Operations Database
Replies: 1
Views: 962

Yes, the jobs will run OK even if logging to DSODB is not working (this is handled by agent processes). Whether or not you want to set up DSODB for failover is a decision only you can make based on your particular needs. If you do, set up a cluster in the same way you did for XMETA.
by ray.wurlod
Fri Sep 20, 2013 2:07 am
Forum: General
Topic: dsjob -run command clarification
Replies: 3
Views: 1488

You need to incorporate logic to detect whether the job needs to be reset, and only reset it if that is the case.
by ray.wurlod
Thu Sep 19, 2013 6:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Event info
Replies: 2
Views: 873

Probably, if you can redirect the event info (whatever it is you mean by this) onto stdout as part of the SQL.
by ray.wurlod
Thu Sep 19, 2013 6:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data validation issue in DS 9.1 environment
Replies: 2
Views: 1463

What else is different? For example, how is APT_STRING_PADCHAR set in each environment?
by ray.wurlod
Thu Sep 19, 2013 6:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Usage of Hashed File Stage
Replies: 10
Views: 5717

Report to us all the property settings in the Hashed File stage. Beware, too, that names are case sensitive.