home *** CD-ROM | disk | FTP | other *** search
Microsoft Windows Help File Content | 1996-10-16 | 16.6 KB | 402 lines |
- :Base IB32.HLP
- :Title InterBase Help
- :Index InterBase Glossary=ibgloss.hlp
- :Index Server Manager Help=ibmgr32.hlp
- :Index Windows ISQL Help=wisql32.hlp
- :Index SQL Reference Help=sqlref32.hlp
- :Index Dialog Help=comdg32.hlp
- :Index InterBase Tutorial=tutorial.hlp
- :Index InterBase Programmer's Guide=pg32.hlp
- :Index InterBase API Help=ibapi32.hlp
- :Index Using InterBase on Windows for NT=use_nt.hlp
- :Link ibgloss.hlp
- :Link ibmgr32.hlp
- :Link wisql32.hlp
- :Link sqlref32.hlp
- :Link comdg32.hlp
- :Link tutorial.hlp
- :Link pg32.hlp
- :Link ibapi32.hlp
- :Link use_nt.hlp
- :Link Perform.hlp
- 1 About the InterBase Server
- 2 What is InterBase?=ib_basics
- 2 Features=ib_features_table
- 2 Limits=ib_limits
- 2 Conventions & specs
- 2 Syntax conventions=syntax_conv
- 2 Database object-naming conventions=db_obj_name_conv
- 2 File-naming conventions=file_name_conv
- 2 File specifications=ib_file_specs
- 2 InterBase keywords
- 2 Reserved word list=ib_keywords
- :include use_nt.cnt
- 1 Getting started
- 2 Database objects defined
- 3 Overview=ib_db_obj
- 3 Tables=intro_tables
- 3 Columns=intro_cols
- 3 Data types=intro_data_types
- 3 Domains=intro_doms
- 3 Referential integrity constraints=intro_cons
- 3 Indexes=intro_idx
- 3 Views=intro_views
- 3 Stored procedures=intro_stor_procs
- 3 Triggers=intro_trigs
- 3 Generators=intro_gens
- 3 Security=intro_sec
- 2 Designing a database
- 3 Overview=ib_db_design
- 3 Design a framework=design_framework
- 3 Collecting and analyzing objects=collect_objs
- 3 Mapping entities and attributes=map_ents_atts
- 3 Determining unique attributes=unique_atts
- 3 Developing a set of rules=set_rules
- 3 Selecting a data type=select_data_type
- 3 Choosing international character sets=choose_char_sets
- 3 Specifying domains=specify_doms
- 3 Setting default values and NULL status=def_val_null
- 3 Defining constraints=def_constraints
- 3 Establishing relationships between objects=establish_obj_rels
- 3 How to normalize a database=normal_db
- 3 Eliminating repeating groups=no_repeat_grps
- 3 Removing partially-dependent columns=part_depend_cols
- 3 Removing transitively-dependent columns=trans_depend_cols
- 3 How to choose indexes=choose_idxs
- 3 InterBase-specific design suggestions=ib_suggest
- :Include Tutorial.cnt
- 2 Example database: EMPLOYEE.GDB
- 3 Overview=use_ex_db
- 3 Domains=ex_db_doms
- 3 Triggers=ex_db_trigs
- 3 Stored procedures=ex_db_stor_procs
- 3 EMPLOYEE table=emp_tbl
- 3 DEPARTMENT table=dept_tbl
- 3 JOB table=job_tbl
- 3 SALES table=sales_tbl
- 3 PROJECT table=proj_tbl
- 3 CUSTOMER table=cust_tbl
- 3 EMPLOYEE_PROJECT table=emp_proj_tbl
- 3 PROJ_DEPT_BUDGET table=proj_dept_budget_tbl
- 3 COUNTRY table=country_tbl
- 3 SALARY_HISTORY table=sal_hist_tbl
- 1 Performance Tuning
- :include Perform.cnt
- 1 How to create a database
- 2 Overview=how_create_dbs
- 2 General procedures
- 3 Using a data definition file=data_def_file
- ;3 Using CREATE DATABASE =use_create_db
- 3 Creating a single-file database=single_file_db
- 3 Creating a multi-file database=multi_file_db
- 3 Specifying user name and password=spec_name_pass
- 3 Specifying database page size=spec_page_size
- 3 Specifying the default character set=spec_def_char_set
- 3 How to alter databases=how_alter_dbs
- 3 How to drop databases=how_drop_dbs
- 3 How to extract metadata from existing databases=how_extract_dbs
- 2 Working with tables
- 3 How to create tables=how_create_tbls
- 3 Using the EXTERNAL FILE option=use_ext_files
- 3 Importing data from external files=import_data
- 3 Exporting data to an external file=export_data
- 2 Working with columns
- 3 How to define columns=def_cols
- 3 Data types
- 4 Specifying the data type=spec_data_type
- 4 Numeric data types=numeric_dts
- 4 Integer data types=integer_dts
- 4 Fixed-decimal data types=fixed_dec_dts
- 4 Floating-point data types=float_point_dts
- 4 Character data types=char_string_dts
- 4 Fixed-length character data=fixed_char_dts
- 4 Variable-length character data=var_char_dts
- 4 The DATE data type=date_dts
- 4 BLOB data types=blob_dts
- 4 BLOB columns=blob_cols
- 4 BLOB segment length=blob_seg_length
- 4 BLOB subtypes=blob_subtypes
- 4 BLOB Filters=ar_BLOB_Filters
- 4 Defining Arrays=ar_Defining_Arrays
- 4 Multi-dimensional Arrays=ar_Multidimensional_Arrays
- 4 Specifying Subscript Ranges For Array Dimensions=ar_Specifying_Subscript_Ranges_For_Array_Dimensions
- 4 Converting data types=conv_data_types
- 4 Defining domain-based columns=dom_based_cols
- 4 Computed columns=computed_cols
- 4 Column default values=col_def_vals
- 3 Domains
- 4 How to create domains=how_create_doms
- 4 Domain data type=dom_data_type
- 4 Domain collation order=dom_coll_order
- 4 Domain default values=dom_def_vals
- 4 Domain CHECK constraints=dom_check_cons
- 4 How to alter domains=how_alter_doms
- 4 How to drop domains=how_drop_doms
- 3 Referential integrity constraints
- 4 Integrity constraints=col_int_cons
- 4 PRIMARY KEY and UNIQUE constraints=primary_cons
- 4 FOREIGN KEY constraints=foreign_cons
- 4 Circular references=circle_refs
- 4 How to declare constraints=how_declare_cons
- 4 Specifying NOT NULL=col_not_null
- 4 CHECK constraints=col_check_cons
- 4 Specifying a character set=col_char_sets
- 4 How to alter tables=how_alter_tbls
- 4 Saving existing data=save_data
- 4 Adding new columns=add_new_cols
- 4 Dropping columns=drop_old_cols
- 4 Adding new constraints=add_new_cons
- 4 Dropping constraints grom a column=drop_old_cons
- 4 How to drop tables =how_drop_tbls
- 2 Working with indexes
- 3 Index basics=idx_basics
- 3 How to create indexes=how_create_idxs
- 3 Using CREATE INDEX =use_create_idx
- 3 Preventing duplicate entries=no_dup_entries
- 3 Specifying index sort order=spec_idx_sort
- 3 Multi-column indexes=multi_col_idxs
- 3 Examples: using multi-column indexes=exam_multi_col_idxs
- 3 How to improve index performance=how_improve_perf
- 3 How to alter indexes=how_alter_idxs
- 3 Using SET STATISTICS =idx_set_stats
- 3 How to drop indexes=how_drop_idxs
- 2 Working with views
- 3 View basics=view_basics
- 3 How to create views=how_create_views
- 3 Specifying view column names=spec_view_col_names
- 3 Using the SELECT statement=use_select_views
- 3 Using expressions to define columns=use_exps_views
- 3 Types of views: read-only and updatable=view_types
- 3 Examples of read-only vs. updatable views=exam_view_types
- 3 How to insert data through a view=how_ins_data_view
- 3 How to Drop Views=how_drop_views
- 2 Working with stored procedures
- 3 Stored procedures basics=storp_basics
- 3 Using a data definition file=storp_ddfile
- 3 Calling stored procedures=calling_storps
- 3 Privileges for stored procedures=privs_storp
- 3 How to use stored procedures=how_use_storps
- 3 Using executable procedures in ISQL=exec_procs
- 3 Using select procedures in ISQL=select_procs
- 3 Viewing Arrays With Stored Procedures=ar_Viewing_Arrays_With_Stored_Procedures
- 3 How to create stored procedures =how_create_storps
- 3 The procedure header=storp_header
- 3 The procedure body=storp_body
- 3 Using variables=use_vars
- 3 Using assignment statements=assign_stmts
- 3 Using SELECT statements=select_stmts
- 3 Using FOR SELECT...DO statements=forselectdo_stmts
- 3 Using WHILE...DO statements=whiledo_stmts
- 3 Using IF...THEN...ELSE statements=ifthen_stmts
- 3 Using event alerters=event_alerter
- 3 Adding comments=add_comments
- 3 EXECUTE PROCEDURE statements=execproc_stmts
- 3 Using SUSPEND, EXIT, and END=suspend_stmts
- 3 How to alter stored procedures=how_alter_storps
- 3 How to drop stored procedures=how_drop_storps
- 2 Working with triggers
- 3 Trigger basics=trig_basics
- 3 How to use triggers=How_use_trigs
- 3 Triggers and security=trigs_sec
- 3 Triggers as event alerters=trig_events
- 3 How to create triggers=how_create_trigs
- 3 The trigger header=trig_header
- 3 The trigger body=trig_body
- 3 NEW and OLD context variables=newold_vars
- 3 Using generators=trig_gens
- 3 How to alter triggers=how_alter_trigs
- 3 Altering a trigger header=alt_trig_header
- 3 Altering a trigger body=alt_trig_body
- 3 How to drop triggers=how_drop_trigs
- 2 Working with user-defined functions and BLOB filters
- 3 Overview=udf_Declaring_Userdefined_Functions_and_BLOB_Filters
- 3 Creating User-defined Functions=udf_Creating_Userdefined_Functions
- 3 DECLARE EXTERNAL FUNCTION Syntax=udf_DECLARE_EXTERNAL_FUNCTION_Syntax
- 3 DECLARE EXTERNAL FUNCTION Example=udf_DECLARE_EXTERNAL_FUNCTION_Example
- 3 Declaring BLOB Filters=udf_Declaring_BLOB_Filters
- 2 Working with generators
- 3 How to create generators=how_create_gens
- 3 How to set or reset generator values=how_set_gen_vals
- 3 How to use generators=how_use_gens
- 2 Shadowing a Database
- 3 Overview =sha_Shadowing_a_Database_
- 3 Tasks For Shadowing=sha_Tasks_For_Shadowing
- 3 Advantages of Shadowing=sha_Advantages_of_Shadowing
- 3 Limitations of Shadowing=sha_Limitations_of_Shadowing
- 3 Creating a Shadow=sha_Creating_a_Shadow
- 3 Creating a Single-file Shadow=sha_Creating_a_Singlefile_Shadow
- 3 Creating a Multi-file Shadow=sha_Creating_a_Multifile_Shadow
- 3 Creating a Shadow in Auto Mode or Manual Mode=sha_Creating_a_Shadow_in_Auto_Mode_or_Manual_Mode
- 3 Creating a Conditional Shadow=sha_Creating_a_Conditional_Shadow
- 3 Activating a Shadow=sha_Activating_a_Shadow
- 3 Dropping a Shadow=sha_Dropping_a_Shadow
- 3 Adding a Shadow File=sha_Adding_a_Shadow_File
- 2 Handling security issues
- 3 Security=intro_sec
- 3 Available SQL access privileges=privs_available
- 3 How to grant access to tables=how_access_tbls
- 3 Granting multiple privileges=multiple_privs
- 3 Granting all privileges=all_privs
- 3 Granting privileges to a list of users=privs_list_users
- 3 Granting privileges to a list of procedures=privs_list_procs
- 3 Granting privileges to all users=privs_public
- 3 Granting users access to columns in a table=privs_access_cols
- 3 Granting users the right to grant privileges=privs_grant_privs
- 3 How to grant privileges to execute stored procedures=how_privs_storps
- 3 How to grant access to views=how_access_views
- 3 How to revoke user access =how_revoke_privs
- 3 Revoking multiple privileges=multiple_privs_rev
- 3 Revoking all privileges=all_privs_rev
- 3 Revoking privileges for a list of users=privs_list_users_rev
- 3 Revoking privileges for a list of procedures=privs_list_procs_rev
- 3 Revoking privileges for all users=privs_public_rev
- 3 Revoking grant authority=privs_grant_privs_rev
- 3 How to use views to restrict data access=how_views_restrict_access
- 1 InterBase tools
- :include ibmgr32.cnt
- :include wisql32.cnt
- 2 Using Command-line ISQL
- 3 Invoking Isql=uisql_Invoking_Isql
- 3 Command-line Options=uisql_Commandline_Options
- 3 Exiting Isql=uisql_Exiting_Isql
- 3 Connecting to a Database=uisql_Connecting_to_a_Database
- 3 Transaction Behavior in Isql=uisql_Transaction_Behavior_in_Isql
- 3 Extracting Metadata=uisql_Extracting_Metadata
- 3 Order of Extraction=uisql_Order_of_Extraction
- 3 Isql Commands=uisql_Isql_Commands
- 3 SHOW Commands=uisql_SHOW_Commands
- 3 SET Commands=uisql_SET_Commands
- 3 Other Isql Commands=uisql_Other_Isql_Commands
- 3 BLOBDUMP=uisql_BLOBDUMP
- 3 Comments=uisql_comments
- 3 EDIT=uisql_edit
- 3 SHELL=uisql_shell
- 3 INPUT=uisql_input
- 3 Exiting isql=uisql_exiting_isql
- 3 Error Handling=uisql_Error_Handling
- 3 Isql Command Reference
- 4 Overview=cisql_Isql_Command_Reference
- 4 BLOBDUMP=cisql_BLOBDUMP
- 4 EDIT=cisql_EDIT
- 4 EXIT =cisql_EXIT
- 4 HELP=cisql_HELP
- 4 INPUT=cisql_INPUT
- 4 OUTPUT=cisql_OUTPUT
- 4 QUIT=cisql_QUIT
- 4 SET=cisql_SET
- 4 SET AUTODDL=cisql_SET_AUTODDL
- 4 SET BLOBDISPLAY=cisql_SET_BLOBDISPLAY
- 4 SET COUNT=cisql_SET_COUNT
- 4 SET ECHO=cisql_SET_ECHO
- 4 SET LIST=cisql_SET_LIST
- 4 SET NAMES=cisql_SET_NAMES
- 4 SET PLAN=cisql_SET_PLAN
- 4 SET STATS=cisql_SET_STATS
- 4 SET TERM=cisql_SET_TERM
- 4 SET TIME=cisql_SET_TIME
- 4 SHELL=cisql_SHELL
- 4 SHOW CHECK=cisql_SHOW_CHECK
- 4 SHOW DATABASE=SHOW_DATABASE
- 4 SHOW DOMAINS=cisql_SHOW_DOMAINS
- 4 SHOW EXCEPTIONS=cisql_SHOW_EXCEPTIONS
- 4 SHOW FILTERS=cisql_SHOW_FILTERS
- 4 SHOW FUNCTIONS=cisql_SHOW_FUNCTIONS
- 4 SHOW GENERATORS=cisql_SHOW_GENERATORS
- 4 SHOW GRANT=cisql_SHOW_GRANT
- 4 SHOW INDEX=cisql_SHOW_INDEX
- 4 SHOW PROCEDURES=cisql_SHOW_PROCEDURES
- 4 SHOW SYSTEM=cisql_SHOW_SYSTEM
- 4 SHOW TABLES=cisql_SHOW_TABLES
- 4 SHOW TRIGGERS=cisql_SHOW_TRIGGERS
- 4 SHOW VERSION=cisql_SHOW_VERSION
- 4 SHOW VIEWS=cisql_SHOW_VIEWS
- 2 Using the Command-line DBA Utilities
- 4 Overview=udba_Using_the_Commandline_DBA_Utilities
- 4 Using the Security Utility=udba_Using_the_Security_Utility
- 4 The Security Database=udba_The_Security_Database
- 4 Security Utility Commands=udba_Security_Utility_Commands
- 4 Displaying the Security Database=udba_Displaying_the_Security_Database
- 4 Displaying the Security Database=udba_Adding_Entries_to_the_Security_Database_
- 4 Modifying the Security Database=udba_Modifying_the_Security_Database_
- 4 Deleting Entries from the Security Database=udba_Deleting_Entries_from_the_Security_Database
- 4 Using the Security Utility from the Command Line=udba_Using_the_Security_Utility_from_the_Unix_Command_Line
- 4 Using the Database Maintenance Utility=udba_Using_the_Database_Maintenance_Utility
- 4 Sweeping a Database=udba_Sweeping_a_Database
- 4 Options for Database Sweeping=udba_Options_for_Database_Sweeping
- 4 Changing the Sweep Interval=udba_Changing_the_Sweep_Interval
- 4 Disabling Automatic Sweeping=udba_Disabling_Automatic_Sweeping
- 4 Sweeping a Database at a Specified Time=udba_Sweeping_a_Database_at_a_Specified_Time
- 4 Repairing a Database=udba_Repairing_a_Database
- 4 Options for Database Repair=udba_Options_for_Database_Repair
- 4 Validating a Database=udba_Validating_a_Database
- 4 Mending a Corrupt Database=udba_Mending_a_Corrupt_Database
- 4 Handling Checksum Errors=udba_Handling_Checksum_Errors
- 4 Recovering Limbo Transactions=udba_Recovering_Limbo_Transactions
- 4 The Two-phase Commit Process=udba_The_Twophase_Commit_Process
- 4 Automated Transaction Recovery=udba_Automated_Transaction_Recovery
- 4 Options for Transaction Recovery=udba_Options_for_Transaction_Recovery
- 4 Shutting Down a Database=udba_Shutting_Down_a_Database
- 4 Shutdown Options=udba_Shutdown_Options
- 4 Preventing Further Attachments=udba_Preventing_Further_Attachments
- 4 Preventing Further Transactions=udba_Preventing_Further_Transactions
- 4 Forcing Shutdown=udba_Forcing_Shutdown
- 4 Restarting a Database =udba_Restarting_a_Database_
- 4 Controlling Performance of Forced Writes=udba_Controlling_Performance_of_Forced_Writes
- 4 Using the Backup and Restore Utilities=udba_Using_the_Backup_and_Restore_Utilities
- 4 General Syntax=udba_General_Syntax
- 4 Performing a Simple Backup=udba_Performing_a_Simple_Backup
- 4 Backing Up Remote Databases=udba_Backing_Up_Remote_Databases
- 4 Backing Up to a Storage Device=udba_Backing_Up_to_a_Storage_Device
- 4 Performing a Simple Restoration=udba_Performing_a_Simple_Restoration
- 4 Restoring from a Storage Device=udba_Restoring_from_a_Storage_Device
- 4 Monitoring the Status of Backup and Restore=udba_Monitoring_the_Status_of_Backup_and_Restore
- 4 Making a Transportable Backup=udba_Making_a_Transportable_Backup
- 4 Backup Options Overview=udba_Backup_Options_Overview
- 4 Backing Up Metadata=udba_Backing_Up_Metadata
- 4 Preventing Garbage Collection=udba_Preventing_Garbage_Collection
- 4 Ignoring Checksums=udba_Ignoring_Checksums
- 4 Ignoring Limbo Transactions=udba_Ignoring_Limbo_Transactions
- 4 Restoration OptionsRestoration Options=udba_Restoration_Options
- 4 KSplitting a Database into Several Files=udba_KSplitting_a_Database_into_Several_Files
- 4 Making Indexes Inactive=udba_Making_Indexes_Inactive_
- 4 Disabling Validity Checking=udba_Disabling_Validity_Checking
- 4 Changing the Database Page Size=udba_Changing_the_Database_Page_Size
- 4 Restoring a Database Without Its Shadow=udba_Restoring_a_Database_Without_Its_Shadow
- 4 Restoring Data Incrementally=udba_Restoring_Data_Incrementally
- 4 Upgrading to a New On-disk Structure=udba_Upgrading_to_a_New_Ondisk_Structure
- 3 Command-line DBA Utilities Reference
- 4 Overview=cdba_Command-line_DBA
- 4 Gbak=cdba_Gbak
- 4 Backup Options for Gbak=cdba_back_options
- 4 Restore Options for Gbak=cdba_restore_options
- 4 Gfix=cdba_Gfix
- 4 Gsec=cdba_Gsec
- 1 Programmer's Guide
- :include pg32.cnt
- 1 InterBase API
- :include ibapi32.cnt
- 1 SQL statement and function reference
- :include sqlref32.cnt
- 1 Error and exception handling
- 2 Handling errors=error_handling
- 2 Handling exceptions=excep_errors
- 2 Handling SQL errors=sql_errors
- 2 Handling InterBase errors=ib_errors
- 2 Examples of error behavior and handling=exam_error_handling
- 2 Error codes and messages
- 3 Error codes and message list=error_msgs
- 3 Error sources=error_sources
- 3 Error reporting and handling =err_rpt_handle
- 3 Trapping errors with WHENEVER=whenever
- 3 Checking SQLCODE value directly=sqlcode
- 3 InterBase status array=status_array
- 3 SQLCODE error codes and messages=err_code_msgs
- 3 SQLCODE error messages summary=sqlcode_summary
- 3 SQLCODE codes and messages=sqlcode_codes
- 3 InterBase status array error codes=ib_err_codes
- 3 Server Manager error messages=svr_mgr_errors
- 1 Troubleshooting: Using Comdiag
- :include comdg32.cnt
- 1 Glossary
- :include ibgloss.cnt
-