Search found 14 matches
- Tue May 23, 2006 7:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe - Impact of adding additional columns to table
- Replies: 5
- Views: 2060
Universe - Impact of adding additional columns to table
Several project teams are extracting data from the same Universe tables currently in production. One of the teams is proposing to add columns to Universe tables being utilized by other systems(datastage jobs). Within Oracle, the metadata for the systems not using the 'new columns' would not have to ...
- Wed Sep 07, 2005 10:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle_Express_Load
- Replies: 3
- Views: 2036
Bulk Loader options ???
What is the best method for performing bulk loads into Oracle ??
- Wed Sep 07, 2005 7:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle_Express_Load
- Replies: 3
- Views: 2036
Oracle_Express_Load
Where are the Oracle Database UserID Password Schema entered
in the Oracle_Express_Load stage ? Upon reading the help, it refers
to DataBase name (which I'm assuming is the Oracle load), but does not
refer to the entries for UserID Password Schema .
in the Oracle_Express_Load stage ? Upon reading the help, it refers
to DataBase name (which I'm assuming is the Oracle load), but does not
refer to the entries for UserID Password Schema .
- Fri Aug 26, 2005 8:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: When doing lookup, NOTFOUND constraint does not work.
- Replies: 4
- Views: 3722
When doing lookup, NOTFOUND constraint does not work.
Oracle | 98hits Oracle>>>>Transformer>>>>>>flatfile 100 0 Job performs oracle extract (100 rows), transformer performs single key lookup into another oracle table (gets hits 98 times) , the transformer has a link.NOTFOUND constraint, which means it should continue to the target for 2 rows. The probl...
- Mon Jul 11, 2005 2:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot Stage - Column identifier loaded as data in target
- Replies: 1
- Views: 1304
Pivot Stage - Column identifier loaded as data in target
If a pivot stage inputs a single row containing Jan, Feb, Mar, thru Dec sales data, is it possible to include month column identifier in final target with the corresponding sales amount. Input: Sales Key, JanAmt, FebAmt, MarAmt, DecAmt Output: Sales Key, "Jan", JanAmt Sales Key, "Feb&...
- Fri Jun 03, 2005 11:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Command Stage
- Replies: 2
- Views: 1245
Command Stage
Situtation: Within Oracle date field, when date is todays date then process sequence, otherwise wait 10 minutes and repeat cycle. Need design opinions.
- Wed May 25, 2005 12:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading char date into OCI9 Date datatype (not timestamp)
- Replies: 14
- Views: 7035
Re: further info
It appears that the only method for loading is into a timestamp. I don't believe it's possible to load only the date. The OCI9 stage always attempts to load the DATE as TO_DATE(:4, 'YYYY-MM-DD HH24:MI:SS'), which is not a DATE field, but is really a TIMESTAMP. No, a TIMESTAMP is a completely differ...
- Wed May 25, 2005 8:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading char date into OCI9 Date datatype (not timestamp)
- Replies: 14
- Views: 7035
further info
It appears that the only method for loading is into a timestamp. I don't believe it's possible to load only the date. The OCI9 stage always attempts to load the DATE as TO_DATE(:4, 'YYYY-MM-DD HH24:MI:SS'), which is not a DATE field, but is really a TIMESTAMP. As previously stated, I'm getting error...
- Wed May 25, 2005 8:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading char date into OCI9 Date datatype (not timestamp)
- Replies: 14
- Views: 7035
More help required
installed code: oconv(iconv(NewDate, "D-DMY"),"D-YMD[4,2,2]")
I'm still getting error: Value treated as NULL
Attempt to convert String value "2002-12-01" to Date type unsuccessful
Target field is Date - length of 10
I'm still getting error: Value treated as NULL
Attempt to convert String value "2002-12-01" to Date type unsuccessful
Target field is Date - length of 10
- Tue May 24, 2005 9:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading char date into OCI9 Date datatype (not timestamp)
- Replies: 14
- Views: 7035
Loading char date into OCI9 Date datatype (not timestamp)
Does anyone know exactly what to code to load a char date into OCI9 datatype. I'm getting the following error:
Attempt to convert String value "12/01/2002" to Date type unsuccessful
Attempt to convert String value "12/01/2002" to Date type unsuccessful
- Thu May 05, 2005 8:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: LONG to VARCHAR conversion
- Replies: 3
- Views: 3107
Good advice - Problem closed
Your answers were right on. Thanks
- Thu May 05, 2005 7:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: LONG to VARCHAR conversion
- Replies: 3
- Views: 3107
LONG to VARCHAR conversion
Created Oracle table with single column, datatype is long. Imported metadata in manager. Created oci stage, used builder to build sql and columns. Getting the following error: CopyOfZPILOT_ORCL_TO_FLAT_PartialRun..Oracle_OCI_112: OCI has fetched truncated data CopyOfZPILOT_ORCL_TO_FLAT_PartialRun..O...
- Mon Apr 25, 2005 7:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data not current - end process
- Replies: 4
- Views: 2028
- Mon Apr 25, 2005 6:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data not current - end process
- Replies: 4
- Views: 2028
Data not current - end process
File is received from external server, now check date on file to determine if current. If data not current, how do you quit current job and current sequence.