DSIYAD01 ADHCFLD FIELD (4052)    REMOTE PROCEDURE (8994)

ADHCFLD
 
Returns a list of fields in the file
 
NOTE:  The following field types are skipped in Phase I of Ad-Hoc 
Reporting:
  Variable Pointers
  Multiples
  Word Processing

• FILE
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   20
  REQUIRED:   YES
  SEQUENCE NUMBER:   1
  DESCRIPTION:   

  FILE
   
  FILE # of the file on which to report fields
  

• MULT
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   1
  REQUIRED:   NO
  SEQUENCE NUMBER:   2
  DESCRIPTION:   

  MULT
   
  Flag = 1 if this is a multiple file under a main file.
  

• PTR
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   1
  REQUIRED:   NO
  SEQUENCE NUMBER:   3
  DESCRIPTION:   

  PTR
   
  Flag to show this is a pointer file under a main file
  

• SYS
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   1
  REQUIRED:   YES
  SEQUENCE NUMBER:   4
  DESCRIPTION:   

  SYS
   
  Requesting System - 1:Above PAR, 2:DSS Data Miner
  

RETURN PARAMETER
P2:  FIELD #
P3:  FIELD NAME
P4:  TYPE OF FIELD
      SET  (USE LOOKUP TO FIND VALUES)
      NUMERIC
      POINTER (USE LOOKUP TO FIND VALUES)
      FREE TEXT
      DATE/TIME
      MULTIPLE
P5:  LENGTH
 
P6:  NUMBER OF DECIMALS (NOTE, LENGTH FOR A NUMERIC FIELD IS VALUE + 
         DECIMALS)
P7:  POINTED TO FILE
P8:  FILE # FOR THE MULTIPLE FILE IF THIS IS A MULTIPLE
P9:  'N' IF NO POINTER LINK
P10: XREF FOR THIS FIELD
P11: -1 IF ACCESS IS NOT PERMITTED TO THIS FIELD (FILEMAN READ ACCESS AT 
     FIELD LEVEL) OR -2 IF KERNAL READ ACCESS AT FILE LEVEL FOR POINTED 
TO FILE
 
DSIYRET(1) = -1^error         If errors
 
 
 
 
 
 
 
 
 
 
DSIYRET(1) = 0^message        If nothing returned
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
If Successful
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
DSIYRET(FIELD) = 
 
 
 
 
 
 
 
 
 
 
P1:  FILE #
 
 
 
FILE.