Reference Manual

10.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

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.