View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 03:48 AM
Karl Hanson
 
Posts: n/a
Default Re: Where can I find what type of field DB2 has

Mark A wrote:
> "galsaba" <galsaba@aol.com> wrote in message
> news:1116536248.944538.86910@z14g2000cwz.googlegro ups.com...
>
>>I am using db2 on AS400.
>>Where can I find out what type of fields it has?
>>I am particulary interested to know what is the maximum text field
>>size.
>>is it 256? or more?
>>
>>Thanks,
>>
>>galsaba
>>

>
> Try the SQL Reference. You can look at Create Table and in the Appendix for
> SQL Limits.
>
>


Links for the latest release (V5R3) of DB2 UDB for iSeries:

http://publib.boulder.ibm.com/infoce...zmsthctabl.htm
http://publib.boulder.ibm.com/infoce...mstlimtabs.htm

--
Karl Hanson
Reply With Quote