PowerBuilder is an integrated development system which is a rapid application development tool for building,maintaining and modernizing business-critical Window application.It was developed in 1991 and owned by Sybase,a division of SAP.It makes prototype construction and permits developers to create client/server, Web and distributed applications for Win32, .NET and Java Platform, Enterprise Edition (JEE) platforms.
Embedded SQL supports SELECT, INSERT, UPDATE, DELETE and cursors. This option is used when the developer desires more control than is available with the DataWindow option. Example:
UPDATE my_employee SET STATUS = 'A'; IF sqlca.sqlcode<>0 THEN ...