Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic SQL in stored proc possible??

Status
Not open for further replies.
schu

schu

MIS
Jun 21, 2001
188
HK
Is creating dynamic SQl in a stored proc possible???

 
Sort by date Sort by votes
You can pass parameters to a stored procedure making the SQL dynamic. Go to Informix.com and look at the documentation for syntax of stored procedures.
 
Upvote 0 Downvote
Thanks,
But that is not dynamic, I need to change the SQL, but stored procs do not allow PREPARE and EXECUTES.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kray4660
  • Locked
  • Question
Informix 3.500.00.14008 64-bit ODBC driver download
Replies
0
Views
171
kray4660
kray4660
kray4660
  • Locked
  • Question
Stored Procedure attempt
Replies
0
Views
141
kray4660
kray4660
daYorkie
  • Locked
  • Question
How many UNIONs can i use in a single query?
Replies
2
Views
170
daYorkie
daYorkie
welcome07
  • Locked
  • Question
What should Be Sequence of Installing IDS in DEV Server.
Replies
0
Views
140
welcome07
welcome07
Liliana Solis
  • Locked
  • Question
Correr script desde informix 4gl
Replies
0
Views
155
Liliana Solis
Liliana Solis

Part and Inventory Search

Sponsor

Back
Top