Hi!

Does anyone experienced using VARCHAR variable on the WHERE condition of the Pro*C SQL Statement running on HP-UX 11?

I have a program that needs to retrieve a record from my informix table, I successfully compiled the program but when I run the program, the program just hang on the preparation of SQL statement.

I tried to use int variable as bind variable on the sql statement.
The program did work.

I'm using this environment:

Platform - HP-UX 11
Database - Oracle 7.3.4 linked to Informix
Language - Pro*C

......
EXEC SQL BEGIN DECLARE SECTION
VARCHAR gvvc_subm_T_airline_cd[8];
VARCHAR gvvc_subm_D_airline_cd[8];
VARCHAR gvvc_subm_D_rec_type[3];
VARCHAR gvvc_subm_D_sch_arrv_dt[9];
EXEC SQL END DECLARE SECTION;

void process_details(int option){

EXEC SQL AT DHL_DB DECLARE INI_SUBM_5312 CURSOR FOR
SELECT "record_type", "airline_cd", "sch_arrival_date"
FROM ini_subm_d_5312
WHERE "airline_cd" = :gvvc_subm_T_airline_cd;
EXEC SQL AT DHL_DB OPEN INI_SUBM_5312;
EXEC SQL AT DHL_DB FETCH INI_SUBM_5312
INTO :gvvc_subm_D_airline_cd[8], :gvvc_subm_D_rec_type[3], :gvvc_subm_D_sch_arrv_dt[9];

.....

}

Hope anyone could help me with this error.
Thanks.

Rachele