SQL-ftpd DIR command

Note: Your ftp client may be case sensitive

The DIR command is used to get a listing of databases from the remote SQL server. Simply put, the DIR command is analogous to the sp_help command to the SQL server. This command returns more information than just the names, it also returns the owner, and the type of the object. The first column is the object name, the second is the object's owner and the third column is the object type (user table, system table, stored procedure, view, etc).

An example of this command's usage is given below:

  ftp sybasedev.acs.ncsu.edu 9220           # connect to port 9220 on sybasedev (sqlftp)
  User: <your-sybase-user-id>                 # remember, we're a front end to sybase
  Password: <your-sybase-password>            # so your sybase id is what you'll need here.
  230 User <your-sybase-user-id> logged in.   # and it tells you when you've logged in.
  
  ftp> dir
  150 Opening ASCII mode data connection for SQL results.
  

  .... (list of database objects is returned)

  226 Transfer complete.
  ftp>

author's note: The dir function may not work with all clients. Some ftp clients insist that the dir function be equivalent to the ls function, though the SQL-ftpd server treats them differently.

Forward to the get command manual page.

Return to the SQL-ftpd Commands Page