Search found 53125 matches
- Thu Jan 12, 2006 4:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Job aborted Notification
- Replies: 8
- Views: 3758
Basically you are not making use of the functionality that is provided. You can use a Routine activity to log a warning in the controlling job sequence; the Routine activity being triggered by detection of a failure (that is, a conditional trigger in the Job activity). You can also use the Exception...
- Thu Jan 12, 2006 4:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find table name in group of jobs in Datastage
- Replies: 2
- Views: 2043
- Thu Jan 12, 2006 4:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error with succesfull Completion
- Replies: 10
- Views: 3381
- Thu Jan 12, 2006 4:41 pm
- Forum:
- Topic: Where does Metastage look for metadata in Datastage?
- Replies: 3
- Views: 1812
Welcome aboard! :D You can create your own table definitions but, in order for MetaStage to gather data for lineage analysis, you must be disciplined about it. Any table definitions must first be created in the Repository (whether manually or via an Import mechanism). Column definitions in job desig...
- Thu Jan 12, 2006 3:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Warings msgs for Update Or insert type in ODBC Stage
- Replies: 8
- Views: 2018
When a database server generates any message (in this case "2 rows affected") DataStage logs it. This is the DataStage philosophy, on which I've posted at length before - search for "philosophy". The only possible way to suppress these messages is to cause the database (or ODBC driver) not to genera...
- Thu Jan 12, 2006 3:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Convert date to Julain date format in datastage
- Replies: 1
- Views: 2259
Julian means different things to different people. The conversion functions (Iconv() and OConv()) use "ordinal day within the year". If that's what you want use (or use "D/YJ" to get year first.
Code: Select all
Oconv(Iconv(InLink.TheDate, "DMDY"), "D/JY")- Thu Jan 12, 2006 3:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot Stage Performance
- Replies: 3
- Views: 1459
How about ----> IPC ---- ...TX ---+ +---> LC ---> IPC ---> TX ---> .... ----> IPC ---- Or, assuming that the results are going to a table ---> TX2A ---> .... ...T1X ---+ ---> TX2B ---> .... The two Transformer stages TX2A and TX2B perform identical processing (apart from the negative sign) and const...
- Wed Jan 11, 2006 11:08 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Aborts
- Replies: 14
- Views: 3792
- Wed Jan 11, 2006 11:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Default warnings limit in the Designer
- Replies: 10
- Views: 2321
The default default (ibid?) on version 7.0 is 50. Just checked. I'll have to wait till I get to a 7.5 system to verify your assertion. As to where it's set elsewhere, it wouldn't be a Registry hack if it were going to control dsjob - which can be, and usually is, executed on the server. Most of my s...
- Wed Jan 11, 2006 10:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Authentication Failure
- Replies: 5
- Views: 1503
- Wed Jan 11, 2006 10:41 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Aborts
- Replies: 14
- Views: 3792
Each "Done" message from DSD.RUN indicates a run of a server job. In your case everything appears to have worked (there are no warning messages). Your loop runs job Load_GGSN then runs job Load_SGSN. Does your job design trap exceptions (via an Exception Handler) or non-success triggers from the con...
- Wed Jan 11, 2006 8:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Authentication Failure
- Replies: 5
- Views: 1503
- Wed Jan 11, 2006 8:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequencer Aborts
- Replies: 14
- Views: 3792
- Wed Jan 11, 2006 8:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsintbuf_getrow() - row has N columns when N expected
- Replies: 3
- Views: 1760
Welcome aboard. :D Jim's answer is correct. There seems to be a bug in the metadata handling when buffering is enabled, whether explicitly or implicitly. An intermediate sequential file defeats the purpose of buffering by forcing data to be touched down to disk (at "disk speed" rather than at "memor...
- Wed Jan 11, 2006 6:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage 7.1 vs 7.5
- Replies: 9
- Views: 2981