Skip to main content

Copyfile as EXEC SQL INCLUDE not found

  • February 15, 2013
  • 0 replies
  • 0 views

Problem:

EXEC SQL

    INCLUDE table1

END-EXEC

The copy is in the current directory as "table1.cpy" but the compiler appears as if it looking for "TABLE1.cpy" (converts to UPPERCASE in the inverse way as SQLCA).

Resolution:

The problem is that UNIX is case sensitive and the only way to get round this problem is either to manually change the names to upper/lower case but that would be unfeasible if there are 100s of programs involved.

Another way and much easier is to use the compiler directive FOLD-CALL-NAME or FOLDCALLNAME respectively. Both are the same and allow lower and/or upper case letters.

Old KB# 4510