473,387 Members | 3,684 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

largest value for INTEGER 4

It's larger than 9999. What does the 4 refer to? Thanks.

Aug 8 '06 #1
4 13421
gi*******************@yahoo.com wrote:
It's larger than 9999. What does the 4 refer to? Thanks.
I frankly have never seen this syntax for integer with DB2, but
presumably it means 4-byte INTEGER (like FLOAT(4) is a 4-byte float)
INTGER 2 would be a 2 byte smallint and 8 a big integer (8 bytes).
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Aug 8 '06 #2
Thanks Serge,

It must be a AQT (Advanced Query Tool) thing. AQT says the length is 4.

Aug 8 '06 #3
gi*******************@yahoo.com wrote:
Thanks Serge,

It must be a AQT (Advanced Query Tool) thing. AQT says the length is 4.
Actually, when you do a "DESCRIBE TABLE ...", the INTEGER columns all show a
length of 4. It just means that 4 byte signed ints are used.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Aug 8 '06 #4
Ian
gi*******************@yahoo.com wrote:
Thanks Serge,

It must be a AQT (Advanced Query Tool) thing. AQT says the length is 4.
No, that comes from the system catalog. All columns in the database
have a type, length and precision. It just so happens that (by
definition), INTEGER has length 4 and precision 0.

As Serge said, LENGTH is the number of bytes required to store the
value.

Aug 8 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: news1.on.sympatico.ca | last post by:
what is the literal for the largest character value in java? ie. 111 in binary is representing 7 (4+2+1) <-- this is 3 bit now java is 32 or 64 bit what is the largest character value ? ...
3
by: Dave | last post by:
Hello all, Suppose you have an unsigned integral type T. It's not one of the built-in types, but rather typedefed off of one of the built-in unsigned integral types (but we don't know which...
7
by: Nicholas | last post by:
How can I get the largest possible value of the Integer Constants and use it in the program for these types: 1. int 2. long 3. unsigned short Thanks
32
by: jamieexley | last post by:
what are the parameters needed in the constructor call below to create a Date variable whose intitial value is the 15th of March 2004????
3
by: HEMH6 | last post by:
Who can help solve this problem??? Finding the Largest Value (a) write a function, largest(), that returns the largest value in a signed integer array. The array and its size are passed as...
3
by: Lazareth | last post by:
Hi, I need to know how to find the largest variable (integer) of a large amount of variables (integer). Can anybody help me with the code?
4
by: Randy | last post by:
Hi, I have a table which contains a unique value in a column called "Idx", which is a smallint data type. I need to find the maximum value in this column, which I have been attempting to do with...
6
by: Davy | last post by:
Hi all, I have a dictionary with n elements, and I want to get the m(m<=n) keys with the largest values. For example, I have dic that includes n=4 elements, I want m=2 keys have the largest...
8
by: MLH | last post by:
Is there any built-in FN for returning largest value in a group of say 2 - 10 values? Lets say I want a FN something like MaxVal(5, 7, 9, 3, 12) or perhaps MaxVal(79,34). I would wanna see return...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.