The next example creates the PROC SQL view VLIB.STOCKORD that is based on the table TESTID.ORDERS. The table TESTID.ORDERS is an SQL/DS table that is accessed through DRDA. libname vlib ...

Every column in a table has a name and a data type. The data type tells DB2 how much physical storage to set aside for the column and the form in which the data are stored. DB2 uses IBM SQL data types ...