Getting started with SQL Where Clause on secondary file(s)

   

Secondary File(s)

When implementing a "Where Clause" statement for a secondary file read, it is imperative to comprehend the distinctions in processing methodology employed by the kernel in comparison to primary file operations. To facilitate a comprehensive understanding, the subsequent section provides several illustrative examples.

Customer Entries are:

Customer

Name

State

Inactive

Apple

Apple Corp

TX

N

Microsoft

Microsoft Corp

CA

N

P&G

Proter & Gamble

TX

Y

Walmart

Walmart Coporation

UT

Y