do you mean pass prompt values through to a sql script ?
if so, it's just a case of providing a variable name in the prompt definition and reference that variable within the sql script i.e if the variable name is prompt, then reference &prompt within the script to get the value
if it's a text value you'll more than likely need to specify a quote char ' on the prompt definition
------------------------------
Cheers
Pat
------------------------------
Original Message:
Sent: 06-23-2020 11:41 AM
From: Alvin Lee
Subject: Applications Manager 9.3
Hi,
Looking for a way to prompt a sql script in AM 9.3. Does anyone know how to do this?
Thanks,
Alvin