ESQL/C: why 2 short ints for indicator variables?

Jonathan Leffler writes: > First of all, you are responsible for allocating pointers to the sqlind > stuff; ESQL/C doesn't assign anything there. Therefore, you are > responsible for freeing it, if you used allocated memory. You might not > have done for indicator variables. I tend to use pointers to 2 short > integers, one containing 0, t'other -1. Why exactly are you using pointers to 2 short integers? Having read the documentation I understand the sole purpose of indicator variable is to indicate whether the value of the given field is null. Why, then do you need 2 short ints isn't one enough? Pawel Pietrusinski Centralny Instytut Ochrony Pracy Warsaw, Poland