If you are unable to create a new account, please email support@bspsoftware.com

 

Data Manager - using SQL Node to create a view?

Started by McFish, 14 Apr 2009 12:48:20 PM

Previous topic - Next topic

McFish

I'm adding on to an existing ETL job that drops a few tables and reloads them with the latest data.  Unfortunately I can't touch that and in Informix, any associated views automatically get dropped.  What I'd like to do is create an SQL Node within DM to either create the view or call a procedure (within Informix) to recreate the views.  However, I keep getting an error whenever I try to exec even a simple procedure or use the "create view 'informix'.test_proc_v" statement.  The error is:

'PrepareSelect' returned with 1 message
1. ERROR
DS-DBMS-E400: UDA driver reported the following on connection 'D_ifx-dwhdbnet_records':

<Message Name="CCLMessage" File="udamsgs" Severity="Error" Nesting="1" ><MessageComponents  ID="0xffffffb7" ><MessageParms><MessageParm Name="CCLMessageParm" Type="string" Value="prepare" /></MessageParms></MessageComponents></Message>


I've checked my connection and it has all of the privileges required so I'm at a loss.  Is this even a good way to go about recreating the views?

Edited: I figured out what my problem was concerning the error, I was trying to test it like a query and not run it like an executable.  However, I'm still interested if there is a better way of doing this?