Only Numpty Programmers hardcode library names #internetfact One of the mumbling, drooling, gray haired programmers on my team asked me to peer review his code this morning. This was for a simple SQL table to be created and promoted through multiple environments using TURNOVER. The code looked something like this: CREATE TABLE MYLIB/TESTSQL ( TSTFLD

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: ? RUNSQLSTM SRCFILE(“&SL”/”&SF” SRCMBR(“&SM”) COMMIT(*NONE) NAMING(*SYS) DFTRDBCOL(“&LI”) Turnover uses the DFTRDBCOL column “&LI” to populate the other *library* variables. DFTRDBCOL(NLITTEN) Most shops

Read More