lesnostream.blogg.se

Select path_name into local_ifs_path_nameĬall coolstuff. create_and_email_top10()ĭeclare local_ifs_path_name varchar( 100) for sbcs data V_note => 'Here is your top 10 list of storage consumers ') Ĭreate or replace procedure coolstuff. V_subject => 'Email sent by coolstuff.email_1_spreadsheet ', 'SNDSMTPEMM RCP(( ' ' ' concat v_email concat ' ' ' *pri)) SUBJECT( ' ' ' concat v_subject concat ' ' ') NOTE( ' ' ' concat v_note concat ' ' ') ATTACH(( ' ' ' concat v_ifs_path concat ' ' ')) ' Ĭall coolstuff. In v_subject varchar( 100) for sbcs data,ĭeclare v_cmdstmt varchar( 2000) for sbcs data In v_ifs_path varchar( 100) for sbcs data, Note: The SNDSMTPEMM command include more parameter options that could be extended hereĬreate or replace procedure coolstuff. Where path_name like '/home/SCOTTF/theTop10% ' Group by a.authorization_name, b.text_description, Sum(a.storage_used) as total_storage_used, b.text_description,ī.accounting_code, b.maximum_allowed_storage V_spreadsheet_query => 'select a.authorization_name, generate_1_spreadsheet(v_ifs_path => '/home/SCOTTF/theTop10 ',

'STRQSH CMD( ' 'java -jar /QIBM/ProdData/Access/ACS/Base/acsbundle.jar 'Ĭoncat '/plugin=cldownload /system=COMMON1 /clientfile= 'Ĭoncat v_ifs_full_path concat ' /sql=" ' concatĬall coolstuff. 2) change line 82, the name after /system= should be your IBM i Host name. 1) execute this query: select HOST_NAME from qsys2.system_status_info Check to see whether your IBM i host name matches the name you specified on line 82."/system=COMMON1"? usecollabels = Use column labels for the heading. When specified, the column names will be the heading. colheadings= Include column headings as the first row. In v_spreadsheet_query varchar( 1000) for sbcs data)ĭeclare cmdtext varchar( 2000) for sbcs data ĭeclare v_ifs_full_path varchar( 2000) for sbcs data In v_ifs_path varchar( 1000) for sbcs data, Procedure to drive the spreadsheet creationĬreate or replace procedure coolstuff. ) acs order by create_timestamp desc limit 5 ifs_object_statistics( start_path_name => '/home/SCOTTF/ ') Where in the IFS should I create the spreadsheet? Where ptf_group_title like '%IBM HTTP% '

Is there an update available for the 'IBM HTTP Server for i' PTF Group ifs_object_statistics( start_path_name => '/QIBM/ProdData/Access/ACS/Base/acsbundle.jar ') Documentation for ACS's cldownload and other fantastic hidden gems can be found here: Learn more about bidirectional Unicode characters To review, open the file in an editor that reveals hidden Unicode characters. This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below.