DSIYAD01 ADHCFILE FILES (4051)    REMOTE PROCEDURE (8994)

ADHCFILE
 
Return a list of files that the user can run Ad-Hoc reports against.

• GROUP
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   2
  REQUIRED:   YES
  SEQUENCE NUMBER:   1
  DESCRIPTION:   

  FUNC
  ^EN^IFCAP^
   
  Enter a string of Package Names in order to limit the files returned.  
  These will be matched against the VRPK name in the Data Dictionary.
   
  Send Package Names in the format:
  ^PKGNM^PKGNM^PKGNM^
   
  For example to get Engineering (EN) and IFCAP files - send
  

• NOREC
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   4
  REQUIRED:   NO
  SEQUENCE NUMBER:   2
  DESCRIPTION:   

  NOREC
   
  The number of files to return at one time
  

• START
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   10
  REQUIRED:   NO
  SEQUENCE NUMBER:   3
  DESCRIPTION:   

  START
   
  The seed to start the search (usually the last file # from the last run 
  so that the next file # will be the next record)
  

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

  SYS
   
  1= Coming From Above PAR
  2= Coming From Data Miner
   
  Required
  

• ALL
  PARAMETER TYPE:   LITERAL
  MAXIMUM DATA LENGTH:   1
  REQUIRED:   NO
  SEQUENCE NUMBER:   5
  DESCRIPTION:   

  1: ignore user's file access permissions - show all files
  null: limit files based on user's access permissions
  

RETURN PARAMETER
P2:  DESCRIPTION OF FILE
P3:  # OF ENTRIES IN THE FILE
P4:  GLOBAL NAME
 
If this file is a multiple under another file, return will be
DSIYRET(FILE#) = 
P1:  FILE #
P2:  DESCRIPTION OF FILE
P3:  BLANK
P4:  PARENT FILE NUMBER
 
P5:  1 - FLAG TO SHOW THAT THIS IS A MULTIPLE FILE
P4:  PARENT FILE NUMBER
P5:  1 - FLAG TO SHOW THAT THIS IS A MULTIPLE FILE
DSIYRET(1) = -1^Error   if errors
DSIYRET(1) = 0^Message  if nothing returned
 
If successful
 
DSIYRET(FILE#) = 
P1:  FILE #