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 are closed.

Sorry, the comment form is closed at this time.