Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: REST

DB2 Native REST API – VB.NET Tool wDB2REST

Published June 5th, 2018 - by

Introduction Whilst working with the DB2 for z/OS REST API, I thought it would be useful to have a tool to make things easier to see what was defined, what the parameter profiles look like and maybe even be able to run the services. To that end, I’ve written one in VB.NET called wDB2REST. It’s Continue Reading

DB2 Native REST API – Python

Published March 16th, 2018 - by

Introduction Whilst I haven’t used Python for a while, it has always been the playground for geeks. With it’s C-like look and feel and it’s huge array of extension libraries there’s very little it can’t do. I was prompted to refresh my acquaintance with Python by a colleague who’d been reading this blog chain – Continue Reading

DB2 Native REST API – Creating Services from TSO / Batch

Published February 16th, 2018 - by

Introduction One of the challenges that we’ve faced working with the DB2 for z/OS native REST API is the mid-range nature of the interface when creating services. This doesn’t sit so well with the existing mainframe landscape and administration processes and the fact that Data Studio (at least up to V4.1.3) doesn’t work with it Continue Reading

DB2 Native REST API – curl

Published January 31st, 2018 - by

Introduction One of the things that we frequently want to do is to perform a quick check of the REST service that we’ve just created. In the previous blogs we’ve seen how we can do this with PHP and Java, but why can’t we just use a command line tool? Well, we can. Curl, or Continue Reading

DB2 Native REST API – Bonus Material – node.js

Published January 12th, 2018 - by

Introduction This is the 6th blog post in the (ahem) series of 5 on the DB2 for z/OS native REST interface. The previous entries are: DB2 Native REST API – Getting Started DB2 Native REST API – Creating Services DB2 Native REST API – A Sample REST Application DB2 Native REST API – Security DB2 Continue Reading

DB2 Native REST API 5 – BLOBs, CLOBs and Stored Procedures

Published December 1st, 2017 - by

Introduction In the previous blogs in this series, we’ve seen that the process of creating and consuming REST services with DB2 for z/OS V11 and V12 can be managed easily with PHP. In this blog, we’ll look at how we access LOB data, and finally how we use stored procedures to drive business logic.   Continue Reading

DB2 Native REST API – Security

Published May 2nd, 2017 - by

Introduction In the previous blogs on the DB2 Native REST API, we’ve talked about installation of the feature, how to create and drop services, and how to drive them. In this one, we’re going to have a look at how security works with REST – both in general HTTP/HTTPS terms, and from the point of Continue Reading

DB2 Native REST API – A Sample REST Application

Published February 27th, 2017 - by

Introduction In previous blogs in this series, we’ve seen how to install and configure the REST API, and how to create and delete services within it using PHP. This blog will focus on a simple REST application that displays information based on the IBM supplied sample data. Application Overview The Spiffy Computer Company (blame IBM Continue Reading

DB2 Native REST API – Creating Services

Published February 10th, 2017 - by

Introduction In the first blog in this series, we discussed how to enable the native REST API in DB2 for z/OS. In this edition, we’re going to focus on how we go about creating new services and what methods we used to do this. In doing so, we’re going to be using PHP – which Continue Reading

DB2 Native REST API – Getting Started

Published January 17th, 2017 - by

Introduction With DB2 for z/OS customers expanding their business presence into the mobile client world, solution developers are seeking more efficient ways to leverage existing data and business logic to support this. The REST (Representative State Transfer) native API implemented in DB2 is a light weight interface using HTTP POST / GET request handling to Continue Reading