1 2 3 4 5 6 7 8 9 10 11 12 | DATA: DBS TYPE DBCON-CON_NAME VALUE 'GSTAR_HR'. EXEC SQL. CONNECT转基因快速检测仪 TO :DBS ENDEXEC. IF SY-SUBRC = 0. MESSAGE '数据库连接成功' TYPE 'S'. ELSE. MESSAGE '数据库连接失败' TYPE 'S'. ENDIF. |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | DATA F1(12). EXEC SQL. OPEN C1 FOR SELECT TOP 5 EMPLOYEENO FROM PERSONAL ENDEXEC. DO. EXEC SQL. FETCH NEXT C1 INTO :F1 ENDEXEC. IF SY-SUBRC <> 0. EXIT. ENDIF. WRITE:/ F1. ENDDO. EXEC SQL. CLOSE C1 ENDEXEC. |
1 2 3 4 5 6 7 8 9 | DATA: D1(8), D2(10), D3(20), D4(20). EXEC SQL PERFORMING ProcessSQL. SELECT EMPLOYEENO, NAME, DEPART, TEAM FROM PERSONAL INTO :D1, :D2, :D3, :D4 ENDEXEC. FORM ProcessSQL. WRITE:/ D1, D2, D3, D4. ENDFORM. "ProcessSQL |
1 2 3 4 5 mss6 7 8 9 10 11 12 13 14 | DATA:BEGIN OF IT_TAB OCCURS 0, EMPLOYEENO(12), NAME(10), DEPART(20), TEAM(20), END OF IT_TAB.新药开发 EXEC SQL PERFORMING ProcessSQL. SELECT 知网EMPLOYEENO, NAME, DEPART, TEAM FROM PERSONAL INTO :IT_TAB-EMPLOYEENO, :IT_TAB-NAME, :IT_TAB-DEPART, :IT_TAB-TEAM ENDEXEC. 志愿者返乡被骂哭 FORM ProcessSQL. APPEND IT_TAB. ENDFORM. "ProcessSQL |
1 2 3 4 5 6 7 | DATA: O1 TYPE I. EXEC SQL. EXECUTE PROCEDURE web_Affiche_GetListCountTEST ( IN :'', OUT :O1 ) ENDEXEC. WRITE:/ O1. |
本文发布于:2024-09-20 18:28:16,感谢您对本站的认可!
本文链接:https://www.17tex.com/xueshu/717765.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
留言与评论(共有 0 条评论) |