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?
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center