dynamobi/dynamobi — Issue #125: [LDB-197] New UDP for conditional execution of SQL statement based on ZERO rows in input cursor
Author: dynamobi-build
Created: 2011-12-30 02:15:03+00:00
State: open
Labels: Applib, LDB

[reporter="ngoodman", created="Tue, 8 Sep 2009 20:34:39 -0500 (GMT-05:00)"]
original email posting:

http://n2.nabble.com/Conditional-schema-table-creation-tt3603890.html#a3603890

Create a new UDP that takes two inputs:

cursor << input rows >>

sql <>

To enable the syntax specified in the posting

call applib.exec_sql_if_cursor_empty(

cursor(SELECT * FROM SYS_ROOT.DBA_SCHEMAS WHERE SCHEMA_NAME ='FRED')

"CREATE SCHEMA 'FRED'"

);

If there are rows present in original do the SQL.