PREPARE IFILE Examples

Example 1:

 

  

PREP

EMPLMSTR,"EMPLDATA":

  

  

"EMPLINDX","8","210"

 

Logical file:

EMPLMSTR

Text file:

EMPLDATA.??? (.TXT under SUNDB86x or as defined in screen definition file under PLBCMP)

Key file:

EMPLINDX.??? (.ISI under SUNDB86x or as defined in screen definition file under PLBCMP)

Key length:

8 Bytes

Record length:

210

Mode:

SHARE (by default)

 

Example 2:

 

  

PREP

EMP,"EMMSTR01":

  

  

"EMMSTR01":

  

  

"14","155",EXCLUSIVE

 

Logical file:

EMP

Text file:

EMMSTR01.??? .TXT under SUNDB86x or as defined in screen definition file under PLBCMP)

Key file:

EMMSTR01.??? (.ISI under SUNDB86x or as defined in screen definition file under PLBCMP)

Key length:

14 Bytes

Record length:

155

Mode:

EXCLUSIVE

 

Parameters given as literals could have been variables.

 

Example 3:

 

  

PREP

IFILE,"FILELST":

  

  

"FILELSTX":

  

  

"1-5,10-12": ;Key specification

  

  

"20":

  

  

SHARE

 

Logical file:

IFILE

Text file:

FILELST.??? ).TXT under SUNDB86x or as defined in screen definition file under PLBCMP)

Key file:

FILELSTX.??? .ISI under SUNDB86x or as defined in screen definition file under PLBCMP)

Key length:

7 Bytes

Record length:

20

Mode:

Share

 

Example 4:

 

  

PREP

EMPLMSTR:

  

  

"C:\DATA\EMPLDATA":

  

  

"C:\INDEX\EMPLINDX|209.20.30.5:503","8","210"

 

Logical file:

EMPLMSTR

Text file:

C:\DATA\EMPLDATA.??? (As defined in screen definition file) at the server

Key file:

C:\INDEX\EMPLINDX.??? (As defined in screen definition file) at the server

Key length:

8 Bytes

Record length:

210

Mode:

SHARE (by default)

Server address:

209.20.30.5

Server port:

503

 

 


PL/B Language Reference PREPARE (FILE) Examples PRINT Examples