Articles & Content

Archives

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

Topic: DB2 for z/OS

Subtopic: 2009



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

OBJECTIVES:

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



Click Here to Download

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