The option to carry over "Save Values Between Session" when defining substitution variables in an editor is no longer available (v6.x) as it was in previous Nav. v5.5.
EXAMPLE:
From an SQL editor window (the Scan Defines button is already depressed to enable substitutions)
DEFINE pick_number1=1152131
DEFINE pick_number2=1152510
DEFINE pick_number3=0
DEFINE pick_number4=0
SELECT a.akey, a.aint, a.asigned, a.afloat, a.adouble, a.adecim, a.adate, a.acode, a.aname, a.aaddress, a.atimestamp
FROM a_hundred a
WHERE a.akey IN(&&pick_number1, &&pick_number2, &&pick_number3, &&pick_number4)
*Press F9 to run the DEFINE SQL, then right-click on the editor window. Select SQL/Script options, then Show Substitutions.
The four DEFINE'd values have now been set.
Next, go to another SQL editor window. Right-click just like above. Click Show Substitutions and see that none are defined in the second window. If a script that contains && type references is run none are defined and are prompted to enter them (again).
In version 5.5, when right-click and display any and all existing defined variables, there was a check box that allowed you to share those variables across all editors and sessions. In 6.1 that option has disappeared. Where is this option now?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center