DSXchange

asorrell wrote:you left off the end to that statement Vincent...

...and those seven Windows-based customers are eternally grateful!

you poor bastards...lol

What Oracle Client have you got installed?
The Oracle Connector stage 'variant' property (10,11) determines what Oracle client to use. If the variant is set to 10 then it will expect Oracle 10 client libs.
If it's 11g then set the variant property is set to 11, it will use oracle 11g libs.

SURA wrote:While using SQL Server WRITE method "BIT" Data type wont support. You need to change it as INT in the input link to DB.

Is that with ODBC Connector?

I want to add the problem of "Cannot insert LONGVARCHAR data into Oracle function SDO_GEOMETRY" This is a known issue to IBM. The problem is of not being able to pump more than 4000 characters to a function that can accept LOB that is within an Insert statement. This problem has been ident...

I want to add the problem of "Cannot insert LONGVARCHAR data into Oracle function SDO_GEOMETRY" This is a known issue to IBM. The problem is of not being able to pump more than 4000 characters to a function that can accept LOB that is within an Insert statement. This problem has been ident...

Folks,

If anyone is interested, It has been found out that this is a limitation on DataStage.
IBM has advised me they will be looking at fixing this problem as an enhancement.

I'll keep you posted.

Jon

Major, No. Minor, yes. Workarounds, there is. In the end it's all about what you use. But I recommend using it (upgrading if you are an 8.1 user). It's always fun to fix issues :) Cheers. thanks for your commend, we're currently using 8.5 FP1. I'm working in the best interest of the customer which ...

My target is SQL Server and i used WRITE method along with Surrogate_Key_Generator stage made the job to fail / hang. But this is for Win OS. I suppose to raise a PMR for this issue. Workaround is make the SQL Server EE stage to run in sequential mode. Hence you are using unix, you might use ODBC a...

Hi Folks, I'm on a site which has a new Infosphere 8.5 installation. Before we embark on any development on this new platform i want know if there are any known issues up front instead of bumping into them along the away. So i can get these fixed or raised with the support people while they are stil...

Hi Folks, I'm trying to get an Oracle DATE data type into a DataStage Timestamp within Oracle connector stage. I'm on an 8.5 fixpack 1 system and I'm getting this error coming back from Oracle 11gR2 database. The OCI function OCIStmtFetch returned status -1. Error code: 1,861, Error message: ORA-018...

I haven't tried long VARCHAR2 in the oracle table.

LONGVARCHAR-> CLOB (column) works with 4000+ chars.

Just an update to my progress with this. The Oracle spatial function SDO_UTIL.FROM_WKTGEOMETRY() can accept either varchar2 or CLOB data types. I'm trying to use this function within an INSERT statement to populate the underlying SDO_GEOMETRY data type. The function accepts <= 4000 characters from a...

I'm using an Oracle Connector stage to input Well Known Text (spatial) into an Oracle column of data type SDO_GEOMETRY. I'm using the following insert statement:- INSERT INTO SPATIALTABLE (ROAD_CLOSURE_POLYLINE_ID, ROAD_CLOSURE_EVENT_ID, POLYLINE, POLYLINETEXT, LAST_UPDATE_DATE) VALUES (:ROAD_CLOSUR...

Hi Folks, I'm attempting to convert Microsoft SQL Server spatial data types Geometry and Geography to Oracle's SDO_GEOMETRY data type. I want to use the well known binary (WKB) / well known text (WKT) methods to convert from SQL Server and to Oracle spatial types. Has anyone written well known binar...

ray.wurlod wrote:You should be able to use a Modify stage and a string_from_ustring() conversion for each field in that stage. ...

thanks Ray.