Using SQL statements
This SQL is an example that shows how to use to_char()
with the correct format. The SQL statement must be the same
for steps 1 and 4.
This example is valid when the database that is used is Oracle, since to_char
is a format function of Oracle.
-
In the Database Schema Configurator, click
SQL Statement Schema Configurator dialog box.
to open the
- Click to close the dialog box.
- Save the configuration.
-
In Network Configurator, select the database-inbound protocol for the thread to
configure, and click
.
-
In the Database Inbound
Protocol Properties dialog box, for Table Schema select
the
testFormat
table schema created in step 1. - In the Read Action tab, select the option and specify the content listed in step 1.
-
In the Database Inbound
Protocol Properties dialog box, for Table Schema select
the
- Click to exit the dialog box.
- Save the configuration.