i-snippets README
VS code snippets for IBM i based languages like
Available Snippets
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 |
Requirements
Code for IBM i
Release Notes
0.0.1
Initial release of containg snippets for RPGLE FREE and SQL.
0.0.2
Minor update
0.0.3
Readme update
0.0.4
Minor update
0.0.5
Restructure triggers
Enjoy!
| |