Tag Archives for " #SQL "

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 […]

More Waffle
Nov 12

SQL RPG and the annoying compile COMMIT *NONE thing

IBM i

Moving to SQL (from native file IO) has been a major game changer in the RPG programming world. SQL can be confusing to learn, horrible to use if it needs lots of compile time parameters but using Exec SQL SET OPTION something answers my prayers. I first played with SQL back the golden days of RPG3 […]

More Waffle