1 / 29

File I/O Updates, ODBC 64-bit, & SQL Command Utility

File I/O Updates, ODBC 64-bit, & SQL Command Utility. Presenter: Devon Austen. Outline. Overview How we made file I/O easier How we made file I/O more useful We live in a 64-bit world The command line is King. Overview. What’s new in the file I/O products

zudora
Download Presentation

File I/O Updates, ODBC 64-bit, & SQL Command Utility

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. File I/O Updates, ODBC 64-bit, & SQL Command Utility Presenter: Devon Austen

  2. Outline • Overview • How we made file I/O easier • How we made file I/O more useful • We live in a 64-bit world • The command line is King

  3. Overview • What’s new in the file I/O products • But first a quick discussion about key topics • What is ODBC? • Open DataBase Connectivity • Common interface standard • Uses Structured Query Language (SQL)

  4. Overview • PxPlus ODBC Driver • PxPlus implementation of ODBC API • Allows programs that use ODBC interface to connect to PxPlus data • Local or remote using file server • PxPlus File Server • Access PxPlus data on remote systems • PVKIO library • PxPlus file I/O library for accessing PxPlus data • Local or remote using file server

  5. How We Made File I/O Easier

  6. New Installers • ODBC Drivers and File Server • New and improved installers • Faster and light weight • Default install location of file I/O products now C:\PVX Plus Technologies\xxx • Installers are NOT MSI

  7. New Installers • New PxPlus ODBC driver installer

  8. New Installers • New File Server installer

  9. Case Insensitive Table Names • The ODBC driver now ignores case when processing table names in SQL commands • Reduces the number of errors • ODBC driver no longer supports table names that only differ in case

  10. TIMESTAMPADD Improvements • Scalar function TIMESTAMPADD has been enhanced • TIMESTAMPADD function adds an interval to a timestamp • Used to be limit on size of interval • Now standard integers usable for intervals

  11. Miscellaneous Improvements • File DSNs • Windows file server startup • Large tables using bookmarks • PVKIO library function Pvk_RestrictedRead • ODBC views

  12. How We Made File I/O More Useful

  13. Enhanced VLR File Support • File I/O products now support PxPlus enhanced VLR format files • Allow more than 255 key entries per key block

  14. EFF File Support • Added support for EFF files in the PVKIO library

  15. Per Connection Read Only Flag • New ODBC connection string parameterReadOnly=[0|1] • Can be set using ODBC Administrator configuration page • Can be set manually

  16. We Live In a 64-bit World Whether we like it or not

  17. Running 32-bit File I/O Applications on a 64-bit OS • 32-bit ODBC drivers can run on 64-bit OS’s • Limited to 32-bit applications • 32-bit File Servers can run on 64-bit OS’s

  18. Confusion Caused by 32-bit ODBC Driver on 64-bit Windows • On 64-bit OS’s there are two ODBC Administrators a 32-bit and a 64-bit version • 64-bit ODBC Administrator is located in:Control Panel -> Administrative Tools • 32-bit ODBC Administrator is located in:C:\Windows\SysWOW64 • 64-bit applications cannot use the 32-bit ODBC driver

  19. PxPlus 64-bit ODBC Driver • Increasing number of 64-bit platforms and applications • Current ODBC driver will not work • So we developed a 64-bit ODBC driver • Can be installed alongside the 32-bit ODBC driver • Must re-enter activation information • Use the ODBC Administrator in the control panel

  20. The Command Line is King

  21. PxPlus SQL Command Line Client • Windows & Linux versions • Windows PxPlus SQL Command Line Client installed with version 10 ODBC driver • Linux PxPlus SQL Command Line Client has separate instraller • Connects to local or remote PxPlus data and executes SQL commands

  22. When and Why to Use It • Quick and direct access to PxPlus data • Testing ODBC driver and data sources • Can be executed from web pages, scripts, and applications

  23. How to Use It • From the command line pxpsql [connection info] [options] SQL command • Example: Get all data from a local table named “products” pxpsql -d C:\pxp_data SELECT * FROM \”Sales Rep\”

  24. How to Use It • pxpsql has –h or --help parameters • Windows/Unix command line considerations • Quotes (‘/”) • Parenthesis () • Asterisks (*) • SQL syntax for table names with spaces requires quotes (“) • Escape character is (\) for Windows and Linux

  25. How to Use It • pxpsql has -c or --connection-string parameters which accept a connection string in the following format “param1=val1; param2=val2; …” Example: “Directory=/home/devon/pxp_data; RemotePVKIOHost=192.168.0.100; RemotePVKIOPort=20222;”

  26. How to Use It • pxpsql has -f or –config-file parameters • INI style file • Long style parameters • Overridden by command line parameters

  27. Demonstration • Example using pxpsql

  28. Questions?

  29. End of Presentation Thank You

More Related