John Strano

1
PowerBuilder 11.5 Geared Up for Accelerated
Development

• John Strano
• Technology Evangelist

2
Capabilities and Features Since PowerBuilder 11.0

• PowerBuilder 11.1
• Incremental rebuild for .NET Targets
• PowerBuilder 11.2
• Certificate Store Support for Smart
  Client-published applications
• Usability and UI Enhancements
• Database Connectivity Enhancements
• Enabling the DEBUG Condition for ORCA and
  OrcaScript
• Application Pools for Web Forms in IIS7
• Telerik RadControls Support
• EAServer Support for .NET-deployed PowerBuilder
  Clients
• AJAX Functionality for WebForm-Deployed
  Applications

3
PowerBuilder Videos

• For more PowerBuilder 11.x detail
• http//www.sybase.com/products/development/powerbu
  ilder/videos
• http//www.sybase.com/products/development/powerbu
  ilder/webcasts

4
PowerBuilder 11.5 Overview
5
Products Packaged with PowerBuilder 11.5!

• Premiums Packaged with
• PowerBuilder 11.5!

6
Packaged with PowerBuilder 11.5!

• PocketBuilder 2.5
• PowerBuilder Application Server Plug-in 1.1
• PowerBuilder Skills for Heterogeneous
  Environments
• Mobile
• JEE
• .NET
• Client/Server

7
PowerBuilder 11.5 Features
8

• .NET
• Code Access Security

9
Brief Introduction of Code Access Security (CAS)

• Code Access Security is for .NET applications at
  runtime
• Its complementary to Role-Based security
• http//msdn.microsoft.com/en-us/library/aa302422.
  aspx
• While Role-Based security answers the questions
  of "Who is the user and what can the user do?"

10
Brief Introduction of Code Access Security (CAS)

• Code security answers the questions of
• Where is the code from?
• Who wrote the code?
• What can the code do?
• CAS is a resource constraint model
• PowerBuilder 11.5 supports CAS for
• Windows Form (and Smart Client)
• Web Form applications
• NVOs (as Web Services or as Assemblies)

11
Security in Windows FormDesign time

• Security settings for code groups are designated
  in the project painters
• Four levels of trust
• Full Trust (default)
• Local Intranet Trust
• Can be customized
• Internet Trust
• Can be customized
• Custom

12
Security in WebForm / Web Service

• By default, WebForm and Web Services are
  deployed and running with Full trust level
• Can choose Custom level in project painter
• A new configuration file web_customtrust.config
  is generated and referred in applications
  web.config
• Application will be running in custom trust level
• Security setting in web.config and
  web_customtrust.config will take effect in runtime

13
Security in WebForm / Web Service
WebForm deployed with custom trust
14
Strong Name Support for .NET Applications

• You can ensure that a name is globally unique by
  signing an assembly with a Strong Name
• Strong Names attempt to guarantee authorship of
  code
• Strong Names satisfy the following requirements
  
• Strong Names guarantee name uniqueness by relying
  on unique key pairs
• Strong Names protect the version lineage of an
  assembly
• Strong Names provide a strong integrity check
• http//msdn.microsoft.com/en-us/library/wd40t7ad.a
  spx

15
Strong Name Support for .NET Applications

• PowerBuilder 11.5 can generate Strong Named
  assemblies for all .NET applications
• Can be put into GAC and shared by multiple
  Applications
• Can protect the assembly from tampering
• NVOs as .NET Web Services and as .NET Assemblies
  can be called by partially trusted callers if
  theyre signed with Strong Name
• Mark the assembly with AllowPartiallyTrustedCalle
  rAttribute
• Note Select this property unless you trust the
  callers

16
Strong Name Support for .NET Applications
17
PowerBuilder .NET Security Summary

• CAS provides you more security control on system
  resources
• However, it makes the developers work and
  administrators work more complex, and may cause
  more problems for the end users when running the
  application if not adequately planned and managed
• Need to work with system administrator to get the
  systems security policy during development
• Need thorough testing with intended security
  policy
• Always grant the minimal, not the most,
  permissions enough for performing certain
  operation to reduce potential risks

18
More resources on .NET CAS

• .NET Framework Developer's Guide Code Access
  Security
• http//msdn.microsoft.com/en-us/library/930b76w0(V
  S.80).aspx
• How to Add a Trusted Publisher to a Client
  Computer for Click Once Applications
• http//msdn.microsoft.com/en-us/library/ms172241.a
  spx
• .NET Framework tool Code Access Security Policy
  Tool (caspol.exe)
• http//msdn.microsoft.com/en-us/library/cb6t8dt
  z(VS.80).aspx
• Code Access Permissions from .NET Framework
• http//msdn.microsoft.com/en-us/library/h846e9b
  3.aspx
• ASP.NET Code Access Security
• http//msdn.microsoft.com/en-us/library/87x8e4d
  1.aspx

19

• PNG Graphics Support

20
PNG Support

• PowerBuilder 11.5 supports the Portable Networks
  Graphics (PNG) file format for images in
• Menus
• Toolbars
• Treeview controls
• DataWindow objects
• PNG images have an alpha channel for
  transparency
• Transparent portions of a PNG image display the
  background color gradient of the control to which
  they are assigned

21

• FDCC Compliance

22
FDCC Compliance

• The Federal Desktop Core Configuration (FDCC) is
  a security standard
• Mandated by the US Office of Management and
  Budget (OMB)

23
FDCC Compliance

• To meet the FDCC security requirements,
  PowerBuilder 11.5 can be installed only by a
  system administrator
• However
• PowerBuilder
• Applications that you develop with PowerBuilder
• are designed to be run in a standard user
  context without elevated system administration
  privileges

24
FDCC Compliance

• Most PowerBuilder files install by default to
  Program Files\Sybase subdirectories
• Write access to these subdirectories is
  restricted to administrative users
• FDCC requires all writable files must be copied
  or installed to directories where standard users
  have write access

25
FDCC Compliance

• Writable files that are shared by all users are
  installed in
• C\Documents and Settings\All Users\Documents\Syba
  se\PowerBuilder 11.5
• These include
• The EASDemo databases
• All Code Examples directories and files
• All PowerBuilder Help files
• The Translation Toolkit directories and files

26
FDCC Compliance

• User-specific writable files are installed in
  the default Program Files\Sybase subdirectories
  but
• Are copied to different locations the first time
  a user starts PowerBuilder
• There will be as many copies of these files as
  there are standard users who use PowerBuilder

C\Documents and Settings\UserName subdirectory Files copied or written
Local Settings\Application Data\Sybase\PowerBuilder 11.5 PBxxx.INI files License files
My Documents\Sybase\PowerBuilder 11.5\Tutorial PowerBuilder Getting Started tutorial
27

• Transaction Object Enhancement

28
Transaction Object Enhancement

• PowerBuilder 11.5 adds two new events for the
  Transaction object
• DBError
• SQLPreview

29
Transaction Object Enhancement

• With Embedded SQL
• Whenever an error occurs in the Transaction
  object, the DBError event is called
• The error code and error message are passed to
  the event
• The SQLPreview event on the Transaction object
  is triggered before SQL statements are passed to
  the DBMS

30
Transaction Object Enhancement

• DBError in concert with a DataStore or a
  DataWindow
• DataWindow/DataStore DBError event is triggered
  before the DBError event of the Transaction
  object
• To coordinate these two events
• Two additional return values have been added for
  the DataWindow DBError event
• The meaning of the existing return values is
  expanded to indicate whether the Transaction
  Object's DBError event should be fired

31
Transaction Object Enhancement

• contd
• SQLPreview in concert with a DataStore or a
  DataWindow
• If the return value of the DataWindow or
  DataStores SQLPreview event is 0
• Continue processing
• The Transaction object's SQLPreview event is
  triggered

32

• Remote Deployment of .NET Web Targets

33
Remote Deployment of .NET Web Targets

• PowerBuilder 11.5 .NET targets do not require
  you to have IIS installed on the development
  computer
• When you deploy directly to a remote computer
• System information about the deployment
  computer, including its OS and IIS versions, is
  passed to PowerBuilder
• through the Windows Management Instrumentation
  (WMI) interface

34
Remote Deployment of .NET Web Targets

• If you deploy to an MSI setup file
• Run the setup file on a deployment computer
• PowerBuilder can use the Windows API to obtain
  information about the OS and IIS versions on that
  computer

35
Remote Deployment of .NET Web Targets

• When you attempt to deploy Web Target projects
  on Vista or Windows 2008 under a standard user
  account

36
Remote Deployment of .NET Web Targets

• The User Account Control (UAC) dialog box
  displays
• This dialog box allows you to elevate your
  privileges for the purpose of deployment

37
Remote Deployment of .NET Web Targets

• Deploying .NET targets to a remote Windows Vista
  or Windows 2008 computer might require changes
  to
• UAC
• Windows firewall
• Distributed Component Object Model (DCOM)
  settings

38

• Support for
• MS SQL Server 2008

39
SQL Server 2008 DriverTransaction Object Syntax

• New Database Connection Parameter Provider
• Use the SQLNCLI10 Provider value
• Required to take advantage of new features
• Default Provider value is SQLNCLI
• Only supports SQL Server 2005 features
• Example
• SQLCA.DBParm Provider'SQLNCLI10

40
SQL Server 2008 Driver

• Mirroring Support
• New Data Types
• T-SQL Support

41
SQL Server 2008 Driver

• New Data Types
• TIME DATETIME2 types
• Have 0-7 fractional seconds precision.
• PowerBuilder supports 0-6 fractional seconds
  precision.
• DATETIMEOFFSET
• Not supported in PowerBuilder 11.5
• CLR Types
• HIERARCHYID
• SPATIAL DATA GEOGRAPHY GEOMETRY
• UDT User defined CLR Types
• FILESTREAM
• NOT strictly a new data type but a new storage
  mechanism for Varbinary(max) data

42
SQL Server 2008 Driver T-SQL Support

• Row Constructors
• INSERT INTO Employees VALUES ('tom', 25, 5),
  ('jerry', 30, 6)
• ESQL / DSQL
• FORCESEEK Table Hint
• Forces the query optimizer to use only an index
  seek
• ESQL / DSQL and DataWindow data source
• MERGE Statement
• Dynamic SQL only
• GROUPING SETS
• ESQL / DSQL and DataWindow data source

43
SQL Server 2008 DriverDelayed for GA

• The MS SQL Server 2008 release was delayed
• The GA version of our driver cannot be included
  in time for the PowerBuilder 11.5 GA
• Resolution
• We will release PowerBuilder 11.5 with the SQL
  Server 2008 RC driver and support its GA in an
  EBF

44

• Support for
• Oracle 11g

45
Oracle 11g Support

• Client Access through Proxy
• New DBParm ConnectAs is used to set the End
  User
• Session and Connection Pooling
• New Pooling DBParm
• "CnnPool'Yes' is now "Pooling'Connection
  Pooling
• Implicit Fetching ROWID with SELECT FOR UPDATE
  statements
• ROWID no longer needs to be explicitly added in
  the select items
• Client-side caching of SQL query result sets

46
Oracle 11g Support

• OCI Driver Name
• Diagnostic aid
• AppDriverName DPBARM parameter allows you to
  set your own client driver name
• XML data type support
• Oracle XMLType data type - introduced with
  Oracle 9i
• Supports returning single XMLType values from an
  Oracle cursor

47

• .NET Interoperability Language Enhancements

48
.NET InteroperabilityLanguage Enhancements

• PowerBuilder 11.5 will now
• Support method calls on PowerBuilder and .NET
  primitive types
• Support method calls on PowerBuilder and .NET
  enumerated types
• Support accessing static members of .NET classes
  with instance references

49
.NET InteroperabilityLanguage Enhancements

• Function calls on .NET primitive and enumerated
  types
• Must be made inside a conditional compilation
  block for a .NET target.

50
.NET InteroperabilityLanguage Enhancements

• Function calls on .NET Primitive Types
• Functionality of the primitive types is now
  merged with the functionality of their
  corresponding PowerBuilder primitives
• if defined PBDOTNET then
• System.Int32 i1
• long i2
• i1.ToString()
• i2.ToString()
• end if

51
.NET InteroperabilityLanguage Enhancements

• Function calls are also supported on .NET
  enumerated types that you import into a .NET
  target
• An enumerated type from an imported assembly
• namespace ns1.ns2
• Public enum TimeOfDay
• Morning 0,
• AfterNoon 1,
• Evening 2

52
.NET InteroperabilityLanguage Enhancements

• e.g. PowerBuilder allows you to call the
  ToString() method on the .NET TimeOfDay
  enumerated type after you reference it in your
  target
• if defined PBDOTNET then
• ns1.ns2.TimeOfDay daytime
• daytime ns1.ns2.TimeOfDay.Morning!
• daytime.ToString()
• end if

53
.NET InteroperabilityLanguage Enhancements

• PowerBuilder 11.5 lets you use instance
  references to access static members of .NET
  classes
• string s
• if defined PBDOTNET then
• //OLD WAY
• //sSystem.Web.HttpContext.Current.ToString()
• //NEW WAY
• System.Web.HttpContext context
• context System.Web.HttpContext
• s context.Current.ToString()
• end if

54

• DataWindow Enhancements

55
New DataWindow Features Supported
Targets/Platforms

• Traditional Win32
• Windows Forms Target
• Smart Client-Published WinForm Applications
• InfoMaker 11.5

56
Tooltips

• Supported in all DataWindow presentation styles
• Except RichText and OLE
• New property tab New properties
• Columns and all Control types
• All new properties are expression-enabled

57
Gradients/Translucency of Backgrounds

• Supported in all DataWindow presentation styles
• Except RichText and OLE
• New property tab New properties
• Bands
• Columns and all Control types
• All are expression-enabled (except for DWO
  scope/level)

58
Text Translucency

• New Property on Font Properties tab
• Columns
• Text
• Buttons
• Group Boxes
• Computed Columns
• Expression-enabled

59
New DataWindow Object-Level Properties

• Same as band/column/control background
  properties except
• Not expression-enabled
• Transparency is not really transparent
• Defaults to a white background
• Extras
• Images and Tiling

60
New Properties for Picture Control

• transparentcolor
• Designate a color in the image to be transparent
• Transparency
• Expression-enabled

61
New Column Edit Style - RichText

• Supported in all DataWindow presentation styles
• Except RichText and OLE
• Comes with Floating Font Toolbar
• Can be disabled
• Roll your own using new events, functions

62
New Column Edit Style - RichText

• RichTextToolbarActivation
• New DataWindow control property Enumerated
• Enumerated values
• RichTextToolbarActivationNever!
• RichTextToolbarActivationOnEdit!
• RichTextToolbarActivationAlways!

63
New Column Edit Style - RichText

• New Events

• RichTextCurrentStyleChanged
• pbm_dwnrichtextcurrentstlechanged (long row,
  DWObject dwo)
• RichText column has focus
• The current style of the selection or cursor
  position has changed
• RichTextLoseFocus
• pbm_dwnrichtextlosefocus (long row, DWObject dwo)
• RichText column loses focus
• RichTextLimitError
• pbm_dwnrichtextlimiterror (long row, DWObject
  dwo, string text)
• RichText data exceeds column size
• The text argument is the plain text of the
  current column

64
New Column Edit Style - RichText

• New Functions for getting and setting text
• Style (bold/underline/italic)
• Color
• Size
• Alignment
• Font

65
New DirectX Rendering for 3D Graph Styles

• DirectX 9.0c (Direct3D) Prerequisite
• Depends on drivers supporting Direct3D
• Graceful degradation to traditional rendering in
  case Direct3D is absent
• Support can be checked by running DXDIAG.exe from
  a command prompt
• Installed by PowerBuilder 11.5 for the developer
  on first use
• Anti-aliasing should be disabled

66
New DirectX Rendering for 3D Graph Styles

• New Functions
• GetSeriesTransparency/SetSeriesTransparency
• GetDataTransparency/SetDataTransparency
• GetSeriesLabelling/SetSeriesLabelling
• GetDataLabelling/SetDataLabelling

67
SUMMARY PowerBuilder 11.5

• Delivers Core Functionality Enhancements
• DataWindow Look and Feel
• Support for Newer DBMS versions
• .NET Interoperability Language Enhancements
• .NET Code Access Security
• IIS7 and Vista

68
Advanced PowerBuilder 11.5 Education

• Moving to PowerBuilder 11.5 (DEV545)
• PowerBuilder 11.1, 11.2 and 11.5 changes
  and enhancements
• .NET enhancements and target integration with
  EAServer 6.1
• Configure CAS (Code Access Security) security
  zones for .NET targets
• Advanced Web Services in WinForm and WebForm
  applications
• Fast Track to PowerBuilder Part II (DEV633)
• Taught on PowerBuilder 11.5
• Focus on advanced client/server application
  development
• Gain higher-level expertise to build and deploy
  fully functional applications using
  PowerBuilders more advanced features

Sybase Education provides a wide range of
training delivery options Onsite, SyberLearning
LIVE, SyberLearning OnDemand and Learning Center
Attend a class by December 31, 2008 and receive
a 20 discount (NA CAN only)
www.sybase.com/professional-services/education
69
QAThank you.