MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2014

SQL2XLS was: CPYTOIMPF



fixed

SQL2XLS SQLSTMT('select * from ssc.clust00001') TOXLS('/rob/clusterdeploy
ment.xls') SHEETNAME(CLUSTERDEPLOYMENT) COLHDRS(*SQLLABEL)
sql=>select * from ssc.clust00001.
Not enough SQLVAR entries were provided in the SQLDA.

SQL0237
Message . . . . : Not enough SQLVAR entries were provided in the SQLDA.

Cause . . . . . : The SQLDA only provided 20 SQLVAR entries. Since at
least
one of the columns being described is a distinct type or a LOB, 24
SQLVAR
entries should have been specified. None of the secondary SQLVAR
entries
have been set. Since at least one of the columns is a distinct type or a

LOB, space should be provided for twice as many SQLVAR entries as the
number
of columns. Only the base SQLVAR entries have been set.
Recovery . . . : If there is no need for the additional information
about
the distinct type(s) or LOB(s), then no action is required. If this
information is needed, the value of the SQLN field in the SQLDA should
be
increased to the value indicated in the message, and the statement
should be
resubmitted.


Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact