Abc
Case Sensitivity
Naming Conventions
Access
Additional Data Type Information
Assign DB2 Data Types
Assign DB2 Names
Assign Table Spaces
Assigning Access Names
Check Constraints
Column Name Assignments
Create DB2 Application
DATES - caveats with date arithmetic
DB2 Compile Options
DB2 Database Options
DB2 Naming Rules
DB2 Relationships to Access
DB2 Table Rebuild Required
DB2 Update Status Page
DB2 Version Dependent Names
DB2 Viewer
Default Values
Development Modes
Extended Alterations - Access Vs. DB2 Table Definition Form
Extended Alterations - Data Type Changes
Extended Pattern Matching
Import DB2 Database
Import Options
Import Output Log
Important Migration Guidelines
Include Object Types for Migration
Indexes
Installation Notes
Intrinsic Constants
Linked Data Stores
Migrating Linked Access databases
Naming Conventions
NOT NULL to Required
Operating Requirements
Primary and Unique Keys
Reasons for Extended Alterations
Relationships
Required Property
Schema Name
Scriptoria for DB2 Main Menu
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
Setup Options
System Catalog
Tables - maximum page size exceeded
User-Defined Function Options
VB Built-in Function Substitutions
Access 2000
Setup Options
Access 2000: Scriptoria
Setup Options
Access 2000/2
Inherited Access Properties
Access 2002
Operating Requirements
Access 97
Setup Options
Access 97: Scriptoria
Setup Options
Access Add-in
Registering the Scriptoria Add-in
Access Add-in Manager
Registering the Scriptoria Add-in
Access application
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
Access AutoNumber
Additional Data Type Information
Access Binary
Additional Data Type Information
Access Data Type
DB2 to Access Data Type Conversion
Equivalent DB2 Data Types
Access Data Type Conversion
DB2 to Access Data Type Conversion
Access Database
Import Options
Access Date
Additional Data Type Information
Access Default Values
DB2 to Access Defaults
Default Values
Extended Alterations - Data Type Changes
User-Defined Function Options
Access Default Values: Changing
Extended Alterations - Data Type Changes
Access Defaults
DB2 to Access Defaults
Access Defaults: DB2
DB2 to Access Defaults
Access Field
DB2 Table Rebuild Required
Extended Alterations - Data Type Changes
Validation Rules
Access Forms
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
Access Grid Features
System Catalog
Access Hyperlink
Additional Data Type Information
Extended Alterations - Data Type Changes
Access Hyperlink: corresponding
Extended Alterations - Data Type Changes
Access ID_NO
Extended Alterations - Access Vs. DB2 Table Definition Form
Access Insert
Scriptoria Tutorial Part 2 - the Application
Access Insert: Choose
Scriptoria Tutorial Part 2 - the Application
Access Lookup List
Additional Data Type Information
Access Names
Assigning Access Names
Access Names: Assigning
Assigning Access Names
Access Queries
Consequences for Extended Table Alteration
Access Queries: existing
Consequences for Extended Table Alteration
Access Table/Field Property
Inherited Access Properties
Access Tables
Assign DB2 Data Types to Individual Columns
Assign Table Spaces
Scriptoria for DB2 Main Menu
Access Text
Additional Data Type Information
Access Tools
Installation Notes
Scriptoria Tutorial Part 1 - the Database
Access Tools: choosing
Scriptoria Tutorial Part 1 - the Database
Access Validation Rules
Extended Pattern Matching
Validation Rules
Access Validation Rules: DB2 Relationships
DB2 Relationships to Access
Access Validation Rules: names
DB2 Table Rebuild Required
Extended Alterations - Access Vs. DB2 Table Definition Form
Migrating Linked Access databases
Acknowledgement
DB2 Update Status Page
Active-X
Operating Requirements
Setup Options
ActiveX
Operating Requirements
Ad-Hoc Queries
Ad-Hoc Queries
Ad-Hoc Query item
Ad-Hoc Queries
Ad-Hoc Query menu
Ad-Hoc Queries
Add
Additional Data Type Information
Development Modes
Important Migration Guidelines
Scriptoria Tutorial Part 2 - the Application
Add-ins
Scriptoria Tutorial Part 1 - the Database
Setup Options
Starting Scriptoria
Add-ins menu
Installation Notes
Add AutoNumber
Add Primary Keys
Reasons for Extended Alterations
Add New Database
Add New Database
Add New Database: AutoNumber
Additional Data Type Information
Development Modes
Important Migration Guidelines
Add New Database: Command Button
Scriptoria Tutorial Part 2 - the Application
Additional Data Type Information
Additional Data Type Information
Administrators
Operating Requirements
AIX
Operating Requirements
Alias
Supply Database Alias
All Access
Scriptoria for DB2 Main Menu
Allow Zero Length
Inherited Access Properties
Alt ti3
Starting Scriptoria
Alt tii
Starting Scriptoria
Alt tiu
Starting Scriptoria
ALTER
Additional Data Type Information
ALTER TABLE
Default Values
Development Modes
Extended Alterations - Access Vs. DB2 Table Definition Form
Extended Alterations - Data Type Changes
Validation Rules
Although Access
Reasons for Extended Alterations
Always Include
User-Defined Function Options
Always Use UDF’s
Validation Rules
An Internet
Prerequisites
Analysis
DB2 Update Status Page
Analysis Phase
DB2 Update Status Page
Analyze
Important Migration Guidelines
AS/400
Supply System Information
Asc
VB Built-in Function Substitutions
AscB
VB Built-in Function Substitutions
ASCII
DB2 Naming Rules
VB Built-in Function Substitutions
AscW
VB Built-in Function Substitutions
Assign DB2
Column Name Assignments
Assign DB2 Data Types
Assign DB2 Data Types
Assign DB2 Data Types to Individual Columns
Assign DB2 Data Types: Individual Columns
Assign DB2 Data Types to Individual Columns
Assign DB2 Names
Assign DB2 Names
Assign Object Names menu item
Assign DB2 Names
Assign Object Names”
Migrating Linked Access databases
Assign Table Spaces
Assign Table Spaces
Assign Table Spaces menu
Assign Table Spaces
Assigned Access Name
Naming Conventions
Assigning
Assigning Access Names
Assigning: Access Names
Assigning Access Names
Assigning: Exceed
Assigning Access Names
Assigning: Exceed: Access
Assigning Access Names
Assume
Scriptoria Tutorial Part 1 - the Database
Assume: EMP_ACT
Scriptoria Tutorial Part 1 - the Database
ATable
Case Sensitivity
ATAN
VB Built-in Function Substitutions
Atn
VB Built-in Function Substitutions
Auto-Numbers
Import DB2 Database
AutoNumber
Additional Data Type Information
Development Modes
Equivalent DB2 Data Types
Extended Alterations - Data Type Changes
Important Migration Guidelines
Scriptoria Tutorial Part 1 - the Database
AutoNumber Note
Additional Data Type Information
AutoNumber Type
Extended Alterations - Data Type Changes
AVI
Scriptoria Tutorial Part 2 - the Application
BASIC
Scriptoria Tutorial Part 2 - the Application
Basic Support
Technical Support
BEFORE INSERT
Default Values
BEFORE UPDATE
Default Values
BIG INTEGER
Equivalent DB2 Data Types
BIGINT
Additional Data Type Information
DB2 to Access Data Type Conversion
Equivalent DB2 Data Types
Numeric Overflow
BIGINT: DOUBLE
Numeric Overflow
Binary
Extended Alterations - Data Type Changes
Bind DB2 Utilities”
Using Remote Databases
Bind”
Migrating Linked Access databases
Using Remote Databases
Bit Data
Extended Alterations - Data Type Changes
BLOB
DB2 to Access Data Type Conversion
Equivalent DB2 Data Types
Bound Column
Inherited Access Properties
Browse
Create DB2 Application
Bunker Hill
Technical Support
CACHE
Additional Data Type Information
Cannot Use Alter Table
Extended Alterations - Data Type Changes
Cascade Delete
Scriptoria Tutorial Part 1 - the Database
Cascade Update
Relationships
Scriptoria Tutorial Part 1 - the Database
Table Selection
Cascade Update Related Fields
Scriptoria Tutorial Part 1 - the Database
Case Sensitivity
Case Sensitivity
Caveats
DATES - caveats with date arithmetic
CBool
VB Built-in Function Substitutions
CByte
VB Built-in Function Substitutions
CCur
VB Built-in Function Substitutions
CD
Setup Options
CDate
DATES - caveats with date arithmetic
VB Built-in Function Substitutions
CDateTimeX
VB Built-in Function Substitutions
CDateX
VB Built-in Function Substitutions
CDbl
VB Built-in Function Substitutions
CDblX
VB Built-in Function Substitutions
CDec
VB Built-in Function Substitutions
Changes
DB2 Compile Options
Development Modes
Extended Alterations - Access Vs. DB2 Table Definition Form
Extended Alterations - Data Type Changes
Scriptoria Tutorial Part 1 - the Database
Changes: Data Model
Scriptoria Tutorial Part 1 - the Database
Changes: DB2
DB2 Compile Options
Development Modes
Changes: PHONENO
Extended Alterations - Access Vs. DB2 Table Definition Form
Extended Alterations - Data Type Changes
CHAR
Additional Data Type Information
Equivalent DB2 Data Types
Extended Alterations - Data Type Changes
Tables - maximum page size exceeded
VB Built-in Function Substitutions
Character
Assign DB2 Data Types to Individual Columns
Character (Text) Data Type Pop-up Form
DB2 to Access Data Type Conversion
CHECK
Import Output Log
Inherited Access Properties
User Error Messages
Validation Rules
Check Constraints
Check Constraints
Check Constraints: Validation Rules
Check Constraints
CHECK PENDING
Tables/Views Page
Checking
Development Modes
Scriptoria Tutorial Part 1 - the Database
Checking: Enforce Referential Integrity
Scriptoria Tutorial Part 1 - the Database
Choose Options
Assign Table Spaces
User Error Messages
Choose Scriptoria
Scriptoria Tutorial Part 1 - the Database
Choose Scriptoria: DB2
Scriptoria Tutorial Part 1 - the Database
Chr
VB Built-in Function Substitutions
ChrB
VB Built-in Function Substitutions
ChrW
VB Built-in Function Substitutions
CInt
VB Built-in Function Substitutions
CIntX
VB Built-in Function Substitutions
Clicking
Scriptoria Tutorial Part 1 - the Database
Clicking: EMPNO
Scriptoria Tutorial Part 1 - the Database
Client Configuration Assistant
DB2 Client Configuration Assistant
Operating Requirements
Using Remote Databases
Client Configuration Assistant menu
Test Database Connection
Client Configuration Assistant menu: Start
DB2 Client Configuration Assistant
Client Configuration Assistant menu: use
DB2 Client Configuration Assistant
Using Remote Databases
Clipper
Linked Data Stores
CLng
VB Built-in Function Substitutions
CLngX
VB Built-in Function Substitutions
CLOB
DB2 to Access Data Type Conversion
Equivalent DB2 Data Types
Tables - maximum page size exceeded
CLUSTER
Primary Keys and Indexes
Column Count
Inherited Access Properties
Column Data
Extended Alterations - Data Type Changes
Column Heads
Inherited Access Properties
Column Name Assignments
Column Name Assignments
Column Widths
Inherited Access Properties
Combo Box
Inherited Access Properties
Command Button
Scriptoria Tutorial Part 2 - the Application
Command Button: Add
Scriptoria Tutorial Part 2 - the Application
Compact Setup
Setup Options
Compares
DB2 Update Status Page
Compares: Access
DB2 Update Status Page
Concatenation
VB Built-in Function Substitutions
Concatenation: String
VB Built-in Function Substitutions
Connecting
DB2 Authentication
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
Supply System Information
Connecting: DB2
DB2 Authentication
Connecting: EMPLOYEE
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
Connecting: IBM
Supply System Information
Connecting: Unix
Supply System Information
Consequences
Consequences for Extended Table Alteration
Consequences: Extended Table Alterations
Consequences for Extended Table Alteration
Control
Operating Requirements
Conventions
Naming Conventions
Conventions: Naming
Naming Conventions
CREATE
Indexes
Create DB2 Application
Create DB2 Application
Create DB2 Application item
Scriptoria Tutorial Part 2 - the Application
Create DB2 Application item: repeat
Create DB2 Application
CREATE INDEX
Primary and Unique Keys
Create Script Only
DB2 Compile Options
Creating
Assign DB2 Data Types
Create DB2 Application
DB2 Database Connection Form
DB2 Database Options
Import Output Log
Scriptoria Tutorial Part 2 - the Application
Tables - maximum page size exceeded
Creating: Access
Create DB2 Application
Import Output Log
Creating: DB2
Assign DB2 Data Types
DB2 Database Connection Form
Tables - maximum page size exceeded
Creating: Form
Scriptoria Tutorial Part 2 - the Application
Creating: On Current Event Procedure
Scriptoria Tutorial Part 2 - the Application
Creating: Query
Scriptoria Tutorial Part 2 - the Application
CSng
VB Built-in Function Substitutions
CSngX
VB Built-in Function Substitutions
CStr
VB Built-in Function Substitutions
Ctrl-key
Table Selection
Ctrl-key: holding
Table Selection
Current Access Vs Existing DB2 Table Definition
DB2 Table Rebuild Required
CURRENT DATE
Check Constraints
Validation Rules
VB Built-in Function Substitutions
CURRENT TIME
Check Constraints
Validation Rules
VB Built-in Function Substitutions
CURRENT TIMESTAMP
Check Constraints
Validation Rules
VB Built-in Function Substitutions
Custom Setup
Setup Options
CVDate
VB Built-in Function Substitutions
Data Definition Language
Import Options
Schema Name
User-Defined Function Options
Data Link
Additional Data Type Information
Extended Alterations - Data Type Changes
Data Link Features
Extended Alterations - Data Type Changes
Data Link Features: Specifying
Additional Data Type Information
Data Links Server
Additional Data Type Information
Data Model
Scriptoria Tutorial Part 1 - the Database
Data Model Changes
Scriptoria Tutorial Part 1 - the Database
Data Model Changes: changes
Scriptoria Tutorial Part 1 - the Database
Data Model Changes: Synchronizing
Scriptoria Tutorial Part 1 - the Database
Data Safe
Extended Alterations - Data Type Changes
Data Type Changes
Extended Alterations - Access Vs. DB2 Table Definition Form
Extended Alterations - Data Type Changes
Data Type Conversion Status
Extended Alterations - Data Type Changes
Data Type Pop-up Form
Character (Text) Data Type Pop-up Form
Database
Scriptoria Tutorial Part 1 - the Database
Database Name
Supply Database Alias
Database Utilities
Important Migration Guidelines
DataLink
Additional Data Type Information
Assign DB2 Data Types to Individual Columns
DB2 to Access Data Type Conversion
Equivalent DB2 Data Types
DataLink Features Data Type Pop-up Form
DataLink Features Data Type Pop-up Form
Datasheet
Column Name Assignments
DATE
DATES - caveats with date arithmetic
DB2 to Access Data Type Conversion
Equivalent DB2 Data Types
Extended Alterations - Data Type Changes
VB Built-in Function Substitutions
Date arithmetic
DATES - caveats with date arithmetic
Date Only
DATES - caveats with date arithmetic
Date Time
Additional Data Type Information
DATES - caveats with date arithmetic
Date/Time
Equivalent DB2 Data Types
Date/Timestamp
VB Built-in Function Substitutions
DATE_ONLY
DATES - caveats with date arithmetic
DATE_TIME
DATES - caveats with date arithmetic
DateAdd
DATES - caveats with date arithmetic
VB Built-in Function Substitutions
DateDiff
VB Built-in Function Substitutions
DatePart
VB Built-in Function Substitutions
DATES
DATES - caveats with date arithmetic
DateSerial
VB Built-in Function Substitutions
DateTime
DB2 to Access Data Type Conversion
VB Built-in Function Substitutions
DateValue
VB Built-in Function Substitutions
DAY
VB Built-in Function Substitutions
DAYOFWEEK
VB Built-in Function Substitutions
DAYOFYEAR
VB Built-in Function Substitutions
DB Name
DB2 Database Options
Scriptoria Tutorial Part 1 - the Database
DB2
Ad-Hoc Queries
Additional Data Type Information
Assign DB2 Data Types
Assign DB2 Data Types to Individual Columns
Assign DB2 Names
Assign Table Spaces
Assigning Access Names
Case Sensitivity
Check Constraints
Column Name Assignments
Consequences for Extended Table Alteration
Create DB2 Application
DataLink Features Data Type Pop-up Form
DATES - caveats with date arithmetic
DB2 Authentication
DB2 Client Configuration Assistant
DB2 Compile Options
DB2 Database Connection Form
DB2 Database Options
DB2 Databases and Schemas
DB2 Naming Rules
DB2 Relationships to Access
DB2 Table Rebuild Required
DB2 to Access Data Type Conversion
DB2 to Access Defaults
DB2 Update Status Page
DB2 Version Dependent Names
DB2 Viewer
Declarative versus Explicit constraints
Default Values
Development Modes
Extended Alterations - Access Vs. DB2 Table Definition Form
Extended Alterations - Data Type Changes
Extended Pattern Matching
Foreign-keys Page
Import DB2 Database
Import Options
Import Output Log
Important Migration Guidelines
Include Object Types for Migration
Index - maximum columns exceeded
Indexes
Installation Notes
Intrinsic Constants
Linked Data Stores
Migrating Linked Access databases
Naming Conventions
NOT NULL to Required
Operating Requirements
Operators
Prerequisites
Primary and Unique Keys
Primary Keys and Indexes
Reasons for Extended Alterations
Register ODBC Data Source
Relationships
Required Property
Schema Name
Scriptoria for DB2 Main Menu
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
Starting Scriptoria
System Catalog
Table Name Assignments
Tables - maximum page size exceeded
Tables/Views Page
Test Database Connection
Triggers Page
User-Defined Function Options
Validation Rules
VB Built-in Function Substitutions
Welcome
DB2 Administrator
Operating Requirements
DB2 Administrator Authority
Operating Requirements
DB2 ALTER TABLE
Development Modes
DB2 AS/400
Operating Requirements
DB2 Authentication
DB2 Authentication
DB2 BIGINT
Numeric Overflow
DB2 BIGINT: UDF
Numeric Overflow
DB2 BLOB
Scriptoria Tutorial Part 2 - the Application
DB2 CHAR
Additional Data Type Information
DB2 CHAR: includes
Additional Data Type Information
DB2 CHECK
Validation Rules
DB2 CHECKcounterparts
Validation Rules
DB2 Client
Operating Requirements
DB2 Client Configuration Assistant
DB2 Client Configuration Assistant
DB2 Database Options
Using Remote Databases
DB2 Client Configuration Assistant: use
DB2 Database Options
Using Remote Databases
DB2 Column
DB2 Table Rebuild Required
Extended Alterations - Access Vs. DB2 Table Definition Form
Extended Alterations - Data Type Changes
DB2 Column: Matching
Extended Alterations - Access Vs. DB2 Table Definition Form
DB2 Compatible Pattern Matching
Extended Pattern Matching
DB2 Compile Options
DB2 Compile Options
DB2 Connect
Operating Requirements
DB2 CREATE UNIQUE INDEX
Primary and Unique Keys
DB2 Data
Tables/Views Page
DB2 Data Link
Additional Data Type Information
Extended Alterations - Data Type Changes
DB2 Data Type
DB2 to Access Data Type Conversion
DB2 Data Type: Viewing
Tables/Views Page
DB2 Database Options
DB2 Database Options
DB2 Database Selection Form
DB2 Database Connection Form
DB2 Databases
DB2 Databases and Schemas
DB2 DATALINK
Additional Data Type Information
DB2 DATE
Additional Data Type Information
DB2 Default
Extended Alterations - Data Type Changes
DB2 Default Data Type Settings
Assign DB2 Data Types
DB2 DEFAULTS
Import Output Log
DB2 Equivalent
VB Built-in Function Substitutions
DB2 Import
DB2 Update Status Page
DB2 INDEXES
Primary Keys and Indexes
DB2 INDEXES: generating
Primary Keys and Indexes
DB2 Lobs
Scriptoria Tutorial Part 2 - the Application
DB2 Main Menu
Scriptoria for DB2 Main Menu
DB2 Main Menu: Scriptoria
Scriptoria for DB2 Main Menu
DB2 Name
Extended Alterations - Access Vs. DB2 Table Definition Form
Naming Conventions
DB2 Name: Use
Extended Alterations - Access Vs. DB2 Table Definition Form
DB2 Naming Conventions
DB2 Naming Rules
DB2 Naming Rules
DB2 Naming Rules
DB2 ODBC
Create DB2 Application
DB2 Performance
Important Migration Guidelines
DB2 PRIMARY KEYS
Primary and Unique Keys
DB2 Primary
Indexes
DB2 Program Group
DB2 Client Configuration Assistant
DB2 REFERENCE
Additional Data Type Information
DB2 Relationships
DB2 Relationships to Access
DB2 Relationships: Access
DB2 Relationships to Access
DB2 Row Size
Additional Data Type Information
DB2 SAMPLE
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
DB2 SAMPLE: Select
Scriptoria Tutorial Part 1 - the Database
DB2 SAMPLE: structure
Scriptoria Tutorial Part 2 - the Application
DB2 SQL
DB2 Update Status Page
DB2 SQL Reference
Tables - maximum page size exceeded
DB2 SQL Reference: shows
DB2 Update Status Page
DB2 System Catalog
System Catalog
DB2 Table Definition Form
Extended Alterations - Access Vs. DB2 Table Definition Form
DB2 Table Definitionform
DB2 Table Rebuild Required
DB2 Table Rebuild Required
DB2 Table Rebuild Required
DB2 Table Spaces
Assign Table Spaces
DB2 TIMESTAMP
Additional Data Type Information
DB2 Translation
VB Built-in Function Substitutions
DB2 Type
Assign DB2 Data Types to Individual Columns
DB2 Type Combo-box
Assign DB2 Data Types to Individual Columns
DB2 UDB Version 5/6/7
Operating Requirements
DB2 UDB Version 5/6/7: Unix
Operating Requirements
DB2 UDB Version 5/6/7: Windows 95/98/2000
Operating Requirements
DB2 UDF’s
VB Built-in Function Substitutions
DB2 UNIQUE KEYS
Primary and Unique Keys
DB2 Unix
Operating Requirements
DB2 Unix: Scriptoria
Operating Requirements
DB2 Update Status Page
DB2 Update Status Page
DB2 User-Defined Function
Extended Pattern Matching
User-Defined Function Options
DB2 User Defined Functions
Validation Rules
DB2 User ID
Schema Name
Test Database Connection
DB2 User ID: defaults
Schema Name
DB2 User ID: enter
Test Database Connection
DB2 Utilities
Test Database Connection
DB2 Version Dependent Names
DB2 Version Dependent Names
DB2 Viewer
DB2 Viewer
DB2 Viewer: Access Data Type Conversion
DB2 to Access Data Type Conversion
DB2 Viewer: Access Defaults
DB2 to Access Defaults
DB2 Viewer: connect
DB2 Authentication
DB2 Viewer: deploying
DB2 Update Status Page
DB2 Viewer: generating
DB2 Version Dependent Names
DB2 Viewer: importing
Additional Data Type Information
DB2 Naming Rules
Import Output Log
Scriptoria Tutorial Part 1 - the Database
DB2 Viewer: matching
Extended Alterations - Data Type Changes
Linked Data Stores
DB2 Viewer: migrating
Assign DB2 Names
DB2 Viewer: OS/390
DB2 Naming Rules
Include Object Types for Migration
Primary and Unique Keys
Relationships
Tables/Views Page
DB2 Viewer: OS/390 Version 6.1
Operating Requirements
DB2 Viewer: progress
DB2 Update Status Page
DB2 Viewer: Scriptoria
Extended Pattern Matching
Operating Requirements
Starting Scriptoria
Welcome
DB2 Viewer: SQL
Ad-Hoc Queries
DB2 Viewer: Use
DB2 Viewer
DB2/6000 PE
Operating Requirements
DB2/Intel
Validation Rules
DB2/Intel: Scriptoria
Validation Rules
DB2Client
Installation Notes
DBase
Linked Data Stores
DCOM
Operating Requirements
DDL
DB2 Compile Options
DB2 Update Status Page
DDL: generating
DB2 Compile Options
DDL: view
DB2 Update Status Page
Decimal
Additional Data Type Information
Assign DB2 Data Types to Individual Columns
Equivalent DB2 Data Types
Numeric Overflow
Decimal Data Type Pop-up Form
Decimal Data Type Pop-up Form
Declarative versus Explicit constraints
Declarative versus Explicit constraints
DEFAULT
Import Output Log
Default Data Type Settings
Additional Data Type Information
Default Value
Default Values
Inherited Access Properties
Required Property
Default Value: specifying
Default Values
Default View
Inherited Access Properties
Default”
Reasons for Extended Alterations
Defaults
Additional Data Type Information
DB2 Databases and Schemas
Reasons for Extended Alterations
Schema Name
Defaults: 20
Additional Data Type Information
Defaults: DB2 User Id
Schema Name
Defaults: User ID
DB2 Databases and Schemas
DEPARTMENT
Scriptoria Tutorial Part 1 - the Database
Deploy Immediately
DB2 Compile Options
Deploying
Assign DB2 Names
DB2 Update Status Page
Deploying: DB2
DB2 Update Status Page
Deployment
DB2 Update Status Page
Deployment Phases
DB2 Update Status Page
DEPTNAME
Scriptoria Tutorial Part 1 - the Database
DEPTNO
Scriptoria Tutorial Part 1 - the Database
Development Modes
Development Modes
Display
Assign DB2 Names
Assign Table Spaces
Column Name Assignments
Display Control
Inherited Access Properties
Display Control: Assign Table Spaces menu
Assign Table Spaces
Display Control: datasheet
Column Name Assignments
Display Control: Object Name Assignments
Assign DB2 Names
DISTINCT TYPE
DB2 to Access Data Type Conversion
DML
DB2 Update Status Page
Domain Server Name
Prerequisites
Supply TCP/IP Address
DOS/VSE
Operating Requirements
DOUBLE
DB2 to Access Data Type Conversion
Equivalent DB2 Data Types
Numeric Overflow
VB Built-in Function Substitutions
DOUBLE: BIGINT
Numeric Overflow
Dragging
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
Dragging: EMPNO
Scriptoria Tutorial Part 1 - the Database
Dragging: PHOTO_FORMAT
Scriptoria Tutorial Part 2 - the Application
Dropping
Tables/Views Page
Dropping: User Tables
Tables/Views Page
DSN
Prerequisites
EMP_ACT
Scriptoria Tutorial Part 1 - the Database
EMP_ACT: assume
Scriptoria Tutorial Part 1 - the Database
EMP_ACT: defined
Scriptoria Tutorial Part 1 - the Database
EMP_PHOTO
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
EMP_RESUME
Scriptoria Tutorial Part 1 - the Database
EMP_TABLE
Scriptoria Tutorial Part 2 - the Application
EMPLOYEE
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
EMPLOYEE: connecting
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
EMPLOYEE: join
Scriptoria Tutorial Part 2 - the Application
EMPLOYEES
Scriptoria Tutorial Part 1 - the Database
Employee Photo Maintenance
Scriptoria Tutorial Part 2 - the Application
Employee Photo Maintenance: open
Scriptoria Tutorial Part 2 - the Application
Employee Photo Maintenance: See
Scriptoria Tutorial Part 2 - the Application
Employee Photos
Scriptoria Tutorial Part 2 - the Application
Employee Photos Application
Scriptoria Tutorial Part 2 - the Application
Employee Photos Application: Maintaining
Scriptoria Tutorial Part 2 - the Application
Employee Photos Application: selecting
Scriptoria Tutorial Part 2 - the Application
EMPNO
Scriptoria Tutorial Part 1 - the Database
Scriptoria Tutorial Part 2 - the Application
EMPNO: Clicking
Scriptoria Tutorial Part 1 - the Database
EMPNO: contains
Scriptoria Tutorial Part 1 - the Database
EMPNO: dragging
Scriptoria Tutorial Part 1 - the Database
EMPNO: include
Scriptoria Tutorial Part 1 - the Database
EMPNO: need
Scriptoria Tutorial Part 2 - the Application
Enforce
Relationships
Enforce Referential Integrity
Scriptoria Tutorial Part 1 - the Database
Enforce Referential Integrity: Checking
Scriptoria Tutorial Part 1 - the Database
Enforce Referential Integrity: specify
Relationships
Enter
Scriptoria Tutorial Part 1 - the Database
Supply TCP/IP Address
Test Database Connection
Enter: DB2 User ID
Test Database Connection
Enter: TCP/IP
Supply TCP/IP Address
Enter: User ID
Scriptoria Tutorial Part 1 - the Database
Equivalent
Operators
Equivalent DB2 Type
Equivalent DB2 Data Types
Eqv
Operators
Excel
Linked Data Stores
Exclusive Or
Operators
Existing
Additional Data Type Information
Consequences for Extended Table Alteration
DB2 Naming Rules
DB2 Table Rebuild Required
Development Modes
Extended Alterations - Data Type Changes
Include Object Types for Migration
Existing: Access
Additional Data Type Information
Existing: Access Queries
Consequences for Extended Table Alteration
Existing: DB2
Additional Data Type Information
DB2 Naming Rules
Development Modes
Extended Alterations - Data Type Changes
Include Object Types for Migration
Existing: DB2 Table Definitionform
DB2 Table Rebuild Required
Existing: Hyperlink
Additional Data Type Information
Exponential Operator
Operators
Extended Alterations
Reasons for Extended Alterations
Extended Alterations: Reasons
Reasons for Extended Alterations
Extended Pattern Matching
Extended Pattern Matching
Extended Table Alterations
Consequences for Extended Table Alteration
Extended Table Alterations Form
Extended Table Alterations: Consequences
Consequences for Extended Table Alteration
Field Collection
Import Output Log
Field List
Scriptoria Tutorial Part 2 - the Application
Field Properties
Inherited Access Properties
Firstdayofweek
VB Built-in Function Substitutions
Firstweekofyear
VB Built-in Function Substitutions
FOR BIT DATA
Additional Data Type Information
Equivalent DB2 Data Types
Extended Alterations - Data Type Changes
Foreign
Development Modes
Foreign-keys Page
Foreign-keys Page
Foreign Keys
Include Object Types for Migration
FoxPro
Linked Data Stores
Function Behavior
VB Built-in Function Substitutions
Functions
User-Defined Function Options
GENERATED ALWAYS AS INDENTITY
Additional Data Type Information
GENERATED BY DEFAULT AS IDENTITY
Additional Data Type Information
Generating
DB2 Compile Options
DB2 Version Dependent Names
Primary Keys and Indexes
Generating: DB2
DB2 Version Dependent Names
Generating: DB2 INDEXES
Primary Keys and Indexes
Generating: DDL
DB2 Compile Options
Hand-Coded SQL Example
Ad-Hoc Queries
HEX
VB Built-in Function Substitutions
Holding
Table Selection
Holding: Ctrl-key
Table Selection
Holding: Shift-key
Table Selection
Hostname
Prerequisites
Hostname: know
Prerequisites
HOUR
VB Built-in Function Substitutions
HP-Unix
Operating Requirements
HTML
Linked Data Stores
Hyperlink
Additional Data Type Information
Equivalent DB2 Data Types
IBM
DB2 Naming Rules
Supply System Information
IBM-compatible
Operating Requirements
IBM-compatible: connecting
Supply System Information
IBMSYS
System Catalog
ID
DB2 Table Rebuild Required
Extended Alterations - Access Vs. DB2 Table Definition Form
ID: remove
DB2 Table Rebuild Required
Identity
Additional Data Type Information
Assign DB2 Data Types to Individual Columns
Identity Data Type
Identity Data Type and Properties Pop-up Form
Image
Sample Basic Code
Scriptoria Tutorial Part 2 - the Application
IME Sentence Mode
Inherited Access Properties
Import DB2 Database
Import DB2 Database
Scriptoria Tutorial Part 1 - the Database
Import DB2 Database Errors
Import Output Log
Import DB2 Database item
Scriptoria Tutorial Part 1 - the Database
Import Errors Table
Import Output Log
Import Log File
Import Output Log
Import Options
Import DB2 Database
Import Options
Import Output Log
Import Output Log
Important Notes
Create DB2 Application
Important Guidelines
Important Migration Guidelines
Importing
Additional Data Type Information
DB2 Naming Rules
DB2 Update Status Page
Import Output Log
Scriptoria Tutorial Part 1 - the Database
Importing: DB2
Additional Data Type Information
DB2 Naming Rules
Import Output Log
Scriptoria Tutorial Part 1 - the Database
Include Object Types
Include Object Types for Migration
Include Object Types: Migration
Include Object Types for Migration
INCREMENT BY
Additional Data Type Information
INDEX
Indexes
Indexes
Development Modes
Index - maximum columns exceeded
Indexes
Primary Keys and Indexes
Table Selection
Individual Columns
