Visual LANSA Forum

I'm trying to use SQL_SELECT freeform like I've done 100's of times This is my first time using it on IBM i with iASP.

This file name format and error:

select LOTID ,PRPTYPCDE from MYIASP/MYDTALIB/MYFILE where myField = ' + #quote + #myfield.trim + #quote

This format MYIASP.MYDTALIB.MYFILE causes this error:

... and you are executing it directly in Windows as against directly on IBM i because?

Was wondering about the mention of MSSQL. It’s a vlf-win app and we connect to IBM I only. During debug it crashes at select_sql statement

Where is the code (function, component etc) that is executing the SELECT_SQL actually running? If not IBM i then I am not sure how it would work.

It’s windows vlf-win super server connected to IBM i. The code executes in RP compiled as windows only.

No other database or anything weird. Only iASP is different.

If I debug and take sqlselect variable I can execute with any SQL client or green screen.

The documentation on SELECT_SQL states this:

"Do NOT use this command to connect from Visual LANSA to a database on the IBM i. If you use the SELECT_SQL command to connect from Visual LANSA to an IBM i Database, it will access the Database on the PC and not on the IBM i. For this type of connection, you should use a remote procedure call (i.e call_server_function)."

This backs up what I have already been saying.

Also this:

"The use of imbedded SQL features and facilities may introduce platform dependencies into your applications. Not all SQL facilities are supported by all DBMSs. By bypassing the IOM/OAM associated with the table, you are bypassing the feature isolation it provides. Using SQL features and facilities that are DBMS defined, platform dependent extensions, is solely at the discretion of, and the responsibility of, the application designer. "

I believe that use of IBM i iASP in your SQL is IBM i only.

Oh now i see the light. I’ve done this lately always in server modules for VL-web.

Thank you for setting me straight.