Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

DTLDESCRIBE FKEYS Qualifier

DTLDESCRIBE FKEYS Qualifier

dtldescribe fkeys, [
pk_qualifier1
], [
pk_qualifier2
], [
pk_tablename
], [
fk_qualifier1
], [
fk_qualifier2
], [
fk_tablename
], [
comments
], [ORDER], [
escape_character
], [
respect_case_pk_1
], [
respect_case_pk_2
], [
respect_case_pk_3
], [
respect_case_fk_1
], [
respect_case_fk_2
], [
respect_case_fk_3
],[
extended_information
],[
access_method
]
After the basic syntax of
dtldescribe fkeys
, all of the parameters in brackets [ ] are optional. If any of the parameters are coded, you must include the intervening commas so that the parser can determine which field is included.
The following table describes the parameters:
Parameter
Description
pk_qualifier1
,
pk_qualifier2
Primary key qualifiers.
pk_tablename
This is the primary table qualifier.
fk_qualifier1
,
fk_qualifier2
These refer to foreign key qualifiers.
fk_tablename
The foreign table qualifier.
comments
Set this parameter to Y to get any comments found in data in the database.
ORDER
This field must be left blank except for a comma, which is needed to maintain position of subsequent fields.
escape_character
Specifies the character to be used as the escape character. Default is ~.
respect_case pk_1
,
respect_case pk_2
,
respect_case pk_3
,
respect_case fk_1
,
respect_case fk_2
,
respect_case fk_3
Set these parameters to Y to respect the case of the pk_qualifier1, pk_qualifier2, pk_tablename, fk_qualifier1, fk_qualifier2, and fk_tablename values, respectively. Or leave these parameters blank.
extended_information
This field must be left blank except for a comma, which is needed to maintain position of subsequent fields.
access_method
This field must be left blank except for a comma, which is needed to maintain position of subsequent fields.
FKEYS is implemented for:
  • DB2
  • DB2UDB
  • DB2400C
  • ORACLE
  • DB2390IMG
  • MSSQL