Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

Section D.2. Variable assignment and declaration operators - Pg. 438

D.1 Arithmetic operators Table D-1 shows a mapping of the arithmetic operators for numeric and date time data types from SQL Server to Informix. Table D-1 Arithmetic operator mapping from SQL Server to Informix SQL Server + - * / % Informix + - * / MOD Notes Addition Subtraction Multiplication Division Modulo D.2 Variable assignment and declaration operators You can use SQL Server Transact-SQL (T-SQL) on the SQL Server for the assignments of values to a variable. Informix does not provide the functionality to use assignments in SQL batches. However, variable declarations and value