September 14th, 2009
Host Programs, C#
Posted by
admin in
S. Host Programs
Syntax Element In C# prefix EXEC SQL terminator ; target label
Variable Definition Syntax
C# variable definition =
[auto | extern | static] [const | volatile]
C numeric variable | C character variable
| C derived variable;
C# numeric variable =
{long | short | int | decimal | double}
{variable name [initial value] }.,..
C# character variable =
char [CHARACTER SET [IS] character set name]
{variable name {length} [initial value] }.,..
C# derived variable =
{ VARCHAR [CHARACTER SET [IS] character set name]
{variable name {length} [= character representation... ] }.,..} |
{ BIT{variable name {length} [= character representation... ] }.,..}
The length is the fixed length or the maximum varying length of the string, and the character representation sequence is an optional initial value.
SQL Type C# Type BIGINT long BIT bool CHAR string DATE byte[] DECIMAL decimal FLOAT double INTEGER int SMALLINT short TIME byte[] TIMESTAMP byte[] TINYINT byte VARCHAR string SQLCODE long SQLSTATE char 6 indicator short or long
Comments Off