I am using a directory server which does not exist on the same drive as any of the database files. Is there any way to query the space available on the drive before inserting into a table on the drive to see if there is room? Thanks Jim asked 29 Jan '19, 07:18 J Diaz |
When using SQL Anywhere 17, you can use the sp_disk_info() system procedure. On Windows, this can be used both with directories on drives identified by drive letters or UNC names. Don't know how this works on Unixes. -- note, need do specify an existing file/dir (here the root dir) call sp_disk_info('C:\\.'); -- UNC (seems to expect an existing dir or file other than the root dir call sp_disk_info('\\\\ServerName\\Netshare\\AnExistingDir'); answered 29 Jan '19, 07:50 Volker Barth Any options on 12 or 16 we are not up to 17 yet.
(29 Jan '19, 08:15)
J Diaz
Replies hidden
See this topic about using WMIC: Check free disk space using Batch commands.
(29 Jan '19, 08:47)
Breck Carter
|