Search This Blog

AS400

AS400 Technical Blog

SQL: Query to get the server Name in AS400

Get link
Facebook
X
Pinterest
Email
Other Apps

- February 19, 2020

Current Server will give the server name of the as400 in which the query runs

select current server from sysibm/sysdummy1

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

AS400 : Add a new line in text in email SNDSMTPEMM

- January 11, 2018

Declare ** NAMED CONSTANTS FOR CARRIAGE RETURN Which will move the control to next line D CR C CONST(X'0D') //0->Zero D vSepj S 1 Inz('/') D vQot S 1 INZ('''') DRunCommand PR extpgm('QCMDEXC') D pCommand 2560 const ...

AS400 RPGLE: CLEAR - To clear variable, Record Format and Array

- January 06, 2021

CLEAR is used to clear a variable by setting the value to its default value based on the variable type. Character filed to blanks Numeric field to 0 CLEAR will set the indicator to 0 (OFF) CLEAR will clear the whole record format to default values CLEAR can clear entire array or just the instance of an array if the instance/Index is specified

AS400 Display File: Check Box (MLTCHCFLD)

- July 09, 2017

Check box can be added to the AS400 Display using the Multi Choice Field. Each Choice in the MLTCHCFLD should have a Choice control defined as below. These Choice Control can be used in the Program logic. A MOPT 2Y 0B 3 58MLTCHCFLD A CHOICE(1 'Shipment') A CHOICE(2 'Transfer') A CHOICE(3 'Ship to ') A ...