Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by posty2k
-
SELECT FROM TWO TABLES WORKS, THREE DOESN'T
Tom, Thanks for giving us a good direction. Upon further analyzing our setup, we found that the schema needed to be identified in our FROM portion. The statement should have been set up: "SELECT .... FROM schema1.x, schema1.y, schema1.z WHERE ...." Yes, this begs the question why this wasn't... -
SELECT FROM TWO TABLES WORKS, THREE DOESN'T
This is my first post so bear with me. It is directed to k5tm but, of course, anyone can reply. RMCOBOL V9, installed the Instant SQL package with appropriate Oracle drivers under Linux. Using the SQL CONNECT, SQL PREPARE, SQL BIND COLUMN, SQL BIND PARAMETERS, etc. I was able to get queries... -
SQL error: [unixODBC]Couldn't parse SQL
This is my first post so bear with me. It is directed to k5tm but, of course, anyone can reply. RMCOBOL V9, installed the Instant SQL package with appropriate Oracle drivers. Using the SQL CONNECT, SQL PREPARE, SQL BIND COLUMN, SQL BIND PARAMETERS, etc. I was able to get queries on two tables...
