brainchime.com Latest Questions

Admin
Asked: 2024-10-06T19:21:01+05:30 In:

What are the equivalent SQL data types to ile rpg data types?

I was writing a sqlrpgle program since I had to write an SQL query to fetch data from a table into rpg variables and I was not sure how to map SQL data types field in SQL select statement with their equivalent ILE RPG data types.

How do we map all the SQL data types with their equivalent ILE RPG data types so that I can define the variables with exact mapping in the sqlrpgle program?

as400db2rpg

Related Questions

Leave an answer

Leave an answer

Browse
Browse

Choose from here the video type.

Put Video ID here: https://www.youtube.com/watch?v=sdUUx5FdySs Ex: "sdUUx5FdySs".

1 Answer

  1. Admin
    This answer was edited.

    ILE RPG data types mapped to SQL data types:

    ILE RPG data type Description SQL data type
    DS Data structure Char
    Zoned(digits:decimal places) Zoned data Numeric(digits, decimal places)
    Packed(digits:decimal places) Packed data Decimal(digits, decimal places)
    Bindec(digits) 2-byte binary with 0 decimal places smallint
    2-byte binary with 0 decimal places 4-byte binary with 0 decimal places Integer
    Int(5) 2-byte integer smallint
    Int(10) 4-byte integer Integer
    Int(20) 8-byte integer Bigint
    Float(4) Short float Float(single precision)
    Float(8) Long float Float(double precision)
    Char(length) Character Char(length)
    Varchar(length) Character varying length Varchar(length)
    Graph(length) Graphic Graphic(length)
    Vargraph(length) Varying graphic Vargraphic(length)
    Ucs2(length) UCS-2 Graphic(length) with ccsid 13488 or ccsid 1200
    Varucs2(length) UCS-2 VarGraphic(length) with ccsid 13488 or ccsid 1200
    Date or Date(format-separator) Date Date Datfmt(format) Datsep(separator)
    Time or Time(format-separator) Time Time Timfmt(format) Timsep(separator)
    Timestamp Timestamp Timestamp
    DS Data structure Char
    CLOB is not supported in RPG. SQLTYPE keyword is used to declare CLOB in the RPG program CLOB
    DBCLOB is not supported in RPG. SQLTYPE keyword is used to declare DBCLOB in the RPG program DBCLOB
    BLOB is not supported in RPG. SQLTYPE keyword is used to declare BLOB in the RPG program BLOB
    BINARY is not supported in RPG. SQLTYPE keyword is used to declare BINARY in the RPG program BINARY
    VARBINARY is not supported in RPG. SQLTYPE keyword is used to declare VARBINARY in the RPG program VARBINARY
    XML is not supported in RPG. SQLTYPE keyword is used to declare XML in the RPG program XML
    ROWID is not supported in RPG. SQLTYPE keyword is used to declare ROWID in the RPG program ROWID
    Result Set Locator is not supported in RPG. SQLTYPE keyword is used to declare the Result Set Locator in the RPG program Result Set Locator
    DATALINK is not supported in RPG. DATALINK