This is EXACTLY what I need to do in AE v10, but it isn't working.
In a pre-process of a UNIX job I'm calling a sql variable:
:SET &HND1#=PREP_PROCESS_VAR(VARA.SEC_SQL.TXP_OWNER.DATA_STATUS.1)
This fails with the following message:
Status FAULT_OTHER - Start impossible. Other error.
Return code 0
Last message U0052002 Object 'SELECT' with type 'CONN' does not exist in client '00005'.