General information
Title:
Newbie client/server question, SQLEXEC() syntax for AS400
I've just created a connection to an AS400 but I'm having trouble issuing a simple SQLEXEC() to test it out. I'm getting back valid handles when I issue SQLCONNECT(). It appears that it doesn't like the syntax I'm passing in my SQL statement:
lnResult=sqlexec(lni, "Select * FROM HMPTKMSZ")
where lni is a valid connection handle. HMPTKMSZ is a valid table. I was able to verify that with SQLTABLES(). I tried "SELECT * from BMC2!HMPTKMSZ" where bmc2 is the table qualifier that SQLTABLES() returns, that didn't work either. Does anyone know how to reference a table on the AS400?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only