Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do:
C+ Where TkPart01 = :odPart(01)
C+ and TkQty01 = :odQty(01)
C+ and TkPart02 = :odPart(02)
C+ and TkQty02 = :odQty(02)
There's more to it than that but that should give you the general idea. The message I get is that the variable is either not defined or not usable.
Yes, I've read the manual and it says that you can't use a multi-dimension array, which implies that you can use a one-dimension array.