Interested to Buy Any Domain ? << Click Here >> for more details...
is it possible to create a join logical file using two join
logical files ? give exact reason for your answer
- 4 Answers
- 13427 Views
- Ocwen, I also Faced
- E-Mail Answers
Answer Posted / remya
we can't create join lf from two other join lf. because the
file(s) specified in jfile keyword should be physical
files.As per my knowledge, the exact reason for this is,the
access path of the join lf is joined together and we can't
join them again.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
what are all the contents of subfile?
can a join logical file be updated?
define the purpose of the leave operation?
What is dynslt?
how can database records be read without lock ?
what are indicators?
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.
what is the command to know key fields of file?
how do you read data area in an rpg program?
what are the limitations of cl (compare to rpg) ?
What Is The Object Type Of Pf, Lf, Printer File & Display File?
what is the purpose of indicators in rpg?
which are the member types which seu supports?
when is a tag statement used in rpg?
how can u check no of records in a file?
