User's Guide Part V. The SQL Anywhere Programming Interfaces Chapter 38. The WSQL HLI Interface
CLIP
NAMES
| DATA
| BOTH
... cursor-name
cursor-name: identifier, or host variable
To place query results on the Windows or Windows NT clipboard.
wsqlquerytomem.
This command places a query result set on the system clipboard. The cursor-name must identify an open cursor.
If NAMES is specified, then the clipboard contents will be a single row containing the column names of the result set of the indicated cursor. The names will be separated by tab characters and terminated with a carriage return / linefeed.
If DATA is specified, then the clipboard contents will be the entire query result set starting from the current cursor position. Each row will be terminated with a carriage return / linefeed and the values within a row will be separated by tab characters.
If BOTH is specified then the row of names will be placed on the clipboard first, followed by the rest of the result set.
If the BOTH or DATA keyword is specified then the cursor will be positioned just after the last row of the query result set.