Oninit cdi / Archive
Talk to an expert →

Unloading Table from Stored procedure called by Trigger

Posted in 2006

Topics: Stored Procedures & SPL, Triggers, Constraints & Referential Integrity, Migration, Import/Export & Data Conversion

spilker — — source: Usenet: comp.databases.informix

Good Morning, i have to unload a database table while processing a stored procedure called by a database trigger (table name is passed as parameter). However it seems that i can´t use dynamic sql statements within SPL code. Is there an easier way then writing C-UDR code with database access. Greetings, Jörg

↪ replying to spilker
tichman@excite.com — — source: Usenet: comp.databases.informix

I had a similar problem. Try using "SYSTEM" command which allows you to call a shell script from within the stored procedure. You can get the script to do the required unloads spilker wrote: > Good Morning, > > i have to unload a database table while processing a stored procedure > called by a database trigger (table name is passed as parameter). > However it seems that i can´t use dynamic sql statements within SPL > code. Is there an easier way then writing C-UDR code with database > access. > > Greetings, Jörg

↪ replying to spilker
Claus Samuelsen — — source: Usenet: comp.databases.informix

spilker wrote: > Good Morning, > > i have to unload a database table while processing a stored procedure > called by a database trigger (table name is passed as parameter). > However it seems that i can't use dynamic sql statements within SPL > code. Is there an easier way then writing C-UDR code with database > access. > > Greetings, J'rg > If you're using IDS 9 or 10, then take a look on the Exec bladelet http://iiug.org/software/archive/exec_sql_udr.htm Claus