You can copy cells, rows, and columns directly from the result set in Interactive SQL and then paste them into other applications. Copying rows and columns copies both the column headings and table data into the clipboard.
There are no prerequisites for this task.
You must have executed a query to have a result set.
Context and remarks
Copied data is formatted according to the following Interactive SQL options:
You can also change these options from Interactive SQL by clicking Options » Import/Export.
If these options are set to their defaults, the copied data is comma-delimited and the strings are enclosed in single quotes.
In Interactive SQL, retrieve the result set you want to copy.
|Copy one row||
Right-click any cell in the row and click Copy Data » Rows.
|Copy multiple rows||
Hold the Ctrl key while clicking cells in the rows, and then right-click and click Copy Data » Rows.
The selected row(s), including their column headings, are copied to the clipboard.
|Copy one column||
Right-click any cell in the column and click Copy Data » Columns.
|Copy multiple columns||
Hold the Ctrl key while clicking cells in the columns, and then right-click and click Copy Data » Columns.
If the Results pane does not contain the entire result set, you are prompted to fetch the remaining results before selecting them. Otherwise, only those results that have been fetched so far are selected.
|Copy a cell||
Right-click the cell you want to copy and click Copy Data » Cells.
|Copy multiple cells||
Hold the Ctrl key while clicking cells, and then right-click and click Copy Data » Cells.
When you do this, no column headings are copied—only the data is copied to the clipboard, and no quoting is done.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|