Product Documentation

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.


SELECT * FROM <table> ctoption(badrec)

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