Specifications

CHAPTER 3 Managing the Database
Users Guide 115
3 For TEXT, CSV, SQL, HTML, and DIF formats, select an encoding for the
file.
You can select ANSI/DBCS, Unicode LE (Little-Endian), Unicode BE
(Big-Endian), or UTF8.
4 Name the file and save it.
InfoMaker saves all displayed rows in the file; all columns in the displayed
rows are saved. Filtered rows are not saved.
Creating and executing SQL statements
The Database painter’s Interactive SQL view is a SQL editor in which you can
enter and execute SQL statements. The view provides all editing capabilities
needed for writing and modifying SQL statements. You can cut, copy, and
paste text; search for and replace text; and create SQL statements. You can also
set editing properties to make reading your SQL files easier.
Building and executing SQL statements
You can use the Interactive SQL view to build SQL statements and execute
them immediately. The view acts as a notepad in which you can enter SQL
statements.
Creating stored procedures
You can use the Interactive SQL view to create stored procedures or triggers,
but make sure that the Database painter’s SQL statement terminator character
is not the same as the terminator character used in the stored procedure
language of your DBMS.
About the statement
terminator
By default, InfoMaker uses the semicolon as the SQL statement terminator.
You can override the semicolon by specifying a different terminator character
in the Database painter. To change the terminator character, select
Design>Options from the Database painter’s menu bar.
Make sure that the character you choose is not reserved for another use by your
database vendor. For example, using the slash character (/) causes compilation
errors with some DBMSs.