Jane Man's Blog (22)

Complimentary whitepaper on Db2 for z/OS function level 501 - LISTAGG

With Db2 for z/OS continuous delivery model, new Db2 for z/OS features/enhancements are continuously delivered in service stream when they are ready. LISTAGG is one of first set of functions delivered in function level 501 since Db2 adopted continuous delivery model.

In the…

Continue

Added by Jane Man on November 24, 2017 at 18:34 — No Comments

Quick Start in accessing DB2 for z/OS from Python applications

Python is one of the most commonly used programming language. Its interactive mode is ideal for prototype development and ad-hoc tasks. There is also a development GUI. Both are free to download or use under open source license. In the following article, I am going to show you how to use Python to connect to DB2 11 for z/OS and perform some basic database operations.…

Continue

Added by Jane Man on March 11, 2017 at 2:00 — No Comments

Node.js Application and DB2 REST services

DB2 for z/OS delivered native REST services support in the end of 2016. I wrote 2 white paper on how to create a DB2 REST service and how to consume this service from a mobile device. I start getting enquiries on how to consume a DB2 REST service from a node.js application. In the following blog, I am going to share my…

Continue

Added by Jane Man on March 5, 2017 at 18:25 — No Comments

Machine Learning using DB2 for z/OS data

Using machine learning features in Spark and an easy to follow example, learn how you can build/train/test a machine learning model using data from DB2 for z/OS.

Machine Learning using DB2 for z/OS data and Spark Part 1…

Continue

Added by Jane Man on January 2, 2017 at 6:00 — No Comments

Spark Analytics for XML data in DB2 for z/OS

Want to share my recent research on this topic:

Spark Analytics for XML data in DB2 for z/OS – Part 1 : scala.xml.XML

http://ibm.co/2frZw2y



Spark Analytics for XML data in DB2 for z/OS – Part 2 : databricks XML package – on a single XML document

http://ibm.co/2frZE22



Spark Analytics for XML data in DB2 for z/OS – Part 3 : databricks XML package – on XML data in…

Continue

Added by Jane Man on November 11, 2016 at 21:00 — No Comments

Complimentary whitepaper on DB2 for z/OS Native DDF REST services

Applications focused around mobile devices are becoming increasingly important in large enterprises. RESTful APIs pay an important role in this area. From the following whitepaper, learn how you can expose DB2 functionality through RESTful APIs that are fully integrated in the DB2 distributed data facility (DDF) and how you can consume a DB2 REST service to build a DB2 for z/OS mobile application using IBM MobileFirst.…

Continue

Added by Jane Man on November 8, 2016 at 21:05 — 3 Comments

Watson and DB2 for z/OS

Check out my latest post on how to build a DB2 for z/OS application to leverage cognitive APIs provided by Watson:

http://ibm.co/2f0KmUV

Added by Jane Man on October 22, 2016 at 1:00 — No Comments

Free article on Advanced JSON SQL interface in DB2 for z/OS

Check out my latest article on JSON in IBM developerWorks:

http://ibm.co/2ejxSDC ; - Advanced JSON SQL interface in DB2 for z/OS

If you are new to JSON in DB2 for z/OS, you may want to read my other article first:

Use a SQL interface to handle JSON data in DB2 11 for…

Continue

Added by Jane Man on October 17, 2016 at 18:30 — 22 Comments

DB2 for z/OS and external REST APIs

APIs is the buidling blocks for apps. JSON and XML are two commonly used output in REST calls. The following articles describe how DB2 for z/OS invokes a REST service and how it utilizes the REST output.  

DB2 for z/OS as a REST Service Consumer – Part 1: JSON output…

Continue

Added by Jane Man on October 14, 2016 at 16:02 — No Comments

Simplify Application Logic using Archive Transparency Features in DB2 for z/OS

The following article written by 2 key DB2 for z/OS developers

 discusses the key concepts and capabilities of DB2 Archive Transparency functionality and how it can be used to simplify application logic. With the built-in global variables, DB2 uses SQL to provide basic capability for data archiving and transparent access to archive data via queries. It is a…

Continue

Added by Jane Man on October 11, 2016 at 21:00 — No Comments

JAVA UDF to Construct JSON document from SQL query results

Continue

Added by Jane Man on October 5, 2016 at 21:30 — No Comments

Using DB2 for z/OS Command Line Processor (CLP) in USS and/or Window

Just come back from an XML bootcamp in France. During the bootcamp, I demo how to use CLP to register XML schema in my Window machine. Attendees got an impression that I was using the CLP that delivered with DB2 LUW. In fact, I was using the CLP delivered with DB2 for z/OS. Since it is a jar file, so I ftp it to my Window machine to use.

DB2 for z/OS CLP is designed to run in USS. The clp.jar I used for…

Continue

Added by Jane Man on May 20, 2016 at 20:19 — No Comments

Complimentary Whitepaper on DB2 Adapter for z/OS Connect: Consume a DB2 Adapter service - Part 2

A few days after my whitepaper for DB2 Adapter for z/OS Connect Part 1 was online, I have people asking me for Part 2

Eventually, Part 2: Build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect, Part 2: Consume a DB2 Adapter service is online…

Continue

Added by Jane Man on March 17, 2016 at 21:19 — No Comments

Complimentary Whitepaper on DB2 Adapter for z/OS Connect: Expose DB2 functionality using REST APIs call - Part 1

To create effective, enterprise-ready mobile applications, you need to make the back-end data easier to consume. APIs in IBM® DB2® Adapter for z/OS expose DB2 for z/OS functionality to applications. See an easy-to adapt example to learn how you can build a DB2 for z/OS mobile application using DB2 Adapter for z/OS Connect and IBM MobileFirst Developer Edition. In In Part 1 of the following complimentary whitepaper, discover how to expose DB2 for z/OS functionality by using DB2 Adapter for…

Continue

Added by Jane Man on March 2, 2016 at 1:27 — No Comments

Convert JSON data to Relational Format

DB2 11 for z/OS offers document storage support for JSON. The JSON data is stored internally as BSON (Binary-encoded Serialization of JSON) in inline BLOB column.

 

DB2 11 for z/OS provides the following SQL APIs to manipulate JSON data:

 …

Continue

Added by Jane Man on February 19, 2016 at 19:00 — No Comments

Pattern matching using regular expression in DB2?

In DB2 for z/OS, we can use LIKE predicate to do pattern matching, in which we use

  • the underscore character(_) represents any single character

  • the percent sign(%) represents a string of zero or more…

Continue

Added by Jane Man on January 15, 2016 at 22:30 — No Comments

IBM MobileFirst blog 3: Using a stored procedure to run a utility

In this post, we'll show you how to use a stored procedure to call a standard DB2 for z/OS utility, RUNSTATS, from within a mobile app. You can apply the steps in this post to call other DB2 for z/OS utilities as well.

Before you begin, make sure that you've completed part 1 and…

Continue

Added by Jane Man on October 28, 2015 at 5:10 — No Comments

IBM MobileFirst blog 2: Using regular SQL statements to retrieve data from DB2 table

Before you begin, make sure that you've set up your IBM MobileFirst Platform environment by completing the steps in part 1 of this tutorial.

In this post, we'll retrieve a string from SYSIBM.SYSXMLSTRINGS. SYSIBM.SYSXMLSTRINGS is a catalog table that contains mappings between the…

Continue

Added by Jane Man on October 28, 2015 at 5:00 — No Comments

IBM MobileFirst blog 1: Setting up your environment

Because of its quality of service, high availability, security, and performance, many organizations rely on DB2 for z/OS to store their critical transactional data. We've entered a new era in which we increasingly use our phones and tablets for all types of transactions -- everything from shopping and banking to social interaction and research -- mobile access to DB2 for z/OS transactional data is more critical than ever.

IBM MobileFirst Platform is an ideal platform for…

Continue

Added by Jane Man on October 28, 2015 at 4:30 — No Comments

Predictive analytics using IBM SPSS Modeler in DB2 for z/OS

You don't need to be a PhD to do predictive analytics on data stored in DB2 for z/OS. The complimentary whitepaper below illustrates

how to use the SPSS Modeler workbench to create predictive models with in-database mining, SQL push-back, and UDF scoring. The whitepaper walk through the steps for integrating in-database real-time scoring for DB2 for z/OS into an OLTP application.…

Continue

Added by Jane Man on October 22, 2015 at 17:54 — No Comments

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

IBM Db2 AI for z/OS and Db2 12 function level 503 available now!

Posted by Paul McWilliams on September 21, 2018 at 17:26 0 Comments

 



For more about IBM Db2 AI for z/OS and Db2 12 function level 503, check out…

Continue

Videos

  • Add Videos
  • View All

© 2018   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service