Hi all,
I need to get the names of files in a filesystem
directory and insert them into table in a sybase iq (IQ
12.7) stored procedure.

The only idea tha I have is:
1. Put file list into a file taking care of the output
format (something like "exec xp_cmdshell 'dir >
C:\list_dir.txt'")
2. Load the file content in an IQ table using LOAD command.

Does it exist a better way to do this tasks in a IQ stored
procedure (IQ 12.7)?

Thanks.