Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2011
    Posts
    5

    Unanswered: How to create stored procedure using dynamic SQL?

    I hope this is not a limitation of Informix, I was trying to create a stored procedure using dynamic SQL, may I know is this possible can be done so?

    )

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    What do you call dynamic SQL? I think you make a confusion and would like to confirm, in order to bring you the right reply

    E.

  3. #3
    Join Date
    Dec 2011
    Posts
    5
    Sorry for my bad, when we create a procedure, we issue the following command:

    create procedure proc_A()
    end procedure;

    What if I want to move this code into dynamic SQL, or in other words, I want to have a dynamic SQL that create a procedure during runtime, is it possible to do?

    )

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    I think the article I mentionned in your other post also answers your question

    E.

  5. #5
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    Hi huahsin68,

    I think you can take a look at this video, maybe help you:

    Dynamic SQL in IBM Informix Dynamic Server 11.5 - YouTube

    You must see your IDS version

    Bye.
    LS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •