Carbon/400
Sign in

docs RPG Guide

Converting Source Members with Embedded SQL

Converting Source Members with Embedded SQL

When converting code that contains embedded SQL and the SQL code is continued over multiple lines, the following will occur:

  • If there are continuation lines but column 74 is blank, the line is simply copied to the ILE member.

    Note: This could be a problem if column 74 happens to be a blank character inside a character string.

  • If column 74 is not blank, all of the SQL code from that line to the /END-EXEC will be concatenated and copied to the ILE member filling up all 80 columns. If this occurs:

    • Any comments in column 75 on, will be ignored.
    • Any embedded comment lines (C*) will be copied to the ILE member before the concatenated code is copied.
    • Problems could arise if DBCS literals are split.

    If you do not want this concatenation and re-formatting to occur, ensure that column 74 is blank.