WHAT ARE THE RETRIVAL ORDER OF FILES IN RPG&sql?

Answer Posted / karu

IN rpg...>in keyorder if you defined key...otherwise it is in arrival sequence access path..



in SQL..>it is only in ARRIVAL SEQUENCE ACCESSPATH 

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can min or max be used with alphanumeric data?

581


What is a configuration management system, give examples?

521


Write about a ‘view’ in brief?

567


When you are working with the project.. once your coding is over what will u do? where u r maintaining your CR(change request) what is the format what are the documents u need to prepare while testing?

1575


Explain referential integrity?

622






accept ws-date from date will return the current date?

551


Write the difference between hidam and hdam databases?

575


What is the need to code commits in batch programs?

617


What is the facility that allows mainframes to be partitioned into lapars?

615


can we describe the results of opening for input empty vsam files in a cobol program?

555


List the type of locks?

547


Explain index cardinality?

564


Explain isolation level?

644


How is data retrieved from multiple tables using a single sql statement?

556


Can you explain create an empty file by using sort?

570