Search found 36 matches

by SPA_BI
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

Using Oracle MDSYS.SDO_GEOMETRY data type in DataStage

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.
by SPA_BI
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?
by SPA_BI
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

When it Datastage version 8 going to be released anyway?
by SPA_BI
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
by SPA_BI
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...
by SPA_BI
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...