Recent changes to 20: SQLCOLUMNS Returns no columnshttps://sourceforge.net/p/rexxsql/support-requests/20/2008-09-10T11:23:47ZRecent changes to 20: SQLCOLUMNS Returns no columnsSQLCOLUMNS Returns no columns2008-09-10T11:23:47Z2008-09-10T11:23:47Zoorexxperthttps://sourceforge.net/u/oorexxpert/https://sourceforge.netf4ac38c816d8ef747298d4ffe3d0906e3bf79a79<div class="markdown_content"><p>Using REXXSQL 2.5 on Orcale 10. SQLCOLUMNS does not return any columns. All of the stem variables set have zero columns. In Oracle, we have a schema and a table name which should be all that is needed to access the columns. We have tried the schema name in the SQLCOLUMNS but it didn't work.</p>
<p>TESTCASE:</p>
<p>say "Loading REXXSQL";<br />
call RXFuncAdd 'SQLLoadFuncs','rexxsql','SQLLoadFuncs';<br />
Call SqlLoadFuncs;</p>
<p>say "Connecting.";<br />
rc = sqlconnect(,"PINN_CUSTOM","iwise",,"ORCL-NEW");<br />
say "Return code from SQLCONNECT =" rc;<br />
if rc <> 0 then<br />
exit;</p>
<p>say "";<br />
say "Getting tables.";<br />
rc = sqltables("T",,,"REQUEST");<br />
say "Return code from SQLTABLES =" rc;<br />
if rc <> 0 then<br />
exit;<br />
say "There are" t.~items "table items returned.";<br />
do tx over t.;<br />
say tx "is" t.tx;<br />
end;</p>
<p>say "";<br />
say "Getting columns.";<br />
rc = sqlcolumns("C",,,"REQUEST");<br />
say "Return code from SQLCOLUMNS =" rc;<br />
if rc <> 0 then<br />
say "Return code" rc "from SQLCOLUMNS";<br />
say "There are" c.~items "column items returned.";<br />
do cx over c.;<br />
say cx "is" c.cx;<br />
end;</p>
<p>RESULTS:</p>
<p>Loading REXXSQL<br />
Connecting.<br />
Return code from SQLCONNECT = 0</p>
<p>Getting tables.<br />
Return code from SQLTABLES = 0<br />
There are 15 table items returned.<br />
TABLE_NAME.0 is 2<br />
TABLE_TYPE.0 is 2<br />
TABLE_NAME.2 is REQUEST<br />
TABLE_NAME.1 is REQUEST<br />
TABLE_OWNER.0 is 2<br />
TABLE_TYPE.2 is TABLE<br />
TABLE_CATALOG.0 is 2<br />
TABLE_OWNER.2 is PINN_CUSTOM<br />
TABLE_OWNER.1 is PINN_CUSTOM<br />
TABLE_TYPE.1 is TRIGGER<br />
TABLE_DESCRIPTION.0 is 2<br />
TABLE_CATALOG.2 is<br />
TABLE_DESCRIPTION.2 is<br />
TABLE_DESCRIPTION.1 is<br />
TABLE_CATALOG.1 is</p>
<p>Getting columns.<br />
Return code from SQLCOLUMNS = 0<br />
There are 10 column items returned.<br />
TABLE_NAME.0 is 0<br />
COLUMN_SIZE.0 is 0<br />
COLUMN_TYPE.0 is 0<br />
COLUMN_NAME.0 is 0<br />
COLUMN_SCALE.0 is 0<br />
COLUMN_NULLABLE.0 is 0<br />
COLUMN_DESCRIPTION.0 is 0<br />
COLUMN_PRECISION.0 is 0<br />
TABLE_CATALOG.0 is 0<br />
TABLE_OWNER.0 is 0</p></div>