Transcript The Title Will Go Here - PVX Plus Technologies

ProvideX
Data Dictionary &
Views System
Presented by:
Patrizio Lucci
Presentation Overview
 Data Dictionary Maintenance Enhancements
 Data Dictionary Object Suite
 Views System Enhancements
Data Dictionary Maintenance Enhancements
• Data Dictionary Merge Utility
• Zlib Compression Type
• Signed Integer Key Segment Support
Data Dictionary Maintenance Enhancements
Data Dictionary Merge Utility
• Available in three forms
• An interactive utility in Data Dictionary Maintenance
• Object method of the *dict/database and *dict/pvxdb object
Merge
Merge
Merge
Merge
(SourceDDF$, SourceTable$, DestinationDDF$, MergeOption$)
(SourceDDF$, DestinationDDF$, MergeOption$)
(SourceChannel, SourceTable$, DestinationChannel, MergeOption$)
(SourceChannel, DestinationChannel, MergeOption$)
• A callable program
CALL “*dict/merge;Merge_Tables”,SourceDDF$,SourceTable$,DestinationDDF$,MergeOption$
CALL “*dict/merge;Merge”,SourceChannel,SourceTable$,DestinationChannel,MergeOption$
All methods and call properties are fully documented
in the new ProvideX Data Dictionary Manual
Data Dictionary Maintenance Enhancements
Data Dictionary Merge Utility
Information about the
currently selected item
Information is organized
by data group.
Data Dictionary Maintenance Enhancements
Data Dictionary Merge Utility
Replace Contents
Data Dictionary Maintenance Enhancements
Data Dictionary Merge Utility
Merge Contents
Data Dictionary Maintenance Enhancements
Data Dictionary Merge Utility
Skip
Data Dictionary Maintenance Enhancements
Zlib Compression
• ZLib Compression is for VLR and EFF files only
• Systems must be capable of dynamically loading the ZLib DLL
(Windows) or shared library object (UNIX) in order to create
physical files that are Zlib Compressed
• New TCB(195) will return 1 if ZLib support is available
Data Dictionary Maintenance Enhancements
Signed Integer Key Segment Support
• Now signed integers will be sorted correctly
• Solution is flipping the high order bit (Sign bit) on all signed
integers in the key segment, which results in the following
sort sequence:
0x80000000
...
0xFFFFFFFE
0xFFFFFFFF
0x000000000
0x000000001
0x000000002
...
0x7FFFFFFF
Largest negative # becomes
negative 2
negative 1
zero
one
two
highest positive # becomes
0x00000000 (Lowest key)
...
becomes 0x7FFFFFE
becomes 0x7FFFFFF
becomes 0x80000000
becomes 0x80000001
becomes 0x80000002
...
0xFFFFFFFF (Highest key)
Data Dictionary Object Suite
Consists of 3 Main Objects
DataBase
• Creating and maintaining Dictionary information
(providex.ddf and providex.dde)
• Basically provides the same functionality as Data
Dictionary Maintenance interface
PVXdb
• Creating and maintaining embedded dictionary of your
physical file
ODBsql, OCIsql or DB2sql
• New for Version 7
• Creating and maintaining relational Data Base information
(SqlServer, MySql, Access, Oracle and DB2)
All methods and properties are fully documented in
the new ProvideX Data Dictionary Manual
Data Dictionary Object Suite
Entity Objects
Control Objects
Control Objects
Views Enhancements
• New Wizard Look
• SQL Database Support
• Logic Procedures
• Free-Form Filters
• Import/Export Utilities
• Object Interface for Creating Views
• New ways to accessing View Data
• Views Deployment
Views Enhancements
New Wizard Look for Data Source Maintenance
• Allows for a quicker setup
• Forces user to follow a proper procedural protocol for creating
data sources
Go to first panel
Previous sequential panel
Go to last panel
Next sequential panel
Views Enhancements
SQL Database Support
• Enables connection to ODBC (Sql Server, MySql,
Access),OCI, and DB2 at the client and/or server side
• Allows for other connection options, such as
PSWD=,USER=, etc.
• Multiple options must be separated by a semi-colon
• Sort
• Any Column
• Case
• Case sensitive
• Use upper case
• Use lower case
• Ascending or Descending sequence
Views Enhancements
SQL Database Support
Drop box selection of valid
database types (ODBC, OCI
and DB2 Local or Server)
Display the defined
primary key
Indicates the DSN name
Once connected this drop
box will contain a list of
available tables
Supports all OPEN parameters for connecting via ODBC, OCI and DB2
as specified in the ProvideX Language Reference Manual
Views Enhancements
SQL Database Support
Specifying case
Drop down list of all
columns in table.
This drop down list
offers a choice of
Ascending or
Descending
Views Enhancements
Logic Procedures
• Enable you to specify logic to be performed at various
levels.
• You have a overall Initialization, Execution and Close
Logic points.
• Within the Data Source and Views Maintenance you
can add Initialization and Close Logic points.
Views Enhancements
Logic Procedures
Execution Order
1.
2.
3.
4.
5.
6.
7.
General Initialization - when initially entering the Views system.
General Execution - prior to retrieving/displaying data.
View Initialization - when a View is opened via ’open( ) method.
Data Source Initialization - when a data source handler is established.
Data Source Close - when a data source handler is dropped.
View Close - when a View is closed via ’close( ) method.
General Close - prior to exiting the Views system.
Views Enhancements
Logic Procedures
Access General Logic
Procedures
Views Enhancements
Logic Procedures
General Initialization
logic when initially
entering the Views
system
General Close logic executed
prior to exiting the Views system
General Execution logic prior to
retrieving/displaying data.
Object Logic to perform these procedures using the
methods OnLoad( ), OnClose( ), and OnExecute( )
Views Enhancements
Logic Procedures
Data Source Close logic executed when a
data source handler is dropped
Data Source Initialization logic executed
when a data source handler is established
Object Logic to perform these procedures using the
methods OnLoad( ), OnClose( )
Views Enhancements
Logic Procedures
View Initialization logic executed
when a View is opened via ’open( )
method
Access Logic
Procedures
View Close - when a View is closed
via ’close( ) method
Object Logic to perform these procedures using the
methods OnLoad( ), OnClose( )
Views Enhancements
Free-Form Filter
• Expression must evaluate to a zero/non-zero result
• Zero value would result in a record being excluded
• Non-zero result would cause a record to be included
in the data set.
• One free-form filter is allowed per View
• Maximum expression length is 500 characters
• Filter expression may consist of references to any of
the data elements in the View
Views Enhancements
Free-Form Filter
List of columns to assist in building the free-form filter
Views Enhancements
Import/Export
• These utilities allow you to merge from one set of View
definition files (pvxview.*) into another
• Exported Views definitions are stored as formatted text
files
• Export file options
• Purge contents before export (default)
• Append to pre-existing export file
• Import utility has a easy to understand tree view with
state indicators to deal with duplicate sources
Views Enhancements
Import/Export
Information is
organized by
data group.
Export path and purge options
Information about the
currently selected item
Views Enhancements
Import/Export
Information is organized
by data group.
Information about the
currently selected item
Views Enhancements
Object Interface for Creating Views
•
•
•
Provides same functionality programmatically, as the interactive
Data Source Maintenance and View Maintenance
ViewCtl object delegates functionality to subordinate objects to
deal with Views, Data Source and Data Group definitions
These subordinate objects delegate functionality to deal with Views
items, data source items, and relationships
ObjID = NEW ("*views/viewctl [,ViewsDirectory$], ERR=stmtref)
All methods and properties are fully documented in
the Views Version 7 Manual
Views Enhancements
New Ways to Access View Data
• You can now programmatically alter a view definition
before the data is retrieved
• This is all possible because you can now pass an
object identifier to the View object
VCtl=NEW("*views/viewctl",err=DoErr)
Vu=VCtl'Load("View: Customer")
VCtl'RemoveItem(Vu,"cls_desc")
View=NEW("*views/view",VCtl)
View'open(Vu)
VCtl
View: Customer
View
VCtl
Views Enhancements
Views Deployment
like
IClient
will
Nowexport
Iwould
just need
the
to add
view
to and
Import
ftp this
the
OrderDate
to
text file
view
toin.
thethis
ProvideX Developer
view.
client
site.
Web Site with Views
Clients System
End of
Presentation
THANK YOU!