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.