iDB2CommandBuilder restrictions on pre-V5R2M0 servers
Due to IBM® i limitations IBM i releases prior to V5R2M0, using the iDB2CommandBuilder, on these systems has limited support.
Properly specifying Select command text on the iDB2Command object used with the iDB2CommandBuilder is key when connecting to pre-V5R2M0 servers. Here are some recommended guidelines for creating Select statements for use on pre-V5R2M0 servers.
- Simple statements produce the best results. For example, SELECT * FROM MYSCHEMA.MYTABLE.
- Fully qualify the table name with its schema. For example, MYSCHEMA.MYTABLE.
- Selection fields are allowed, but must be specified in simple format. Only columns specified in the query table should be used. For example, SELECT ID, NAME, BALANCE FROM MYSCHEMA.MYTABLE.
- Derived fields or constants in the selection criteria are discouraged. They may produce unpredictable results. For example, SELECT ID, LENGTH(NAME), 'Name' FROM MYSCHEMA.MYTABLE.