With the SQL Editor you can generate SQL Statements in a simple way
The SQL Editor displays all SAP-Tables, all beas Tables and beas Views
When hovering the mouse over a beas table column, beas displays more information about this field if available
The integrated MSSQLà HANA Converter makes it simple for you to convert the script in correct HANA Syntax.
The SQL Editor has different modes.
Create own SQL Statements
Open SQL Editor from Debug window to test executed SQL Statement
Open SQL Editor to define Filter or Order
In this mode beas creates the correct syntax if you make a double click on a field
- convert NULL fields to string: COALESCE("TableName","FieldName",'')
- convert all types to string: Cast(...)
- allocate fields, if you need more then one field (field1 || field2)
|
Beas converts the string before executing.
1. Replace all placeholders <...>, linked to window defined in the Window field in top section
2. Delete & marks on right side
3. MSSQL: Convert HANA Syntax to MSSQL Syntax with internal MSSQL Online Converter
4. Display Result as Grid Table
5. Display count of rows and duration time from executing
Limitation:
SQL Statements executed from beas can have questions marks in the arguments.
The SQL Editor cannot replace this.
|
Help URL: https://help.beascloud.com/beas202106/index.html?sql.htm
|