Hello,
I would like to know, Is there any limitation for the maximum Key Field (Known By relation) or Non Key field (Has relation) which I can declare in on a Synon file?
Thanks & Regards
Bibin George
Software/Hardware used:
ASKED:
July 22, 2009 9:17 AM
UPDATED:
August 6, 2009 1:17 PM
Bibin,
There is no such limitations for Key fields or defining the fields in synon. Overall the size of the file should not exceed 32,766 bytes.
Regards,
Reena
DB2 for the iSeries has a limit of 2000 bytes for a key field. The size of the record is 32766 and 8000 columns.
Regardless of the language, these are the maximum limits you will run into. Refer to this link for more details:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzamp/rzampdbsql.htm