Creating SQL Web Services on IBM i – Part 2 (Inserts & Updates)

In this short How To …. On IBM i Video set, we will be continuing on our theme of SQL web services on IBM i.

We will add a couple more endpoints and show how we can test the services we have created.

Download Postman from https://www.postman.com/download

Don’t forget like & subscribe & if you like my creative work, buy me a coffee! https://ko-fi.com/andyyouens

⌚ Timestamps
— Contents —

00:00 – Intro
00:45 – Testing web services
01:12 – Testing with Postman
01:43 – Installing Postman
02:10 – Running a test with Postman
03:22 – Add existing endpoints to Postman
04:38 – Creating a new insert endpoint
05:07 – Using Run SQL Scripts to test SQL
05:30 – Adding first endpoint
09:08 – Create JSON with VS Code
09:52 – Test new endpoint with Postman
11:08 – Create second endpoint
13:05 – Test update endpoint
13:31 – Check out learning.formaserve.co.uk & Powerwire.eu
15:03 – Wrap Up!

🚩 Connect with us on social
– LinkedIn: https://linkedin.com/in/andyyouens
– LinkedIn: https://www.linkedin.com/company/formaserve-systems/
– Twitter: https://twitter.com/AndyYouens
– Twitter: https://twitter.com/FormaServe
– Website: https://learning.formaserve.co.uk
– Website: https://www.formaserve.co.uk

🔔 Subscribe to my YouTube channel https://www.youtube.com/FormaServeSystemsLtdLoughton?sub_confirmation=1

👋 Additional resources
– GitHub: https://www.github.com/FormaServe/f_learning

📃Playlists
– BASH on IBM i: https://www.youtube.com/playlist?list=PLohFZaDbDd2Pn7e4xMCsl5TQakkVUow8U
– Open Source on IBM i: https://www.youtube.com/playlist?list=PLohFZaDbDd2Pj6A6Uaz_pfKGP6zmJohJ2
– Programming on IBM i: https://www.youtube.com/playlist?list=PLohFZaDbDd2Pg-OiESOSk8JBSkeaFjLA7
– IBM DB2 for i: https://www.youtube.com/playlist?list=PLohFZaDbDd2NUtmAhBBn-TdKNMXkwu9ha
– Marketing: https://www.youtube.com/playlist?list=PLohFZaDbDd2Onve_ZFIgglJrxP8Rl33cn

-☕ Could really do with a coffee after producing this video – https://ko-fi.com/andyyouens

Leave a Reply