DSIYAD01 ADHCFILE FILES

TITLEVALUE
NAMEDSIYAD01 ADHCFILE FILES
DESCRIPTIONADHCFILE

Return a list of files that the user can run Ad-Hoc reports against.
TAGADHCFILE
ROUTINEDSIYAD01
INPUT PARAMETERSSEQUENCE NUMBER1
INPUT PARAMETERGROUP
DESCRIPTIONFUNC

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
^EN^IFCAP^
PARAMETER TYPELITERAL
REQUIREDYES
MAXIMUM DATA LENGTH2

INPUT PARAMETERSSEQUENCE NUMBER2
INPUT PARAMETERNOREC
DESCRIPTIONNOREC

The number of files to return at one time
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH4

INPUT PARAMETERSSEQUENCE NUMBER3
INPUT PARAMETERSTART
DESCRIPTIONSTART

The seed to start the search (usually the last file # from the last run
so that the next file # will be the next record)
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH10

INPUT PARAMETERSSEQUENCE NUMBER4
INPUT PARAMETERSYS
DESCRIPTIONSYS

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

Required
PARAMETER TYPELITERAL
REQUIREDYES
MAXIMUM DATA LENGTH1

INPUT PARAMETERSSEQUENCE NUMBER5
INPUT PARAMETERALL
DESCRIPTION1: ignore user's file access permissions - show all files
null: limit files based on user's access permissions
PARAMETER TYPELITERAL
REQUIREDNO
MAXIMUM DATA LENGTH1

RETURN VALUE TYPEGLOBAL ARRAY
RETURN PARAMETER DESCRIPTIONRETURN PARAMETER

DSIYRET(1) = -1^Error if errors
DSIYRET(1) = 0^Message if nothing returned

If successful

DSIYRET(FILE#) =
P1: FILE #
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
AVAILABILITY
INACTIVE
CLIENT MANAGER
WORD WRAP ONTRUE
VERSION
SUPPRESS RDV USER SETUP
APP PROXY ALLOWED