DSXchange

chulett wrote:User-defined SQL should be one of the Update Actions in the stage. In my version (7.5.1A) it is the last one listed, just after 'Call stored procedure'.

Ah ha! Yes, indeed it is. I'll definitely give this a try before I do the View thing as this won't require any DBA work.

Thanks!

I did an experiment with User Defined SQL and it worked. (I tested it on SQL Server). My target table is like this create table Abc (a# int primary key,b# int,c# int) The Column names I used on the target link were a,b,c The User defined SQL I used INSERT INTO Northwind.dbo.Abc (a#,b#,c#) VALUES (?...

Thanks everyone for all the suggestions! We haven't tried implementing any change yet. I'll have to run some of these ideas past the other team members to see how we want to proceed. ray.wurlod I checked the Server Job Developer's Guide but didn't find anything about # as a column name. chulett This...

I was afraid of that.

Thanks for the response.

- Mark

We're new with DataStage so please bear with me. I'm setting up a server job and trying to write to an Oracle table using the ODBC stage. Everything was going good until I tried mapping (via Transformer stage) a value to an Oracle column containing a pound sign (PCLIN#E). When I loaded the table met...