Difference between creating a report using Printer file and
WRKQRY(Query Report) ?
- 3 Answers
- 11325 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / syam
Printer File we need to create in RLU and save it. Later
you can use same Printer file for another RPG or WRKQRY
programs.
WRKQRY Report only the same QRY program or copy the QRY to
another QRY and use it
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sujatha
WRKQRY
advantage: can send output to database file without hassle
thereby enabling more research on the output.
disadvantage:
reports are not as user-friendly as column names and
subtotal lables are fixed.
calculations are not very extensive. (IF ELSE calculations
cannot be implemented)
no documentation is possible, making it difficult to reuse.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mansi walia
If you create a report with RLU then you can give the
header as per your need, where as in WRKQRY this option is
not available.
| Is This Answer Correct ? | 2 Yes | 0 No |
what is edit word and edit code
Assume my file has 100 records and I want to see only first 10 records. Is this possible through lf?
What does Implicit Open means with respect to a file ? What about the Explicit Open?..what are the major differences between these two?
In RPG program one file using as a PRIMARY file while running program some of the records reading twice any body know why its happening
How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)
what built in function can be used with SETLL.If you want to check whether the search argument is successful or not? Please give me answer with example?
what do you mean by SESSION/DEVOCE ERROR?
Can any body give the code for this quesition? Using the following details write C-Spec code to set Name to"AMMU LABS SYSTEM" D NAME1 S 10 INZ('AMMU') D NAME2 S 10 INZ('LABS') D NAME3 S 10 INZ('SYSTEM') D NAME S 20
This is my Physical file 'EMPS' existing in library "TAMIL1" and its record format is 'EMPRCD" a)its source is R EMPRCD ENO 4 0 ENAME 10 EADD 10 b)The records present in EMPS are as follows ENO ENAME EADD 0001 tamil coimbatore 0002 kumar bangalore 0003 sunder bangalore 0004 arunkumar chennai 0005 pandi hyderabad 0006 santhosh hyderabad 0007 sasi salem 0008 kalai chennai 0009 suresh hyderabad 0010 vijay bangalore 0011 Arul chennai 0012 velu chennai 0013 khan bangalore 0014 praba chennai 0015 praba.p coimbatore 0016 anand ooty 0017 raja erode 0018 sankar erode 0019 vadivel namakkal 0020 anbu chennai 0021 Ajith mumabi c)now i want to select the 'ENAME' field records starting with 'S' for that i have created a RPG program its source code is PGM DCLF FILE(TAMIL1/EMPS) DCL VAR(&MYENO) TYPE(*CHAR) LEN(4) OVRDBF FILE(EMPS) SHARE(*YES) OPNQRYF FILE((TAMIL1/EMPS)) QRYSLT('ENAME *EQ %WLDCRD("S *")') READ: RCVF RCDFMT(EMPRCD) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) CHGVAR VAR(&MYENO) VALUE(&ENO) SNDUSRMSG MSG(&MYENO) SNDUSRMSG MSG(&ENAME) SNDUSRMSG MSG(&EADD) GOTO READ END: CLOF OPNID(EMPS) DLTOVR FILE(EMPS) ENDPGM Is this coding correct sir,the program gets compiled,and if i call it it says query running but records are not displayed.please help me out
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
when will come session device error?
How to print Superscript / Subscript from RPG400
RPG400 
