Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-08-2009
Member
 
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.
Reply With Quote
  #2  
Old 13-08-2009
Member
 
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.
Reply With Quote
  #3  
Old 13-08-2009
Member
 
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.
Reply With Quote
  #4  
Old 13-08-2009
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is sqlca Informix stored Procedure"
Thread Thread Starter Forum Replies Last Post
Stored procedure in MySQL database Ameeryan Software Development 5 04-03-2010 10:31 PM
Use Of Stored Procedure in SQL Server technika Software Development 5 30-01-2010 11:24 AM
How to create, deploy and use DB2 stored procedure garfield1 Software Development 3 08-08-2009 11:10 AM
How to Write stored procedure in SQL Server Benito Software Development 3 03-08-2009 12:29 PM
How to call stored procedure using do while Loop AK_Chopra Software Development 3 29-05-2009 01:47 PM


All times are GMT +5.5. The time now is 10:52 PM.