Please explain in detail about the data types that can be defined in the physical file (PF) in as400. Please provide the syntax for defining the various types in the DDS PF.
Sorry, you do not have permission to ask a question, You must login to ask a question.
Sorry, you do not have permission to ask a question.
There are many data types supported by physical files in as400, which are as follows:
Points to consider while implementing these data types in physical files.
Source code for defining character data type in the physical file: maximum allowed length for the character data type is 32766
The source code for defining Varying character data types in physical files:
The maximum allowed length for varying character data types is 32740, and the VARLEN keyword is used.
Source code for defining Binary data type in the physical file:
the maximum allowed length for the character data type is 18.
Source code for defining Floating data type in physical file:
the maximum allowed length for floating data type is 9 for single precision.
The maximum allowed length for the floating data type is 17 for double precision.
The source code for defining the Hexadecimal data type in the physical file:
the maximum allowed length for the hexadecimal data type is 32766.
Source code for defining Date data type in physical file
Source code for defining Time data type in physical file
Source code for defining Timestamp data type in physical file
The source code for defining the Packed decimal data type in the physical file:
the maximum allowed length for the packed decimal data type is 63. Either 63 numeric and decimal 0 or 0 numeric and decimal 63.
The source code for defining the Zoned decimal data type in the physical file:
the maximum allowed length for the packed decimal data type is 63. Either 63 numeric and decimal 0 or 0 numeric and decimal 63.
The source code for defining the Binary character data type in the physical file:
the maximum allowed length for the binary character data type is 32766.
Source code for DDS-supported DBCS data type Source code for defining DBCS-only data type in the physical file:
the maximum allowed length for DBCS-only data type is 32766.
The source code for defining Varying DBCS-only data types in the physical file:
the maximum allowed length for varying DBCS-only data types is 32740.
Source code for defining DBCS Either data type in the physical file:
the maximum allowed length for DBCS either data type is 32766.
Source code for defining Varying DBCS:
The maximum allowed length for varying DBCS data types in the physical file is 32740.
The source code for defining the Open data type in the physical files:
the maximum allowed length for the open data type is 32766.
The source code for defining Varying open data types in physical files:
the maximum allowed length for varying open data types is 32740.
Source code for defining Graphic data type in physical file:
the maximum allowed length for the open data type is 16383.
The source code for defining Varying graphic data types in physical files:
the maximum allowed length for varying open data types is 16370.