Please explain "GenHdgsCSV" - is that part of SQL? Or how to build??
On Tuesday, April 03, 2012 12:03 PM CRPence wrote:
On 03-Apr-2012 08:41 , Stone, Joel wrote:
When building a list of field names, SQL stmts can get lengthy.
The longer each field name, the longer the SQL stmt.
Message . . . . : 11600 - RJSIMAGE/DOCSQL SQLSTM('insert into
Yuck. All the more reason to generate them directly from the
catalogs. Encapsulated in a function [as a FETCH cursor instead of
recursive query even], the above request could become [and once
again, eliminating some escaped apostrophes]:
SQLSTM('insert into qtemp/WORKHEADER