If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Seeking #include equivalent for SPL?!?!?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-17-03, 14:58
astrue astrue is offline
Registered User
 
Join Date: Dec 2002
Location: Portland, OR, USA
Posts: 26
Seeking #include equivalent for SPL?!?!?

I'm trying to find a method for defining some constant values across some 200 stored procedures without touching each code member every time, much the way one would use an INCLUDE type statement in some other language. So far, the best I can find is to declare GLOBAL variables. However, I find that once I have done so, I still have to DEFINE each one in each stored procedure, along with a DEFAULT value, before I can use it. This severely limits the utility of the approach and keeps it from being the neat, tidy solution I am seeking (change it once in one place, recompile all the other stored procs and be done with it).

Does anyone know of a construct I should be aware of to resolve this maintenance nightmare?

I'm using Informix SE 7.25, SDK 2.80 on Red Hat Linux 7.3, in case it matters.

Thanks in advance for your input.
Reply With Quote
  #2 (permalink)  
Old 09-17-03, 15:06
Roelwe Roelwe is offline
Registered User
 
Join Date: Aug 2002
Location: Belgium
Posts: 534
Since you ar eusing SE, I don't think you have any other option.
If you'd use IDS v9, you might want to look at datablades.
__________________
rws
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On