3 6 4 File Uses SQL On IBM i

3.6.4 File Uses SQL On IBM i

Read only.

For LANSA Files, Yes indicates that the IBM i file was created with SQL the last time it was built (rather than DDS and CRTPF). This value is only set on Checkout from IBM i (or when a LANSA Import is done).

LANSA files are built with SQL for a number of reasons, for example, if they include a BLOB or CLOB field. You can force all files to be built with LANSA SQL. For details, see the option Always Build Using SQL (IBM i) in System Definitions in the Administrators Guide.

For IBM i Other Files, Yes indicates that SQL must be used to access the file at execution time. This value is set during Load Other File. Refer to Load Other File for further information.

Also see

Always build using SQL in Field and File Defaults</A> in the LANSA for i User Guide.

Ý 3.6 File Attributes