You might want to restrict your database tables to use only certain field types. These are defined at Partition level (see under System Information on the Repository tab). If you have a standalone installation you will have these settings initially:
Change these settings to restrict the field types which may be used to define a field in the Repository.
Users with a Slave Workstation install must change settings in LANSA on the IBM i.