Naming Result Tabs

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  SQL との作業 >

Naming Result Tabs

When you execute a script that contains more than one SELECT query, the results of each query are displayed in separate 結果ウィンドウs. デフォルトでは、 these windows are called "Result1", "Result2", etc. Using targets, you can specify more meaningful names for query 結果ウィンドウs.

 

メモ:The target keywords are only recognized if either "Semicolons" or "SQL Grammar" is selected in the Group statements for execution with ドロップダウンリスト in プロパティウィンドウ. If you execute a query containing target keywords without having selected the appropriate options, the query is still executed, but output to unnamed result tabs. A warning is displayed in the Message tab of the 結果ウィンドウ.

 

 

To name a target 結果ウィンドウ:

1.Place the cursor anywhere in the SELECT statement. Click the Current statement ic_select-entire-stmt ボタン (Shift+Alt+Enter) in the SQL エディターウィンドウ. This selects the entire statement.
2.Click the Define Target Name ic_insert-target-single ボタン in the SQL Script ツールバー. The text -- target: Result appears above the statement.

target_result

3.Change the text "Result" as desired.

target_result_new_name

4.プロパティウィンドウ内で、 make sure that either "Semicolons" or "SQL Grammar" is selected in the Group statements for execution with ドロップダウンリスト.
5.「実行」 dbs_ic_execute_script ボタンをクリック、または、「F5」を押します。

The results appear in a 結果ウィンドウ that has a tab with the text that you specified as target, e.g., zookeepers.

sql_target-zookeepers


(C) 2019 Altova GmbH