AS400 to IBM i

Why do some SQL results show pointer?

Why do some SQL results show pointer? Almost all of us have encountered this situation once in their life time that we are querying some table on I…

AS400 Interview Questions and Answers part 36 Q1: What is the difference between CHAIN and SETLL? Is there a performance advantage? Answer: The…

AS400 Interview Questions and Answers part 35 Q1:What keyword is used when screen is re-display? Answer: RSTDSP is a parameter to be specified a…

AS400 Interview Questions and Answers part 34 Q1:Which is the built in function to convert numeric field to alpha field? Answer: %EDITC, %EDITW…

AS400 Interview Questions and Answers part 33 Q1:The qualified name for an object TESTPF residing in a library QGPL is? Answer: QGPL/TESTPF. …

AS400 Interview Questions and Answers part 32 Q1:Which are the relational operators in RPG? Answer: GT, GE, LT, LE and EQ. Q2:Difference betw…

AS400 Interview Questions and Answers part 31 Q1:If your workstation does not show login screen what might be the problem? Answer: Problem with …

AS400 Interview Questions and Answers part 30 Q1:When would the ALL keyword be used? Answer: Used with Select and Omit to select/omit records. …

AS400 Interview Questions and Answers part 29 Q1:What is DDM? Answer: Distributed Data Management is a function of the OS/400 that allows an app…

AS400 Interview Questions and Answers part 28 Q1:What are the necessary keywords for the join logical file? Answer: JDFTVAL, JFILE, JOIN, JFLD,…

AS400 Interview Questions and Answers part 27 Q1:What is the CL command to access Query/400? Answer: WRKQRY. Q2:What is the purpose of Overr…

AS400 Interview Questions and Answers part 26 Q1:What is the use of SFLRNA keyword? Answer: Make subfile record format inactive. Q2:How can y…

AS400 Interview Questions and Answers part 25 Q1:Name the debugging commands? Answer: STRDBG and STRISDB. Q2:What is RCVF command in CL? An…

AS400 Interview Questions and Answers part 24 Q1:What is shared access path? Answer: An access path describes how records in a database file ar…

Getting Job information using SQL The JOB_INFO table function returns one row for each job meeting the selection criteria.It gives us information …

How to read data from IFS file using SQL? We have the stream files available in the IFS(Integrated File System) on IBM i and there are different w…

*CAT, *BCAT, *TCAT in CL *CAT (concatenation, symbol ||) operator The *CAT operator concatenates two character strings. Blanks are also include…

CL command for Timestamp Sometimes there were the need of fetching the current system timestamp in the CLLE program. So, the question here is that …

Passing Variable Length fields between RPG and CL RPG IV program or procedures supports the variable length fields(using the VARYING keyword), howe…

Run SQL Scripts - unreadable characters as hexadecimal Here, In this article we will discuss about the most common issue that we all usually face …