Synoptic table of instructions
All the instructions are presented here in alphabetical order:
Declaration
| Instruction | Source | Target | AS/400 IBMi | Other | Description |
|---|---|---|---|---|---|
| Field declaration | X | X | X | X | Field declaration |
| File declaration | X | X | X | File declaration |
Instructions
| Instruction | Source | Target | AS/400 IBMi | Other | Description |
|---|---|---|---|---|---|
| Call external program | X | X | X | X | Call program with standard parameters |
| Call external program | X | X | X | Call DotNet program | |
| Call external program | X | X | X | X | Call program with custom parameters |
| Close and Open the target flats files | X | X | Close target flats files (csv, xml and micro-batch) | ||
| Operations on alphanumeric fields | X | X | X | Concatenate | |
| Copy_I_To_O: Copy buffer I to buffer O | X | X | X | Copy buffer I to buffer O | |
| Tags and branches | X | X | X | X | Branch to a tag |
| Tests and branches | X | X | X | X | Compare |
| Operations on alphanumeric fields | X | X | X | String length | |
| SQL call (non AS/400 IBMi) | X | X | X | Call a query | |
| Operations on alphanumeric fields | X | X | X | Trim left blanks | |
| Field moves | X | X | X | X | Move bytes from left to right |
| Field moves | X | X | X | Move bytes from right to left | |
| Close and Open the target flats files | X | X | Re-open after close target flats files (csv, xml and micro-batch) | ||
| Option | X | X | X | X | Set an option |
| Reading files (AS/400 IBMi) | X | X | X | Read first record | |
| Reading files (AS/400 IBMi) | X | X | X | Read by key | |
| Reading files (AS/400 IBMi) | X | X | X | Read last record | |
| Reading files (AS/400 IBMi) | X | X | X | Read next record | |
| Reading files (AS/400 IBMi) | X | X | X | Read previous record | |
| Operations on alphanumeric fields | X | X | X | Trim right blanks | |
| Tests and branches | X | X | X | x | Search and branch |
| Start a process | X | X | X | Launch a process | |
| Start a process | X | X | X | Launch a process and wait until the end to continue | |
| SQL call (non AS/400 IBMi) | X | X | X | Run an SQL statement | |
| Operations on numeric fields | X | X | X | Convert numeric to alpha | |
| TRACE | X | X | X | X | Display a string in the log |
| Operations on alphanumeric fields | X | X | X | Trim left and right blanks | |
| Operations on alphanumeric fields | X | X | X | Convert alpha to numeric |