IBM AS400 AllOther (736) write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Field Name="SALARY")
6 20600How can we find from which source the program has been compiled for a given RPGLE program object?
5 15499what is the correct about QTEMP library(below mention)? a.it is Unique to a job b.it can be shared between different job c.it can only be deleted by QSECOFR d.Non Please give me the answer for this?
8 13228An rpg program is processing an openquery file.The file is declared in update mode in F spec.Can we update this file? Please explain?
3 13205A phisical file has two fields like 1) Account No(10,0) 2)Phone No(15,0)Unique on both fields?Please give me the answer for this?
3 7668What would be the output of the variable result? D RESULT S 5S O INZ(00011) C EVAL RESULT = %TRIM(RESULT) Please give me the correct answer for this A.0001 b.compile time error c.11 d.Runtime error
5 8221Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
2519You have a *USE authority on a Library and *All authority on a file in that Library.Can you change the data in that file?
1 5340I have a RPG program of 100 Lines and first line is to SETON indicator LR. Will the program execute rest of the 99 Lines?
6 15738How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?
8 23494I have some doubts on subfile----------- -----I wrote a prog on subfile to display the records. Every thing is clear but i defined a field called "opt" as input field in subfile record format from that input field i wish to enter into new screen called "EDIT" which i created it as a separate RCD in display file. i gave opt as 2 for edit just like in WRKMBRPDM screen please telll me the code and how can i code for it in RPG.
3 7086
What is redefine?
what is xfoot opcode ?
Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?
how to read database records without locking them?
how does the rpg element work?
what is *inzsr used for?
define a shared access path?
what opcode will be used to test the zone of a character field?
the maximum number of subfiles that can defined in a rpg program for one display file is ___ .
how many files can be defined in f specs?
what is arrival sequence?
define data structure?
What is the purpose of record level identifier?
can you specify a display file to be used in the following modes input,output, or combined modes ?
What is program status data structure(psds) in as400?