Handling Blank Character Data for Key Items (DATABridge Client for Oracle)

The DATABridge Client strips all trailing blanks when constructing SQL statements using varchar data. When an application reads the records back from the database, the access routines put back the trailing blanks, greatly reducing the storage requirements for the SQL statements and bulk loader data files.

In Oracle, char or varchar items that have a length of 0 are treated as NULL. If any of the key items used in where clauses have a value of NULL, the corresponding update or delete SQL statements fail as mentioned above. To prevent the key item from becoming NULL, the DATABridge Client for Oracle keeps the last blank of the item.