130 pts.
 Synon 2E
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

Answer Wiki:
do you mean field length? Its the limit of the language you use RPG is 256
Last Wiki Answer Submitted:  July 24, 2009  3:59 pm  by  Yorkshireman   5,505 pts.
All Answer Wiki Contributors:  Yorkshireman   5,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

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

 65 pts.

 

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

 880 pts.