In Transparent mode SQL, null valued keys are not included in the selection criteria: that is, no ‘WHERE . . . ISNULL’ clauses are automatically generated. Full-Function mode statements are required to select data when the selection criteria are based on columns containing null data. The null selection cannot be on any KEY fields.

Comment on this topic

Topic ID: 720211

 
 
 

Table of Contents

Index

Glossary

-Search-

Back