What is the difference between a Physical File & a Logical?
- 28 Answers
- 102444 Views
- Accenture, ACS, IBM, I also Faced
- E-Mail Answers
Answer Posted / david
In a database management system, a physical record is the actual binary representation of the data whereas the logical record is the text representation of the data that humans can read and understand.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How can we arrange duplicate records in a file?
maximum number of subfiles that can be active for a single file is?
what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.
What Is The Purpose Of The "n" In The Following Calculation Specification?
give three main purposes of file specification ?
I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into.
how to read database records without locking them?
what is the purpose of indicators in rpg?
how can a message from a message file appear as a constant on the screen?
distinguish between terminating a program through seton lr and return?
how many printer files maximum can be used in single rpg program?
during input operation which indicator position is seton if there is a record lock?
what are the three types of keywords associated with printer file ?
what are different record spacing keywords in rlu ?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
