What's hot ? (84)

Discussions Replies Latest Activity

CSI: DB2 PART ONE - Historical Data Forensics On Demand for Audit Defense

Check out this insightful blog, written by Shantan Kethireddy, IBM Master Inventor and the NA Solution Architect for analytics solutions on…

Started by Patricia Zakhar

0 Jul 19, 2017

Connecting DB2 using XL C/C++ from ZOS unix

We are trying to connect ZOS DB2 from ZOS unix using XL C/C++ programming language. Compilation is successfully completed with the help of…

Started by srini

1 Jun 20, 2017
Reply by srini

Recover the Dropped TableSpace

How to recover the dropped tablespace? I have gone through the DB2 ADMIN GUIDE. But still I couldn't do that. Please help me out. Thanks in…


3 Jan 20, 2017
Reply by Alice Jolly

DB2 Tech Talk: Jump start 2017 with a new DB2 11.1

Since the release of DB2 11.1 for Linux, UNIX and Windows in June 2016, we have made numerous updates enhancing functions and introducing n…

Started by Sajan K

0 Jan 19, 2017

Save the Date: IDUG EMEA 2017 will be Held in Lisbon, October 1-5

The premier European DB2 Conference will take place on October 1-5, 2017 at Lisbon, Portugal. Make your plans to attend and experience the…

Started by Mateja Jankovič

0 Nov 28, 2016

NEW Announcement: DB2 Analytics Accelerator on Cloud Version 1.1 and a new version of the DB2 Analytics Accelerator, Version 6.1

Today, IBM announced a brand new product, the DB2 Analytics Accelerator on Cloud Version 1.1 and a new version of the DB2 Analytics Acceler…

Started by Patricia Zakhar

0 Oct 18, 2016

IDUG EMEA 2016 - Register Early to Save

Registration is now open for the IDUG DB2 Tech Conference in Brussels, Belgium, taking place 13-17 November, 2016 at the Crowne Plaza Brus…

Started by Mateja Jankovič

0 Aug 26, 2016

State of DB2 - Market Survey

Calling DB2 users to please share your experiences about IBM DB2 by taking this short survey on TechValidate.com.   Click here  to start su…

Started by Sajan K

0 May 5, 2016

Revoking sysadm...

In a revoke of sysadm authority, I've found that views are dropped based on the ID in column CREATEDBY on table SYSIBM.SYSTABLES.  The SQL…

Started by Bill Hulsizer

16 Apr 27, 2016
Reply by Bill Hulsizer

Complimentary IDUG EMEA Conference Pass for #DB2 User Groups in EMEA.

Do you lead a #DB2 User Group in EMEA? IBM are offering a complimentary conference pass for IDUG EMEA 2016 in Brussels to DB2 User Groups…

Started by Surekha Parekh

0 Apr 22, 2016


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


Creating a function in DB2

Started by Jacob Ruchotzke in What's hot ? Jun 18. 0 Replies

With the help of our IT guy i have sort of gotten an example of how to create a function in our system. Can anyone help me with this? Please see the attached SQL file.Thanks in advanceContinue

Tags: function

Conversion of BLOB to String/ Text

Started by Jitesh Audichya in Application Development and DB2. Last reply by Jitesh Audichya Apr 24. 2 Replies

Hi All,Problem Statement:I have a field with BLOB data type in DB2 database, I want to extract this blob and convert it to Text. The text data after the conversion will be in Japanese characters. How can I write a select with the conversion from…Continue

Tags: on, DB2, conversion, text, to

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service