Tag Archives for " #DDL "

Mar 04

Upgrade from PF to DDL (SQLSTM) using TURNOVER from UNICOM SOFTLANDING

AS400 , DDS , IBM i , iSeries , SQL

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 I’ve been to use QSQLSRC […]

Continue reading