Logging your work
As you work with your database, you generate SQL statements. As
you define a new table, for example, PowerBuilder builds a SQL CREATE
TABLE statement internally. When you save the table, PowerBuilder
sends the SQL statement to the DBMS to create the table. Similarly,
when you add an index, PowerBuilder builds a CREATE INDEX
statement.
You can see all SQL generated in a Database painter session in
the Activity Log view. You can also save this information to a file.
This allows you to have a record of your work and makes it easy to
duplicate the work if you need to create the same or similar tables in
another database.
To start logging your work
-
Open the Database painter.
-
Select Start Log from the Design menu or the pop-up menu in
the Activity Log view.PowerBuilder begins sending all generated syntax to the
Activity Log view.
To stop the log
-
Select Stop Log from the Design menu or the pop-up menu in
the Activity Log view.PowerBuilder stops sending the generated syntax to the
Activity Log view. Your work is no longer logged.
To save the log to a permanent text file
-
Select Save or Save As from the File menu.
-
Name the file and click Save. The default file extension is
SQL, but you can change that if you want to.
Submitting the log to your DBMS
You can open a saved log file and submit it to your DBMS in
the ISQL view. For more information, see Building and
executing SQL statements.