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

Answer Posted / rsinghal

Go to Edit Database Relations Panel, Type Z against the file on which access path has to be created.
On Edit File Details Panel mention the Type(RTV,RSQ,SPN,QRY) and Name of Access Path.
Compile it.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the sequence when using cursor?

849


which are control break logic indicators?

871


What are the record format field mapping options in cpyf?

816


what is scan and xlate?

1464


How to convert a spool file to PDF file in AS400?

956


name few ibm supplied libraries?

1646


what are dds required for subfile?

804


give three main purposes of file specification ?

1374


What is binder language ?

1673


What are the different opcodes used for file operation on a subfile in a rpg pgm?

1443


what is overlay?

913


i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.

1259


What is the draw back of Procedures? why we are going to Modules?

1480


what is the version of os/400 that we have?

1299


how can you detect and handle a record lock situation?

1607