Filter
Exclude
Time range
-
Near
Scott Forstie@Forstie_IBMi
18 May 2024
Generating spreadsheets and sending emails on #IBMi where the email recipients are not hard-coded. See the data-driven SQL solution here: gist.github.com/forstie/34be… #SQLcandoit #Db2fori

The request... send emails using data driven email recipient specifications. The implementation is...

The request... send emails using data driven email recipient specifications. The implementation is 100% SQLcandoit. - Data driven emails from IBM i.sql

gist.github.com
7
404
Scott Forstie@Forstie_IBMi
7 May 2024
#IBMi announcement details for IBM i 7.5 TR4 and IBM i 7.4 TR10. Lots of enhancements on the way. #SQLcandoit #Db2fori dhttps://www.ibm.com/support/pages/ibm-i-75-tr4-enhancements ibm.com/support/pages/ibm-i-…
3
15
429
Scott Forstie@Forstie_IBMi
7 Feb 2024
#IBMi #Db2fori #HTTPservers #FRCA #SQLcandoit gist.github.com/forstie/f413…

The path to achieving improved security on IBM i is sometimes a winding road. SQL can help to get...

The path to achieving improved security on IBM i is sometimes a winding road. SQL can help to get you there on time. In this installment, FRCA is raised from obscurity to something understandable. ...

gist.github.com
3
272
Scott Forstie@Forstie_IBMi
23 Jan 2024
#IBMi #Joblogs #GetTheGist #SQLcandoit gist.github.com/forstie/3196…

Joblogs... important, but needlessly difficult to automate or consume. This gist takes on this...

Joblogs... important, but needlessly difficult to automate or consume. This gist takes on this topic.... - coolstuff.read_joblog.sql

gist.github.com
2
250
Scott Forstie@Forstie_IBMi
18 Jan 2024
#GetTheGist #IBMi #SQLcandoit #environmentVariables gist.github.com/forstie/e539…

This gist comes from client requests to have a mechanism to "reset" environment variables within a...

This gist comes from client requests to have a mechanism to "reset" environment variables within a job. - Reset environment variables in a job.sql

gist.github.com
4
220
Scott Forstie@Forstie_IBMi
10 Oct 2023
Hear ye, Hear ye! IBM i - Technology Refresh enhancements are coming for IBM i 7.4 & 7.5. ibm.com/support/pages/ibm-i-… ibm.com/support/pages/ibm-i-… #IBMi #Db2fori #SQLcandoit #SYSTOOLSforthewin
3
7
505
Scott Forstie@Forstie_IBMi
2 Oct 2023
I have 8 sessions at #NAViGATE. If you can attend, please do so! You won't regret it. navigate2023.sched.com/speak… common.org/navigate2023/regi… @COMMONug #IBMi #Db2fori #SQLcandoit
1
13
381
Scott Forstie@Forstie_IBMi
11 Sep 2023
#CollectionServicesMadeEasy #SQLcandoit #IBMi #Db2fori #GetTheGist gist.github.com/forstie/e4a4…

The Collection Services (CS) config and CS data hold a goldmine of operational insight about the...

The Collection Services (CS) config and CS data hold a goldmine of operational insight about the IBM i. This Gist shows how a little bit of SQL can open the door to gaining insight and value from t...

gist.github.com
2
6
449
Scott Forstie@Forstie_IBMi
25 Aug 2023
#DBEinAbox #Db2fori #SQLcandoit #automatedIndexStrategy #IBMi #IBMPower gist.github.com/forstie/6961…

Database and SQL performance tuning is a persistent focus, which many times leads into the indexing...

Database and SQL performance tuning is a persistent focus, which many times leads into the indexing strategy. In this gist, I show how some of the existing tools can be tied together to achieve an...

gist.github.com
2
10
429
Scott Forstie@Forstie_IBMi
7 Jul 2023
Are you just "getting started" using SQL on IBM i? If yes, join us for a lively group discussion on Monday, July 10th. members.common.org/CommonSit… @COMMONug @CommonEurope #SQLcandoit
2
10
468
Scott Forstie@Forstie_IBMi
21 Jun 2023
Happy Birthday IBM i. You've had a great run to get to 35, but I expect more great things in the future from you. Have a super celebration today. Enjoy your friends! Then... come back to work tomorrow and do something amazing. All the best! Scott #IBMi #Db2fori #SQLcandoit
7
48
1,478
Scott Forstie@Forstie_IBMi
29 May 2023
Hello friends... Join me at the Common Europe Congress and we can discuss anything related to IBM i. There is a fantastic list of speakers. Join us by visiting: comeur.org/#home #IBMi #Db2fori #SQLcandoit @CommonEurope @COMMONug @CommonFrance @commonsweden ...
5
20
877
Scott Forstie@Forstie_IBMi
17 May 2023
If you're anywhere near the UK and have an interest in the IBM i... please join me at this event: i-ug.co.uk/ I will be happy to discuss any topic with you. @i_ug_uk @COMMONug #IBMi #Db2fori #SQLcandoit

Home - i-UG

Join the largest IBM i user group in the UKJoin todayFind out what’s included with i-UG membershipClick HereGet an insight into i-UG event contentWatch hereJoin our mailing list to hear about our...

i-ug.co.uk
1
8
384
OCEAN Tech Users Group - All Aspects of IT@OCEANUserGroup
30 Apr 2023
Thank you so much for the outstanding #IBMi #SQL workshop yesterday @BirgittaHauser! Our minds were blown! We always learn new & better ways to use SQL by attending your sessions. #SQLCanDoIt #SQLServices @IBMChampions
OCEAN Tech Users Group - All Aspects of IT@OCEANUserGroup
21 Apr 2023
Register now & secure your seat for a jam-packed in-person #SQL workshop led by @IBMChampions Birgitta Hauser on Saturday, April 29th! #SQLCanDoIt #IBMi @BirgittaHauser oceanusergroup.org
1
3
248
OCEAN Tech Users Group - All Aspects of IT@OCEANUserGroup
21 Apr 2023
Register now & secure your seat for a jam-packed in-person #SQL workshop led by @IBMChampions Birgitta Hauser on Saturday, April 29th! #SQLCanDoIt #IBMi @BirgittaHauser oceanusergroup.org
2
382
Scott Forstie@Forstie_IBMi
17 Apr 2023
#PTFSpecialInstructions gist.github.com/forstie/16ac… #IBMi #Db2fori #SQLcandoit #GetTheGist

The request... show how SQL can be used to narrow the field down to those PTFs that have special...

The request... show how SQL can be used to narrow the field down to those PTFs that have special instructions, and only return the special instructions. The following example focuses on what an adm...

gist.github.com
1
6
430
Scott Forstie@Forstie_IBMi
14 Apr 2023
#ExtractDb2intoJSON #ConsumableSQLServices gist.github.com/forstie/d4d6… #IBMi #Db2fori #GetTheGist #SQLcandoit

The request... Is it possible to extract data from IBM i into JSON format with a Db2 service?

The request... Is it possible to extract data from IBM i into JSON format with a Db2 service? - db2_to_json.sql

gist.github.com
4
330
Scott Forstie@Forstie_IBMi
11 Apr 2023
Announce day is here again... IBM i 7.4 and IBM i 7.5, are being enhanced! ibm.com/support/pages/ibm-i-… ibm.com/support/pages/ibm-i-… #SQLcandoit #IBMi #Db2fori
1
11
541
Scott Forstie@Forstie_IBMi
11 Apr 2023
Announce day is here again... IBM i 7.4 and IBM i 7.5, are being enhanced! ttps://www.ibm.com/support/pages/ibm-i-75-tr2-enhancements ibm.com/support/pages/ibm-i-… #SQLcandoit #IBMi #Db2fori

1
3
15
629
Scott Forstie@Forstie_IBMi
8 Apr 2023
#QuerySupervisor #IBMi #Db2fori #SQLcandoit #GetTheGist gist.github.com/forstie/6bd6…

The request... show how Query Supervisor could be used to HOLD a job. The criteria for which...

The request... show how Query Supervisor could be used to HOLD a job. The criteria for which situations merit a job being held are left to the reader. The example shows how QS could react to a long...

gist.github.com
2
9
536
Load more