• Narayanan V's avatar
    Bug#44610 RCDFMT clause requested when creating DB2 table · ca3dbc91
    Narayanan V authored
    In order to better support the usage of
    IBMDB2I tables from within RPG programs,
    the storage engine should ensure that the
    RCDFMT name is consistent and predictable
    for DB2 tables.
    
    This patch appends a "RCDFMT <name>"
    clause to the CREATE TABLE statement
    that is passed to DB2.  <name> is
    generated from the original name of
    the table itself. This ensures a
    consistent and deterministic mapping
    from the original table.
    
    For the sake of simplicity only
    the alpha-numeric characters are
    preserved when generating the new
    name, and these are upper-cased;
    other characters are replaced with
    an underscore (_). Following DB2
    system identifier rules, the name
    always begins with an alpha-character
    and has a maximum of ten characters.
    If no usable characters are found in
    the table name, the name X is used.
    ca3dbc91
ibmdb2i_bug_44610.result 562 Bytes