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

    Unanswered: How to capture output into variable in dynamic SQL?

    I have a query that capture output into variable, may I know how can I do the same thing in dynamic SQL? Base on the following query, let's assume it will always return 1 record.

    select fieldA into varA from table_A where fieldB='b';


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

    can you be a bit more specific? Are you talkingt about 4GL, ESQL/C, other?

    Thanks
    E.

  3. #3
    Join Date
    Dec 2011
    Posts
    5
    Sorry for my bad. It is in stored procedure. not 4GL.

  4. #4
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Check this article by Srinivasan R. Mottupalli,

    Dynamic SQL support in Informix Dynamic Server Stored Procedure Language

    it is very well done and should contain your answer

    Best regards
    E.

Posting Permissions

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