dynamic sql in 11.5

Posted in 2008

dcruncher4@aim.com — 27 May 2008 03:10:37 -0700 — source: Usenet: comp.databases.informix

I saw this video http://youtube.com/watch?v=PmmT9elFCXg on the topic. Seems to be just like ESQL/C. However unlike ESQL/C SPL does not seem to support dynamic select columns because there is no equivalent of DESCRIBE in SPL. All selected columns get fetched into predeclared SPL variables which means that the column type has to be bound to the output of the query. Am I right or wrong?