I am writing a multithreaded program using C Embedded SQL for Sybase. Each thread will have a dedicated connection to Sybase and i can be sure the connection name must be unique. I don't use sqlda, i use descriptor in method 4 to execute select with unknown item list and unknown selection criterion. The sqlca is limited to file scope, i use

static
EXEC SQL INCLUDE sqlca;

I think it is already thread safe, can anyone give me some advice on this?