6.7.4SHOW ALL USE FILE

#Syntax

#Description

Show (i.e. get) all HDF5 files in use (i.e. open).

#Parameter(s)

post_processing_option – optional option that transforms the result set according to the programmer’s needs, such as ordering or truncating (please refer to the section PROCESSING for additional information).

output_redirecting_option – optional option that specifies the cursor in use, an HDF5 object (i.e. dataset or attribute), a (text, binary, or Excel) file, or memory (i.e. user-defined variable) to write the result set into (please refer to the subsection INTO for additional information). If not specified, the cursor in use is populated with the result set instead (please refer to the chapter CURSOR for additional information).

#Return

All HDF5 files in use (i.e. open) as an HDFQL_VARCHAR or nothing (in case no files are in use).

#Example(s)

# show (i.e. get) all HDF5 files in use (i.e. open) (should return nothing) 
SHOW ALL USE FILE

# use (i.e. open) three HDF5 files named "my_file0.h5", "my_file1.h5", and "my_file2.h5" 
USE FILE my_file0.h5, my_file1.h5, my_file2.h5

# show (i.e. get) all HDF5 files in use (i.e. open) (should return "my_file2.h5", "my_file1.h5", "my_file0.h5")
SHOW ALL USE FILE

# close all HDF5 files in use (i.e. open) 
CLOSE ALL FILE 

# show (i.e. get) all HDF5 files in use (i.e. open) (should return nothing) 
SHOW ALL USE FILE