GENERO 2.5语法

1、显示

DISPLAY 程序变量 TO 画面栏位
DISPLAY BY NAME 程序变量

2、录入

INPUT 程序变量 FROM 画面栏位
INPUT BY NAME 程序变量

3、查询

CONSTRUCT BY NAME char_variable ON column_list
CONSTRUCT char_variable ON column_list FROM field_list

4、prepare

PREPARE prepare_id FROM l_sql

5、scrolling cursor 和 FETCH

DECLARE cursor_id SCROLL CURSOR [WITH HOLD] FOR [sql_statement|prepared_id]
OPEN cursor_id [USING value]
FETCH [first|last|previous|next] cursor_id INTO variable
...
CLOSE cursor_id

6、NON-SCROLLING CURSOR

DECLARE cursor_id CORSOR [WITH HOLD] FOR prepared_id

7、FOREACH循环（只能用于non_scrolling cursor）

FOREACH cursor_id INTO 变量名称
...
END FOREACH

8、LOCKING CURSOR数据锁定的游标

DECLARE cursor_id CURSOR FOR prepare_id FOR UPDATE [NOWAIT]
OPEN cursor_id [USING value]
...
CLOSE cursor_id

9、EXECUTE

FUNCTION update_customer_name(key,name)
 DEFINE key INTEGER
 DEFINE name CHAR(10)

PREPARE s1 FROM 
 "UPDATE table_name SET  name=?",
 " WHERE num=?"
EXECUTE s1 USING name,key
FREE s1