By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,225 Members | 1,051 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,225 IT Pros & Developers. It's quick & easy.

Where can I find what type of field DB2 has

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"galsaba" <ga*****@aol.com> wrote in message
news:11*********************@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.
Nov 12 '05 #2

P: n/a
Mark A wrote:
"galsaba" <ga*****@aol.com> wrote in message
news:11*********************@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
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.