Converting an old Physical File (PF) to a modern SQL table can significantly enhance your database’s functionality and performance. Here are the general steps to achieve this: Here’s a simple example of how you might convert a PF to an SQL table: Creating SQL TABLES is easy – so How do we convert old DDS

Read More

RUNSQLSTM – Run SQL Statement When you do the RUNSQLSTM to create your SQL Objects – Do not qualify library names but use the Turnover variables just like you would define PDM variables: Turnover uses the DFTRDBCOL column “&LI” to populate the other *library* variables. Most shops I’ve been to use QSQLSRC to store the

Read More