-
IBM AS400 AllOther (736)
1.what are the builtin funtions in cl pgg?Explain with example 2.what is meant by left outer join?where we can use this?
2 5809what is difference between accespath and datapath? what is the difference between accespath and open datapath?
2 91861.What is the difference between regular join logical file and non join logical file? 2.what are the nessasary keywords for non join logical file
ANZ,
3 13740what is multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?
HCL,
2 11184If there are 1000 member(PGM type) in a SRC file. How can we compile in a CL program? ( It need to be done in a loop)?
1 60801.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF
5 81491.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
HCL,
23641..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?
4 93021.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?
TCS,
2 76791.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?
IBM,
4 80691.The questions have given an array declaration and move operation then this statement is correct or not?
TCS,
3 58831.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword
1 44081.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
HSBC,
3 9012
WHAT IS FERERENTIAL INTRIGRITY ?
1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?
What is redefine?
what is rpg ?
how to write *pssr ?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
Define perform?
How Chain operation copies the record's data to the input buffer for the program?
how do you read changed records backward in subfile?
What is the use of limit sys?
Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP
what are the three line types in rlu ?
Define perform? And its types?
what is rpg fixed logic cycle?
is this a rpg channel?
