Informix SQL Question

Informix SQL Question

Informix SQL does not allow the use of LIKE in global variables in stored procedures. Pretty obviously, using the LIKE keyword to make sure that variables are of the same type and dimensions as you are going to be reading from a table is a darn good idea. That way, if some bright person changes a field definition in one place, everyone who is using LIKE follows along from there, and we are all in agreement.

I can't imagine any good reason why Informix SQL doesn't allow LIKE in global variables. Does anyone have a clever workaround? (I mean, besides not using global variables? Evil as they are, there's no easy alternative for what I am doing. SQL is so twentieth century!)