Informix SPL
Usha M Rao asked whether constants can be defined in Informix stored procedure language. Dennis Pimple said no, if constants means variables that cannot be changed after being set. Chetan Anand suggested a #define style with the SPL run through the C preprocessor. Paul Watson agreed there are none, mentioning lookup tables or pre-processing, but said it was usually not worth the hassle.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
If you mean variables that, once set, can't be changed, no. -- <html> =======================================================<br> Dennis J. Pimple <b>Inform<font color="#FF0000"><i>i</font></i><font color="#0000FF">x</font></b><font color="#000000"> Software, Inc.<br> Principal Consultant 6300 S Syracuse Way Ste 205<br> dennisp@informix.com Englewood CO 80111<br> office: 303-850-0210 <br> direct: 303-740-5611 Opinions expressed are mine,<br> fax: 303-779-4025 and do not necessarily<br> reflect those of my employer<br> <br> <a href="http://www.informix.com/"; eudora="autourl">http://www.informix.com</a>; </font></html> Usha M Rao <usha_mr@trigent.com> wrote in message news:88e67n$ks1$1@news.xmission.com... > > Can I define Constants in Informix stored procedure language? >
Can I define Constants in Informix stored procedure language?
Usha M Rao wrote: > Can I define Constants in Informix stored procedure language? INFORMIX donot allow CONSTANTS like 'C' or Java. But you get work around through #define style and parsing your SPL through CPP. Rgds
No, you can use lookup tables, pre-process the SPL etc but it's not usually worth the hassle Usha M Rao wrote: > > Can I define Constants in Informix stored procedure language? -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674728 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #