1. Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther
  2. Suggest New Category

how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?

Question Posted / sandy

Answers were Sorted based on User's Feedback



how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concep..

Answer / madhab

Use POSDBF command..

Is This Answer Correct ?    0 Yes 0 No

how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concep..

Answer / zavith ahamed

Using RTVMBRD command to see the file releted the details....

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More IBM AS400 AllOther Interview Questions

How to create an Access path in Synon/2E ?

1 Answers  

can you explain the difference between spacea,spaceb,skipa and skipb. I'm new to learning about as400 and printer files. can any one give me an example using source code showing the difference that occurs between using these 4 keywords. A-Physical file PF004 source UNIQUE R RR STUNAM 10 ROLLNU 5 0 MARKS 3 0 SEX 6 K ROLLNU 4 records present in PF004 are STUNAM ROLLNU MARKS SEX KAVYA 12,344 55 FEMALE MADHAVAN 14,579 60 MALE RAMYA 14,785 70 FEMALE KRISHNAN 14,988 72 MALE B-Printer File PRINT1 source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEB(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEB(1) A 20'END OF REPORT' C-RPG/400 Program PRTTPG source FPF004 I F E DISK FPRINT1 O E PRINTER C WRITE HEADER C READ PF004 60 C *IN60 DOWEQ *OFF C WRITE DETAIL C READ PF004 60 C ENDDO C WRITE FOOTER C SETON LR D-spooled file result set Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 STUNAM ROLLNU MARKS SEX KAVYA 12344 055 FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys I have changed from SPACEB to SPACEA now in my printer file source E-Changed PRINT1 Source A R HEADER A 10 3'STUNAM' A 10 20'ROLLNU' A 10 30'MARKS' A 10 40'SEX' A R DETAIL A SPACEA(1) A STUNAM 10 3 A ROLLNU 5 0 20 A MARKS 3 0 30 A SEX 6 40 A R FOOTER A SPACEA(1) A 20'END OF REPORT' F-Spooled file Result Set after keyword change Display Spooled File File . . . . . : PRINT1 Page/Line 1/10 Control . . . . . Columns 1 - 130 Find . . . . . . *...+....1....+....2....+....3....+....4....+....5....+.... 6....+....7....+....8....+....9....+....0....+....1....+.... 2....+....3 KAVYAM 12344U 055KS FEMALE MADHAVAN 14579 060 MALE RAMYA 14785 070 FEMALE KRISHNAN 14988 072 MALE END OF REPORT Bottom F3=Exit F12=Cancel F19=Left F20=Right F24=More keys Overprinting not displayed.

0 Answers   Tieto,

What is a job log?

1 Answers  

what does vldcmdkey means?

0 Answers   IBM,

Can you use multi format LF in CL program?

2 Answers  




Can anybody know what is Pick/Basic? Is it a programming language? can it be used in AS400 machine?

2 Answers  

Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out

0 Answers   Virtusa,

explain the use of dftwrt display keyword?

1 Answers   IBM,

what is the maximum number of files allowed in rpg?

1 Answers   IBM,

is there any way I can ease my rpg controls on numeric input fields? How about an input date field?

0 Answers   IBM,

What is the use of Data Queues?

1 Answers  

WHAT IS THE DISPLAY CMD FOR DATAQ, HOW IT CAN BE USED?

2 Answers  

For more IBM AS400 AllOther Interview Questions Click Here
Categories