sqlstmt.len = sprintf( sqlstmt.arr, "INSERT INTO %s (USAGE_EVENT_ID, USAGE_TYPE_ID, ACCOUNT_ID) VALUES ( :1,:2,:3)", table_name );
EXEC SQL AT :CONN_JF PREPARE S FROM :sqlstmt;
EXEC SQL AT :CONN_JF FOR :tcnt EXECUTE S USING :lvUsageEvents;SQL语句中:1 :2 :3都是什么意思,他跟后面的execute using后面的变量有关系么 这些语句怎么解释?
EXEC SQL AT :CONN_JF PREPARE S FROM :sqlstmt;
EXEC SQL AT :CONN_JF FOR :tcnt EXECUTE S USING :lvUsageEvents;SQL语句中:1 :2 :3都是什么意思,他跟后面的execute using后面的变量有关系么 这些语句怎么解释?
关于动态SQL的用法,这里有个总结的比较好的http://www.docin.com/p-34554901.html#