IBM AS400 AllOther (736) write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Field Name="SALARY")
6 20820How can we find from which source the program has been compiled for a given RPGLE program object?
5 15684what 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 13463An 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 13314A 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 7777What 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 8386Please 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.
2564You 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 5445I 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 15954How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?
8 23725I 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 7214
http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?
Write a CL program which will run a batch job at 1 am every night
What is the interactive job? What is the batch job?
define a shared access path?
which of the cl command can be used to determine which logical files are dependent on a specific file?
how can a message from a message file appear as a constant on the screen?
explain the difference between defining subfile and message-subfile?
when are the referential constraints executed?
can we define multi-dimensional arrays in rpg ?
The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...
What is binder language ?
What is compiler directive in as400? Give example of compiler directive.?
how can a cgi check whether an ifs object is available?
How can we arrange duplicate records in a file?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.