CRDSS_Task1_05-7_UseOFEmbeddedSQLInCRDSS

• Title: CRDSS Task 1.05-7 - Study of System Integration Issues Database - Use of Embedded SQL in CRDSS
• Description: This memorandum discusses the related to using ESQL in the CRDSS.
• Decision Support - Doc Type: Task Memorandum
• Date: 5/10/1994
• DSS Category: DMI Utilities
• DSS: Colorado River
• Basin: Colorado Mainstem
• Contract/PO #: C153658, C153727, C153752
• Grant Type: Non-Reimbursable
• Bill Number: SB92-87, HB93-1273, SB94-029, HB95-1155, SB96-153, HB97-008
• Prepared By: Riverside Technology inc.

#include <stdio.h>
$include sqlca;
/*
Several header files are provided with INFORMIX-ESQL/C, all of which
are located in the $INFORMIXDIR/incl directory. The sqlca.h file
contains the structure in which error status codes are stored. This
file is automatically included when a program is preprocessed, to
allow checking success or failure of SQL statements.
*/
$define FNAME_LEN10;
$define LNAME_LEN20;
$define ORG_LEN30;
$define ADDR1_LEN60;
$define ADDR2_LEN60;
$define CITY_LEN20;
$define STATE_LEN2;
$define ZIP_LEN5;
$define EMAIL_LEN30;
$define PHONE_LEN12;
$define FAX_LEN12;
$define MODEM_LEN12;
$define USERTYPE_LEN1;
$define ENTERED_LEN8;
$define UPDATED_LEN8;
main()
{
$char fname[ FNAME_LEN + 1 ];
$char lname[ LNAME_LEN + 1 ];
$char org[ ORG_LEN + 1 ];
$char address1[ ADDR1_LEN + 1 ];
$char address2[ ADDR2_LEN + 1 ];
$char city[ CITY_LEN + 1 ];
$char state[ STATE_LEN + 1 ];
$char zip[ ZIP_LEN + 1 ];
$char email[ EMAIL_LEN + 1 ];
$char phone[ PHONE_LEN + 1 ];
$char fax[ FAX_LEN + 1 ];
$char modem[ MODEM_LEN + 1 ];
$char usertype[ USERTYPE_LEN + 1 ];
$char entered[ ENTERED_LEN + 1 ];
$char updated[ UPDATED_LEN + 1 ];
printf( "CRDSS Sample ESQL program running.\n\n");
4
A275 05.10.94 1.05-7 Malers, Rohlfs