Information générale
Titre:
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement