Advanced PowerBuilder

Embedded & Dynamic SQL

Till now, you have learned how to use the SELECT statement in a DataWindow. You also came to know that, when you issue an Update() function, PowerBuilder automatically generates INSERT, DELETE and UPDATE statements, depending on the row status, effectively saving the information back to the database.

We now extend our coverage of SQL to two particular subsets: embedded SQL and dynamic SQL. We'll also take a look at dynamic DataWindows, cursors and stored procedures.

In this session you will learn about:

	Embedded SQL.
	Using cursors in PowerScript.
	Using stored procedures in PowerScript.
	Using dynamic SQL in PowerScript.

Estimated session time: 240+ minutes

Prerequisites:

You should have PowerBuilder ( Desktop/ Professional/ Enterprise version ) installed on your computer.

Home	Previous Lesson: Other Issues to Consider Next Lesson: Introduction