In The Spotlight
Now that we have basic SQL tables that are still RPG-friendly, let’s start to make them more recognizable (and usable) for non-RPG developers by adding some typical SQL features, like keys, default values for optional columns, etc. In this article we’ll cover adding a unique key and we’ll look at the other features later.
By Rafael Victória-Pereira
So far in this subseries, we have generated CREATE TABLE statements from old-style physical files and created a new schema with these statements, after a few tweaks. It’s time to start adding those features that make our tables part of a recognizable database.