A period datatype is a datatype with two values that represent the start and end of a duration of time. For details, see Period Datatypes. The next example shows using a period datatype with DELETE WITH DESCRIPTOR.
#define NUMVARS 1 struct { SQLInt32 Date1; SQLInt32 Date2; }PeriodDate; PeriodDate.Date1 = 1050213; /*February 13th, 2005*/ PeriodDate.Date2 = 1060213; /*February 13th, 2006*/ SQLDA.SqlDABC = (16 + (44 * NUMVARS)); /*data area byte count*/ SQLDA.SqlN = NUMVARS; /*Number of variables*/ SQLDA.SqlD = NUMVARS; /*Number of variables*/ SQLDA.SqlVAR[0].SqlTYPE = 832; /*Datatype for PERIOD(DATE)*/ SQLDA.SqlVAR[0].SqlLEN = 8*256; /*variable length*/ SQLDA.SqlVAR[0].SqlDATA = (char *) (&PeriodDate); /*variable address*/ SQLDA.SqlVAR[0].SqlIND = 0; /*not using indicator*/ VARCHAR SQL_STATEMENT[36]; strcpy (SQL_STATEMENT.arr, "DELETE FROM tab01 where PeriodD = ?"); SQL_STATEMENT.len = strlen (SQL_STATEMENT.arr); EXEC SQL PREPARE DELSTMT FROM :SQL_STATEMENT; EXEC SQL EXECUTE DELSTMT USING DESCRIPTOR SQLDA; ...