Skip to content
| Marketplace
Sign in
Visual Studio Code>Snippets>IBM i code SnippetsNew to Visual Studio Code? Get it now.
IBM i code Snippets

IBM i code Snippets

Zerobit

|
897 installs
| (0) | Free
code snippets for IBM i languages like RPG RPGLE CL CLLE SQL
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

i-snippets README

VS code snippets for IBM i based languages like

  • RPGLE
  • RPG
  • CL
  • CLLE
  • SQL

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!

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft