Articles & Content


DECFLOATing in a BIGINT Pool of (VAR)BINARY Data (E13)

Topic: 2009 EU

Subtopic: DB2 for z/OS

DATE: 2009-10-7 (15:45 - 16:45)
SPEAKERS: Steve Thomas (BMC Software)

The ability to store XML data in DB2 has rightly been the focus of much attention since DB2 9 for z/OS was announced, and is the topic of several sessions at this Conference. However, IBM also introduced a number of other useful new data types, BIGINT, BINARY, VARBINARY and DECFLOAT, which have received far less publicity. This presentation will correct this omission by covering all these new data types in more detail, explaining how to use them, how they are stored, what you can do with them and things you should be aware of if you decide to try and use them in your applications. For example, did you know that you can now store a value of Infinity in a DB2 Data Type? Well you can, although depending on which language you use you may not be able to use it in your programs! Come and learn how and clear up some other mysteries associated with these new type of data.

EXP. LEVEL: Beginner,Intermediate


Provide an introduction to all the new Data Types introduced in DB2 9 for z/OS - XML, BIGINT, BINARY, VARBINARY and DECFLOAT.

How to define and use BINARY and VARBINARY data

How to define and use BIGINT data

What is DECFLOAT data and why would I want to use it?

How to use the new DECFLOAT data type in DB2 9 for z/OS

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.