Does anyone know if it is possible to use the MDSYS.SDO_GEOMETRY data type in DataStage?
I'm carrying out spatial analysis and need to pass this data through DataStage. Any ideas?
Any help would be greatly appreciated.
Thank you.
Search found 36 matches
- Mon Nov 13, 2006 4:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using Oracle MDSYS.SDO_GEOMETRY data type in DataStage
- Replies: 2
- Views: 2025
- Tue Nov 07, 2006 10:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Bulk Loader using oracle 10g
- Replies: 4
- Views: 2144
Bulk Loader using oracle 10g
Currently I use an ORAOCI9 Stage to Update existing records and Insert new ones. I'd like to use a bulk loader to carry out this process as it currently takes a long time to load records. Is this possible?
Can anyone give me some suggestions?
Can anyone give me some suggestions?
- Wed Oct 25, 2006 5:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Upgrade to 8.0 for Server-only sites
- Replies: 5
- Views: 1440
- Tue Oct 24, 2006 11:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can I call C/C++ API from within datastage server?
- Replies: 1
- Views: 733
Can I call C/C++ API from within datastage server?
Hello,
We have these C/C++ APIs which does some extremely complex calculations to the input data and returns the desired result. We would like to be able to call these functions as part of our transformation. Is it possible to call C/C++ or Java APIs in a datastage server job (or routine)?
Thanks
We have these C/C++ APIs which does some extremely complex calculations to the input data and returns the desired result. We would like to be able to call these functions as part of our transformation. Is it possible to call C/C++ or Java APIs in a datastage server job (or routine)?
Thanks
- Tue Oct 24, 2006 1:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Function to Retrieve alphanumeric values
- Replies: 3
- Views: 1244
Function to Retrieve alphanumeric values
Hello Board, I have a field that I am trying to separate alpha from non-alpha data from. Below is the source and how it should separate. What makes this tricky is the different rules governing the extraction because of the inconsistency of the source field. 1)The number is either at the beginning, 2...
- Wed Sep 20, 2006 5:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence generator
- Replies: 10
- Views: 5109
The most efficient, if you want to start from 1 for each run, is to use the system variable @OUTROWNUM, since it is keeping that count in any case. However, if you want a genuine sequence (starting again from where it left off), then either the SDK key management routines as mentioned, or a databas...