This program produces the below spreadsheet. It writes XML to IFS which is then read automagically by excel as a spreadsheet. This example can be used to produce multi tabbed spreadsheets. These spreadsheets can contain any/all of the features in
Encrypting Data
Encrypting data using system API Required Parameter list for Qc3EncryptData Required Parameter Group: 1 Clear data Input Char(*) 2 Length of clear data Input Binary(4) 3 Clear data format name Input Char(8) 4 Algorithm description Input Char(*) 5 Algorithm description
Using QWCRSVAL to change password (QSYCHGPW)
The Retrieve System Values (QWCRSVAL) API lets you retrieve system values. This is for example use only — We do not recommend use of this program to bypass enterprise security policies. In this example system values that are associated with
Working examples of API’s
The term Application Programming Interface (API) can be applied in many instances. By definition, an API is an application-supplied program or procedure that allows an application program, which is written in a high-level language, to access specific data or functions
DATAQ
Data queues are a type of system object (type *DTAQ) that you can create and maintain using OS/400 commands and APIs. They provide a means of fast asynchronous communication between two jobs, or within the same job, because they use
Working with Data Areas
A data area can be used whenever you need to store information of limited size, independent of the existence of procedures or files. Typical uses of data areas are: To provide an area (perhaps within each job’s QTEMP library) to
Using SQL to retrieve system information
List system values that contain “SEC” in the name. Take some time and play with the SQL — Become famous Post new samples!!! SELECT SYSTEM_VALUE_NAME as sysvalue, ifnull(CURRENT_NUMERIC_VALUE,0) as DecValue, CURRENT_CHARACTER_VALUE as CharValue FROM SYSTEM_VALUE_INFO where SYSTEM_VALUE_NAME LIKE ‘%SEC%’ this