ChannelDB2

Information

DB2 IN INDIA

This Group will contain all the information about users of DB2 in the Subcontinent. Anyone is free to join this group and participate!

Location: INDIA
Members: 75
Latest Activity: 13 hours ago

Welcome to our Group on ChannelDB2

Hi All and Namaste!!!,

Welcome to the DB2 In India Group on ChannelDB2.

This group will consist on the various efforts being carried out by users of DB2 and share their experiences with everyone.

Feel free to join and invite as many people as you can.

Thanking You
Anil Mahadev
IDUG India Forum CPC Lead

Comment Wall

Comment

You need to be a member of DB2 IN INDIA to add comments!

Comment by Rakesh Tiwari on September 11, 2010 at 8:02am
Hi,

Any one can suggest the DB2 Trainning center in the Gujarat (Ahmedabad). plus intersered in z/Os DB2 looking IBM Certified Trainning Center

Kind Regards

Rakesh Tiwari
Comment by Chang Sung KANG on November 6, 2009 at 7:46am
One of riskes using NUMBER datatype!

I found a interesting issue a NUMBER datatype on DB2.
When you also set up oracle mode (like db2_compatibility_set = ORA (or FFF)) in the DB2 9.7, in addition, you may happen to use NUMBER data type.
Especially you might use the default mode of "NUMBER" It can be automatically changed to decfloat type. Who cares?
I was about to find one funny thing when I use the default NUMBER type.
It would be divided into 0 !!

Look the flowing example!

1. check the version

select VERSIONNUMBER from sysibm.sysversions


VERSIONNUMBER
----------------
9070000

2. create a sample table and then try insert some numbers;

create table d1(c1 number) ;

insert into d1 values(10) ;

3. Divide them into 0!! Yes. it is working!

update d1 set c1=c1/0

Warnings: --->
W (1): DB2 SQL error: SQLCODE: 364, SQLSTATE: 0168F, SQLERRMC: DIVISION BY ZERO;DIVISION
DECFLOAT exception "DIVISION BY ZERO" has occurred during "DIVISION" operation.
<---

4. select the table and then you face with the funny result!

select * from d1

>[Error] Script lines: 1-2 --------------------------
DB2 SQL error: SQLCODE: -304, SQLSTATE: , SQLERRMC: null
Message: A value cannot be assigned to a host variable because the value is not within the range of the host variable's data type.


select char(c1) from d1


1
------------------------------------------
INFINITY
INFINITY
INFINITY

Yes. You can also test this fun situation, but I never hope this kinds of the result. Anyway, I also simply solve this problem using NUMBER (p,s) because it can convert decimal type !!
Comment by Shivraj Kumar Sarsambi on October 7, 2009 at 12:40pm
Hi All ,

DB2 enthusiasts can join this group on MyDeveloperWorks and share your expertise and views. Query Quest contests and others may fetch you goodies if your post / question is the best one . So start posting !
https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/communityview?communityUuid=ff78a96f-bf23-457e-befa-77f266844cbb
Comment by Rakesh on October 5, 2009 at 1:35am
anyone who attended IDUG 2009 India?
please share ur experience...
Comment by Anil Mahadev on July 31, 2009 at 4:09am
Hi Ravi,

I had a word count constraint, if not I could have written more.

Cheers! and thanks for the feedback
Anil
IIC
IDUG India BOD and CPC Chairman 2009
Comment by Shivraj Kumar Sarsambi on July 31, 2009 at 1:04am
Hi All,

http://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleappsondb2/index.html

The above article focusses on Oracle compatibilty introduced in DB2 9.7 , and portrays how easy it is to port your Oracle app in days to DB2 rather than months . Hope this helps you :)
Comment by RAVI GROVER on July 31, 2009 at 12:35am
Hi Anil!!
I have gone through your article on the latest IBM data management "SQL Compatibilty in DB2". It was a nice informative post that u had made. I wish you could explain more about the new isolation level(Currently Commited) in detail for 9.7. Cheers!!!
Comment by Chang Sung KANG on July 30, 2009 at 4:32pm
Hi
New data movement tool (using JAVA and JDBC) has launched
I tested it before, it could be interesting for you too.

http://www.ibm.com/developerworks/data/library/techarticle/dm-0906datamovement/index.html?S_TACT=105AGX63&S_CMP=DLESD&ca=dth-im&ca=ddc-
Comment by Anil Mahadev on July 30, 2009 at 2:44pm
Hi Rakesh, All the details will be made available on the website once done.
Comment by Rakesh on July 30, 2009 at 2:26pm
hi ! Anil...
Yes I came to know abt Idug 2009 India ...going to happen on september 24-26
can you tell me how much is it going to cost to attend?....
I really want to....
 

Members (75)

 
 
 

Try BLU Acceleration on Cloud

© 2014   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service