Bugs on free format sources and others...

[Vincent (Bryan) Coen]

When processing a source file that is in free format the following problems appear:

Running dbpre with dbpre -f stockMT -I../copybooks
does not process free format source correctly as it chops off the first 6/7 chars.
duplicates source lines 3 times.

Running dbpre without -f with free sources :
Ignores inbedded "*>" in the sources (see stockMT.lst)
Ignores exec sql copy statements - see code with : -
---
EXEC SQL

  INCLUDE MySQL-SQLCA.cpy

END-EXEC.

In the lst file produces a blank line after every source line (se stockMT.lst).
3. Marks as an error EXEC SQL COMMIT WORK END-SQL.
This is valid but even with the WORK preceeded with *> still produces an error.
4. PREPARE is not accepted - valid sql coding.

Testing stopped as errors are too great to continue.

This has been sent to the tracker system along with the source and listing files etc..

[Vincent (Bryan) Coen]

From your response under the recorded bug - PREPARE and EXECUTE are often used SQL for a program or module that will be used in production applications as they improve speed of execution against the RDB.

All of my applications are now in free format for both readability and ease of programming / typing.

Needless to say I use the '*>' comment option heavily within and after a cobol statement line to hold notes and other memory helpful comments.

If I get a change I will take a look at adding both PREPARE and EXECUTE to the cobclient C code library. - My C is somewhat rusty :)

Also need to look at what SQL processes are available for connecting to other tables within the same run unit as SET CONNECTION is not in use with MySQL.