Description: | The DBAccess control gives access to ODBC (Open Database Connectivity) databases. |
Sample image: | 
This image is only visible at design time. The DBAccess control is invisible at execution time. |
Details: | |
Setting up database access: | See "Developing Your First ODBC Application" in the "PowerCOBOL User's Guide" for information on setting up the DBAccess control. |
Notes: | Currently the field names can be referenced by using "Title" OF CmDb1. The are case sensitive. Fields can only be referenced and set while connected to the database. Fields must be in the ODBC catalog to be selected. Make sure that you initialize all fields, including fields that are NULL. The NULL value for strings is spaces, and for numeric items is zero. Floating point and binary fields cannot be extracted. Numeric fields containing more than 14 integer digits or more than 4 decimal digits cannot be extracted. Alphanumeric fields with more than 64770 bytes cannot be extracted. No more than 64 fields can be selected. If you have problems with the cursor type or record locking options, check the documentation of your ODBC database for details of supported behaviors. When the DBAccess control sets data to a fixed-length field, the DBAccess control pads the character string with spaces to match the field length on the server side. However, when the character-code and encoding are converted by an ODBC driver, the result is incorrect. In this case, the execution mode of the DBAccess control can be modified as follows:
To remove spaces at the end of a character string use:
~~~ F5DDSTEV.EXE /DBCHARBLANKREMOVE:ON
To add spaces to the end of a character string use:
~~~ F5DDSTEV.EXE /DBCHARBLANKREMOVE:OFF
|
Properties: | AccessMode Array ClassMajorVersion ClassMinorVersion ClassProgID CommitMode Concurrency- Cursor | Condition ConnectionString Container CursorType DataBase DataSource Driver | EnableOwner- Name Index KeysetSize Left Name Parent | Password ScaleMode TargetName TargetType Top UserID |
Methods: | CloseCursor CloseDB CommitDB DeleteCurRecord DeleteRecord | ExecuteProcedure OpenDB ReadFirstRecord ReadLastRecord ReadNextRecord | ReadPrevious- Record RewriteCurRecord RewriteRecord | RollbackDB SelectRecords WriteRecord |
Events: | None |
Class ProgID name: | Fujitsu.PcobDBAccess.4 |
Corresponding Control in PowerCOBOL V3.0 or earlier: | DB Access Item |
DBAccess Control
