FAQ > PERCobol and SQL Notes (10 entries)

Search the FAQ for entries containing:
  • Does PERCobol support accessing data SQL databases?
    PERC obol accesses most databases through JDBC. (As far as a COBOL programmer is concerned it is SQL and is accessed as with most other COBOL compilers). SQL setup details
  • How to use Oracle Stored procedures
    Oracle has special syntax for call over JDBC ; all that is needed is to surround the call in curly braces: EXEC SQL { CALL ABC }  ...
  • Do I need to run a SQL preprocessor to access SQL data with PERCobol?
    No, running a SQL preprocessor is not necessary with PERC obol.
  • Does PERCobol allow accessing data stored in Microsoft Access?
    Yes, LegacyJ has tested PERC obol with Microsoft Access. LegacyJ also can access any RDBMS through JDBC connectivity.
  • PL/SQL
    The following sample COBOL program calls an oracle PL/SQL procedure and demonstrates how PL/SQL can be used with LegacyJ: PL/SQL with LegacyJ The output from PL/SQL is ...
  • SQL Cursors
    LegacyJ has developed samples of using Cursors with LegacyJ PERC obol. The sample illustrates: * static SQL cursor. * static SQL cursor using host variables anywhere in working storage. ...
  • SQL Cursors
    LegacyJ has developed samples of using Cursors with LegacyJ PERC obol. The sample illustrates: * static SQL cursor. * static SQL cursor using host variables anywhere in working storage. ...
  • SQL Cursors
    LegacyJ has developed samples of using Cursors with LegacyJ PERC obol. The sample illustrates: * static SQL cursor. * static SQL cursor using host variables anywhere in working storage. ...
  • PERCobol with DB2 on the iSeries
    PERC obol supports database access through jdbc via EXEC -SQL statements, but can also access remote indexed files on the AS400 via the standard indexed file COBOL statements. Here are the ...
  • NULL Characters and RDBMS
    Some have asked about alternatives for handling spaces within database fields. Some alternatives may be useful within your application and allow for data portability. Some relational database management systems (RDBMS) may ...