Hi, I complied the following "C" embedde SQL statement but all the data that the SQL server returned are blank padded to the size of my variable. I tried using "DECL_VARCHAR" but the esql precompiler didn't like it. EXEC SQL DECLARESEL_SYS_CONFIG_CUR CURSOR FOR SELECTparam_name, param_value FROMSYS_CONFIG; EXEC SQL BEGIN DECLARE SECTION; charcParName[80]= ""; charcParValue[512]= ""; EXEC SQL END DECLARE SECTION; any idea how not to get the blank padding ? thanks Eli
doesn't varchar exist in this context ? EXEC SQL BEGIN DECLARE SECTION; varchar cParName[80] = ""; varchar cParValue[512] = ""; EXEC SQL END DECLARE SECTION;