VS code snippets for IBM i based languages like
- RPGLE
- RPG
- CL
- CLLE
- SQL
| Scope | Description | Trigger |
|---|---|---|
| rpg,rpgle,sqlrpgle | Basic template from RPG FREE program | rpgle template |
| rpg,rpgle,sqlrpgle | Basic template from RPG FREE program | rpgle hello world |
| rpg,rpgle,sqlrpgle | Declare a standalone zoned variable | dcl-s zoned,declare zoned |
| rpg,rpgle,sqlrpgle | Declare a standalone packed variable | dlc-s packed,declare packed |
| rpg,rpgle,sqlrpgle | Declare a standalone integer variable | dcl-s int,declare int |
| rpg,rpgle,sqlrpgle | Declare a standalone unsigned integer variable | dcl-s uns,declare unsigned int |
| rpg,rpgle,sqlrpgle | Declare a standalone float variable | dcl-s float,declare float |
| rpg,rpgle,sqlrpgle | Declare a standalone char variable | dcl-s char,declare char |
| rpg,rpgle,sqlrpgle | Declare a standalone SQLTYPE CLOB variable | dcl-s clob,declare clob |
| rpg,rpgle,sqlrpgle | Declare a standalone date variable | dcl-s date,declare date |
| rpg,rpgle,sqlrpgle | Declare a standalone date (date format iso) variable | dcl-s iso date,declare iso date |
| rpg,rpgle,sqlrpgle | Declare a standalone date (date format usa) variable | dcl-s usa date,declare usa date |
| rpg,rpgle,sqlrpgle | Declare a standalone Indicator variable | dcl-s ind,declare indicator |
| rpg,rpgle,sqlrpgle | Declare a standalone pointer | dcl-s pointer,declare pointer |
| rpg,rpgle,sqlrpgle | Declare a standalone Char array | dcl-s array,declare array |
| rpg,rpgle,sqlrpgle | Declare a data structure array | dcl-s ds,declare data structure |
| rpg,rpgle,sqlrpgle | Declare a standalone Char array | dcl-ds external ds,declare external data structure |
| rpg,rpgle,sqlrpgle | Declare constant | dcl-c const,declare constant free |
| rpg,rpgle,sqlrpgle | RPGLE If block | if |
| rpg,rpgle,sqlrpgle | RPGLE Do while loop | dow |
| rpg,rpgle,sqlrpgle | RPGLE Do until loop | dou |
| rpg,rpgle,sqlrpgle | RPGLE For loop | for |
| rpg,rpgle,sqlrpgle | RPGLE Select statement | select |
| rpg,rpgle,sqlrpgle | RPGLE Define QCMDEXE prototype | qcmdexe prototype |
| rpg,rpgle,sqlrpgle | RPGLE Define SYSTEM prototype | system prototype |
| rpg,rpgle,sqlrpgle | RPGLE Define subroutine | begsr |
| rpg,rpgle,sqlrpgle | RPGLE Define monitor Block | monitor |
| rpg,rpgle,sqlrpgle | RPGLE Get current date | today,current date |
| rpg,rpgle,sqlrpgle | RPGLE Get current time | now,current time |
| rpg,rpgle,sqlrpgle | RPGLE Cast char to decimal | %dec,char to dec |
| rpg,rpgle,sqlrpgle | RPGLE Cast date to decimal | %date,char to date |
| rpg,rpgle,sqlrpgle | RPGLE API Error structure ApiErrC | ApiErrC,Api Error |
| rpg,rpgle,sqlrpgle | RPGLE [All Params]QRCVDTAQ Receive data Queue entry | QRCVDTAQ,dcl-pr QRCVDTAQ |
| rpg,rpgle,sqlrpgle | RPGLE [Basic Params]QRCVDTAQ Receive data Queue entry | QRCVDTAQ,dcl-pr QRCVDTAQ |
| rpg,rpgle,sqlrpgle | RPGLE [All Parms]QSNDDTAQ Send entry to data Queue | QSNDDTAQ,dcl-pr QSNDDTAQ |
| rpg,rpgle,sqlrpgle | RPGLE [Basic Parms]QSNDDTAQ Send entry to data Queue | QSNDDTAQ,dcl-pr QSNDDTAQ |
| sqlrpgle | SQLRPGLE [Basic Parms]QSYS2.SEND_DATA_QUEUE | SEND_DATA_QUEUE,SEND DATA QUEUE |
| sqlrpgle | SQLRPGLE [ALL Parms]QSYS2.SEND_DATA_QUEUE | SEND_DATA_QUEUE,SEND DATA QUEUE |
| sqlrpgle | SQLRPGLE [Basic Parms]QSYS2.RECEIVE_DATA_QUEUE | RECEIVE_DATA_QUEUE,RECEIVE DATA QUEUE |
| sqlrpgle | SQLRPGLE [ALL Parms]QSYS2.RECEIVE_DATA_QUEUE | RECEIVE_DATA_QUEUE,RECEIVE DATA QUEUE |
| rpg,rpgle,sqlrpgle | RPGLE Declare a dataarea | dcl-s dtaara,declare dataarea |
| rpg,rpgle,sqlrpgle | RPGLE Read dataarea | in *lock,Read dataarea |
| rpg,rpgle,sqlrpgle | RPGLE Write dataarea | out,Write dataarea |
| sqlrpgle | SQLRPGLE SQL select statement | Exec SQL select |
| sqlrpgle | SQLRPGLE SQL update statement | Exec SQL update |
| sqlrpgle | SQLRPGLE SQL cursor | Exec SQL DECLARE cursor |
| sqlrpgle | SQLRPGLE SQL update statement | Exec SQL set option |
| sql, sqltab | Create table template | create table |
| sql | Create external procedure template | create external procedure |
| sql | Create procedure template | create procedure |
| sql | Create external function template | create external function |
| sql | Create function template | create function |
| sql | Create view template | create view |
| sql, sqltab, sqlind,sqlinx | Create index template | create index |
Code for IBM i
Initial release of containg snippets for RPGLE FREE and SQL.
Minor update
Readme update
Minor update
Restructure triggers
Enjoy!