Combining FairCom DB SQL with ISAM
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.
