It's larger than 9999. What does the 4 refer to? Thanks.
4  13486  gi************* ******@yahoo.co m 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/
Thanks Serge,
It must be a AQT (Advanced Query Tool) thing. AQT says the length is 4.
gi************* ******@yahoo.co m 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 gi************* ******@yahoo.co m 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 ?
thanks
|
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 one).
I want to find the maximum value for this type. This seems to work just
fine:
static_cast<T>(-1)
|
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
|
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????
|
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 arguments.
(b)Write a main program that inputs MAX values from the keyboard into a signed
integer array, array, and points, using largest(), the largest value to the screen.
| | |
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?
|
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 this command:
Dim intMaxIdx As Integer = CInt(Me.ds.myTable.Compute("MAX(Idx)",
Nothing))
I noticed that this command treats the values like strings rather than
integers. For example, if I have a value of 2 and a value of 11, the
|
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 values)
dic = {0:4,3:1,5:2,7:8}
So, the the largest values are , so the keys are .
|
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 value of 12 and 79 respectively.
What's simplest way to do that in A97?
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
