FREE GUIDES: In-depth and hand-crafted Linux, AWS, OpenStack, DevOps, Azure, and Cloud training guides created by Linux Academy instructors and the community.
set sql = 'update CapitalAssetsActivity set Period= CHAR(?), Amount = ?'; set sql = sql || ' where SliceDimension1 = ? and AssetID = ? and Sequence = ?' ; set sql = sql || ' and Year = ? + CHAR(?)'; EXEC SQL EXECUTE sql USING : prevMonth, :tInBalance, :slice1, :assetId, :sequence, :prefix, :prevYear;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.