Search found 42189 matches
- Thu Jun 10, 2010 7:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning Concern -- masking of an error
- Replies: 3
- Views: 1679
- Thu Jun 10, 2010 7:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterpirse Stage - Records rejected without warning
- Replies: 11
- Views: 3873
- Thu Jun 10, 2010 7:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Nanosecond
- Replies: 5
- Views: 1886
- Thu Jun 10, 2010 4:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Nanosecond
- Replies: 5
- Views: 1886
I'm assuming you really mean microseconds rather than nanoseconds... yes?
- Thu Jun 10, 2010 4:36 pm
- Forum: General
- Topic: Parsing xml messages using datastage
- Replies: 4
- Views: 2789
- Thu Jun 10, 2010 8:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while loading data to DB2 table
- Replies: 8
- Views: 6613
Search. I'm assuming it looks for a more 'generic' name that is linked to the proper versioned file and I've seen that link creation fail (for whatever reason) during setup. Manually creating it gets you going again. My guess for the solution here based on personal experience with other databases. :...
- Thu Jun 10, 2010 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset
- Replies: 11
- Views: 2701
- Thu Jun 10, 2010 7:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while loading data to DB2 table
- Replies: 8
- Views: 6613
- Thu Jun 10, 2010 6:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reduce date by a day in job control
- Replies: 4
- Views: 1444
- Thu Jun 10, 2010 6:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic RDMS
- Replies: 3
- Views: 1065
Do those stages support user-defined DDL for table creation? If so, I would imagine that you could simply adjust the syntax to create a volatile / temp table. Not having used either of those, I have no clue what they can or cannot do. What about ODBC? Is that an option for you here? Those kind of ta...
- Thu Jun 10, 2010 6:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset
- Replies: 11
- Views: 2701
- Thu Jun 10, 2010 6:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reduce date by a day in job control
- Replies: 4
- Views: 1444
Perhaps just?
You could also simply use Convert() to remove any delimiters that OConv() added to the date rather than chopping it up and reassembling it.
Code: Select all
FILEDATE = DD : MM : YYYY- Thu Jun 10, 2010 6:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic RDMS
- Replies: 3
- Views: 1065
Welcome. The dropdown in the DRS stage will show you what databases are support. If there is no native support for your database of choice then you may be able to fall back to ODBC (which should be listed) as long as you have the ODBC drivers for your database. Me, I have no clue if ODBC based Terad...
- Thu Jun 10, 2010 5:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Upsert option
- Replies: 23
- Views: 11656
- Thu Jun 10, 2010 5:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Running only selected jobs in same template
- Replies: 5
- Views: 1471