This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Note: | |
-- Documentation for ACS's cldownload and other fantastic hidden gems can be found here: | |
-- ftp://ftp.software.ibm.com/as400/products/clientaccess/solutions/GettingStarted_en.html | |
-- | |
-- | |
-- Do I have the ACS jar on this IBM i? | |
-- | |
select create_timestamp, acs.* |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Which CL commands have had their parameter defaults changed? | |
-- (On IBM i 7.3 and higher) | |
-- | |
with libs (lib) as ( | |
select objname | |
from table ( | |
qsys2.OBJECT_STATISTICS('*ALLAVL', '*LIB') | |
) | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Subject: IFS stream file transformation | |
-- Author: Scott Forstie (thanks to Sue Romano for helping with this Gist) | |
-- Date : June 28, 2021 | |
-- Features Used : This Gist uses ifs_read, ifs_write, regexp_replace, and the previously unknown fx designation for a unicode literal. | |
-- | |
-- Function - Point is routine at an existing IFS steam file, which contains some character data that you want to globally replace. | |
-- The function extracts (reads) the contents, replaces the search string occurrences with the replacement string, and then | |
-- writes everything to the target IFS stream file. | |
-- |