Given the Teradata documentation (Teradata Preprocessor2 for embedded SQL Programmer guide, Release 14.10), to insert array of data the EXEC SQL statement is modified to: EXEC SQL FOR (<countval) <sql statement string> where countval is a user defined integer variable or literal integer constant that must be less than or equal to the smallest defined dimension in the list of arrays An example is provided to illustrate the case: EXEC SQL BEGIN DECLARE SECTION; char empname; long empnum; float empsal; long cNewEmployees = 50; EXEC SQL END DECLARE SECTION; EXEC SQL PREPARE exInsert01 FROM insert into employee values (?, ?, ?); EXEC SQL FOR cNewE example? mployees EXECUTE exInsert01 USING :empname, :empnum, :empsal; This example for array insert in embedded sql with C language is not working. Only the first element in each array is inserted. Is there something missed or special options to set at the C compiler to run this example.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.