Results 1 to 4 of 4

Thread: What is sqlca Informix stored Procedure

  1. #1
    Join Date
    Dec 2008
    Posts
    35

    What is sqlca Informix stored Procedure

    I have heard that the stored procedure is declared in the transaction object as a local external function, I am moving to php-4.2.1 now and still looking for explanation how to use exeption handling in informix stored procedures.

  2. #2
    Join Date
    Oct 2008
    Posts
    80

    Re: What is sqlca Informix stored Procedure

    Dynamic SQL refers to SQL statements that can be constructed and executed dynamically during run time, based on supplied user input.

    To find out the sequence number generated execute sql:
    SELECT DBINFO('sqlca.sqlerrd1') FROM systables WHERE tabid=1 ;

    IDS SPL is an extension to SQL for implementing business logic in the form of modules in the database server. To call the SP execute SQL:
    EXECUTE PROCEDURE GetSerialNumber() Many database applications need dynamic SQL capability when queries are not fully known up front during application design or implementation phases.

  3. #3
    Join Date
    Dec 2008
    Posts
    128

    Re: What is sqlca Informix stored Procedure

    Stored procedures assist in achieving a consistent implementation of logic across applications. The SQL statements and logic needed to perform a commonly performed task can be designed, coded, and tested once in a stored procedure. SQL statements that are known at the time the procedure is created are called static SQL statements. CREATE PROCEDURE TEST()
    RAISE EXCEPTION -746, 0, "testing...";
    END PROCEDURE Static statements have advantages, because these SQL statements are checked for syntactical and semantic correctness and optimized during procedure compilation.

  4. #4
    Join Date
    Oct 2008
    Posts
    180

    Re: What is sqlca Informix stored Procedure

    Stored procedures are extremely similar to the constructs seen in other programming languages. They accept data in the form of input parameters that are specified at execution time. With only static statements support in SPL, the requirement of SQL statements that are expected to be known only during run time (called dynamic SQL) cannot be achieved. Stored procedures can also improve performance. Many tasks are implemented as a series of SQL statements. Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed.

Similar Threads

  1. Stored procedure in MySQL database
    By Ameeryan in forum Software Development
    Replies: 5
    Last Post: 04-03-2010, 10:31 PM
  2. Use Of Stored Procedure in SQL Server
    By technika in forum Software Development
    Replies: 5
    Last Post: 30-01-2010, 11:24 AM
  3. How to create, deploy and use DB2 stored procedure
    By garfield1 in forum Software Development
    Replies: 3
    Last Post: 08-08-2009, 11:10 AM
  4. How to Write stored procedure in SQL Server
    By Benito in forum Software Development
    Replies: 3
    Last Post: 03-08-2009, 12:29 PM
  5. How to call stored procedure using do while Loop
    By AK_Chopra in forum Software Development
    Replies: 3
    Last Post: 29-05-2009, 01:47 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,705,143.51039 seconds with 17 queries