Product Documentation

Combining FairCom DB SQL with ISAMIdentify "Bad" Records with ctoption(badrec)

SQL Operations Guide

Previous Topic

Next Topic

Identify "Bad" Records with ctoption(badrec)

When bringing ISAM data into SQL, it's possible to encounter a situation where there is an error interpreting field content. The FairCom DB SQL engine has an aid to assist with identifying "bad" records for all applications.

Example:

SELECT * FROM <table> ctoption(badrec)

When using the ctoption(badrec) syntax, only failing records are returned and error information is logged in sqlserver.log.

TOCIndex