SQL-ftpd client commands

Note: Not all commands may be available on all ftp clients.

Most of the commands used to control the SQL-ftpd server are used like they would be used to control a standard ftpd server. Remember though, that since we are mapping the ftp server to a SQL server instead of a remote file system, some things will be slightly different. In particular, the get command requires some special consideration, and some of the site commands may be needed to help format the data to the correct specifications.

These commands are listed here because the SQL-ftpd server only works with text based ftp clients. If you're trying to use a GUI client, such as RapidFiler I can already tell you it will not work.

The primary commands used to control the SQL-ftpd server are:

ls LiSt Databases
cd Change Database (formerly directory)
dir DIRectory of database objects
get GET a remote dataset from a table
put PUT a dataset into a table
append APPEND data to a table
idle set the IDLE timeout value
quit Finish the ftp session
site
- site tabs Toggle tab delimiters for gets
- site messages Toggle messages from the SQL server
- site delim Set the delimiter for puts
- site batch Set the batchsize for puts

In the preceeding pages, it is assumed the user is familiar with their ftp client. In the preceeding pages, these conventions are used:

Convention	Meaning and significance
ftp>	This is the ftp client prompt.
ftp> bold text	you typed the bold text
226 Transfer complete.	status messages from the ftp server.
ftp> <italics text>	substitute your input data for the italics

Next Step: Examples of Usage