Admin Asked: October 13, 20242024-10-13T09:38:56+05:30 2024-10-13T09:38:56+05:30In: IBM i What are the data types supported by physical files in AS400? Please explain in detail the data types available in the physical file in as400. as400db2 Related Questions What are AS400 systems. Please provide a introduction of AS400 systems? Is there any online server available for practicing on AS400 system? What are the menus available in AS400? What is subsystem in AS400? How to copy a save file from IFS to a library? How to transfer savf from as400 to pc? How to copy ifs file to another directory? How to copy savf from ifs to pc? How to copy ifs file to physical file? How to copy save file to ifs? How to copy spool file to ifs? How to copy physical file to ifs? How to copy file from pc to IFS/ How to download spool file from AS400? How do I delete a library in AS400? How do I copy data from AS400 to excel? What is library in AS400? How to find all the source physical file available in AS400? How to find all libraries in AS400? How to change the library list in AS400? What is access path in AS400? What is the difference between source physical file and physical file in as400? how to find the source file of an object in as400? how to change record length of source physical file in as400? What is cpf4174 error in as400? What is the use of varying keyword in rpgle? What is DDS in AS400? What is the difference between PF and LF in as400? Why do we use CHGPF command in AS400? how to create physical file in as400? how to add data in physical file in as400? how to view journal entries in as400? what is the use of ovrdbf in as400? What is an array in AS400? what is a data queue in as400 and why do we use data queue? How to run stored procedure in AS400? How to resolve session and device error in AS400? how to check as400 system values? How to check triggers on a file in as400? what is level check error and How to find damaged objects in AS400? what is module in as400? How to create binding directory in as400? how to create ifs folder in as400? What is ASP in AS400? What is JOBQ and how to create a JOBQ in AS400? What is PSDS in AS400? What is SEU in AS400 and why do we use it? What is the multi-format logical file in AS400? what is PR and PI in rpgle? Leave an answerLeave an answerCancel reply Attachment Select file Browse Featured image Select file Browse Add a Video to describe the problem better. Video type Youtube Vimeo Dailymotion Facebook TikTok Choose from here the video type. Video ID Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs". Visual Text Save my name, email, and website in this browser for the next time I comment. 1 Answer Voted Oldest Recent Random Admin 2024-10-13T10:04:03+05:30Added an answer on October 13, 2024 at 10:04 am There are many data types supported by physical files in as400, which are as follows: Character – entry A in fixed position 35. Binary – entry B Floating point – entry F Hexadecimal – entry H Date – entry L Packed decimal – entry P Zoned decimal – entry S Time – entry T Timestamp – entry Z Binary character – entry 5 There are also some DDS-supported DBCS data types. DBCS only – entry J DBCS either – entry E Open – entry O Graphics – entry G (UCS-2 or UTF-16) Points to consider while implementing these data types in physical files. Decimal places 36 and 37 for the Character data type (A) would be empty. Decimal places 36 and 37 for Packed Decimal (P) and Zoned Decimal (S) data types (P) would hold values ranging from 0 to 63 maximum. Position 37 would have the value 0 to indicate that it is a numeric field for data types such as packed, zoned, and binary fields. The maximum length permitted for the Binary(B) data type is 18. The maximum length permitted for the Float(F) data type with single precision and the FTPCN(*SINGLE) keyword applied is 9. The maximum length permitted for the Float(F) data type with double precision and the FTPCN(*DOUBLE) keyword applied is 17. Source code for defining character data type in the physical file: maximum allowed length for the character data type is 32766 A R RFMT1 A CHARF 32766A 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. A R RFMT1 A CHARF 32740A VARLEN Source code for defining Binary data type in the physical file: the maximum allowed length for the character data type is 18. A R RFMT1 A BINF 18B Source code for defining Floating data type in physical file: the maximum allowed length for floating data type is 9 for single precision. A R RFMT1 A FLOATSF 9F FLTPCN(*SINGLE) The maximum allowed length for the floating data type is 17 for double precision. A R RFMT1 A FLOATDF 17F FLTPCN(*DOUBLE) The source code for defining the Hexadecimal data type in the physical file: the maximum allowed length for the hexadecimal data type is 32766. A R RFMT1 A HEXDECF 32766H Source code for defining Date data type in physical file A R RFMT1 A DATEF L Source code for defining Time data type in physical file A R RFMT1 A TIMEF T Source code for defining Timestamp data type in physical file A R RFMT1 A TIMESTAMPF Z 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. A R RFMT1 A PACKEDDECF 63P 0 A PACKEDDECL 63P63 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. A R RFMT1 A ZONEDDECF 63S 0 A ZONEDDECL 63S63 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. A R RFMT1 A BINCHARF 327665 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. A R RFMT1 A DBCSONLYF 32766J 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. A R RFMT1 A DBCSONLYF 32740J VARLEN Source code for defining DBCS Either data type in the physical file: the maximum allowed length for DBCS either data type is 32766. A R RFMT1 A DBCSETHRF 32766E Source code for defining Varying DBCS: The maximum allowed length for varying DBCS data types in the physical file is 32740. A R RFMT1 A DBCSETHRF 32740E VARLEN The source code for defining the Open data type in the physical files: the maximum allowed length for the open data type is 32766. A R RCDFMT1 A OPEN1 32766O CCSID(65535) The source code for defining Varying open data types in physical files: the maximum allowed length for varying open data types is 32740. A R RCDFMT1 A OPEN2 32740O CCSID(65535) VARLEN Source code for defining Graphic data type in physical file: the maximum allowed length for the open data type is 16383. A R RFMT1 A GRAPA 16383G CCSID(1200) A GRAPB 16383G CCSID(13488) The source code for defining Varying graphic data types in physical files: the maximum allowed length for varying open data types is 16370. A R RFMT1 A GRAPA 16370G CCSID(1200) VARLEN A GRAPB 16370G CCSID(13488) VARLEN
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.