what is difference between accespath and datapath?
what is the difference between accespath and open datapath?
- 2 Answers
- 9527 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Access Parh: Describes the Order in which records are to
be retrieved i.e Sequential Access path ,Keyed Access path.
Open Data Path: Provide the way for more then one program
in the same job to share the same file information like
file pointer position, storage area.
It is quite useful to improve the performances and reduces
the open/close file.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / abhishek bajpai
U can understand it like...access path is internal to file
and data path is external to it.
Access path is the order in which the records in a file are
retrieved. Whereas the datapath is the connection between
the program and the database file.
So if a program is using the data basefile, it connects to
the file by using the datapath (which can be share also)
and then retrieves its records based on the order requried
using the access path.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is the purpose of the following I UDS I 1 60ORDER# I 7 90LINE#
write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Field Name="SALARY")
6 Answers Bally Technologies, Cognizant, Vertex,
what key word is used when screen is re-display?
what are the limitations of cl (compare to rpg) ?
what is clile code get last digit in numarice value
the output from my cgi is correctly interpreted by ms internet explorer, whereas netscape navigator would display it as a plain text. What should I do to have also netscape interpreting the html output from my cgi?
what is the necessary keyword for non-join logical file?
all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?
WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)
does cl support arrays
Q.Hi All friends, I have one Question, I have three fields in display file SUP LOT, ISSUED to Prod and Line Grp. Field SUP LOT is mentioned in one field reference file WRSLT and key field as a key field LP.Fields ISSUED to PROD,Line GRP are mentioned in the another Field reference file WMDTF. So I want to read SUP LOT on the basis of key field LP from the first file WFSLTand then i want ot read another two fields ISSUED to DATE and LINE GRP from second file on the basis of SUP LOT, which i got from first file.Now i want to display these fields in the display file DSPWMMS. but Condition is that 'Supplier Lot,ISSUED to Prod and Line Grp will not be shown if their respective fields are blanks/Zero. Please Let me Know coding part of this senerio and what would be coding for display file to now shown fields if fields are blanks/zero. My mob. no. is 9836300345. Please reply me asap.
. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?
RPG400 
