Guest_imported
New member
- Jan 1, 1970
- 0
I am writing an AIX script (not an SP) to gather fields from two different tables & present them on screen,
to allow a user to select which one(s) are to be updated.
I thought I could use a temporary table, but having got the initial combination :-
Number Name City Update
---------- ----------- ---------- -------
1 Maltby Detriot N
2 Osgood New York N
3 Thomas Toronto N into #x_temp,
when I leave SQL so that 1, 2, and/or 3 can be entered,
and “Update” subsequently amended from “N” to “Y”,
I find that #x_temp’s contents are lost !
I could probably output #x_temp’s contents to a temporary
AIX file, and use ‘cut’ to preserve the fields for a later
SQL “insert” command, but this seems very cumbersome.
Is there a way to get the user’s input without quitting from SQL, or am I attempting the impossible ?
Any suggestions would be gratefully received.
to allow a user to select which one(s) are to be updated.
I thought I could use a temporary table, but having got the initial combination :-
Number Name City Update
---------- ----------- ---------- -------
1 Maltby Detriot N
2 Osgood New York N
3 Thomas Toronto N into #x_temp,
when I leave SQL so that 1, 2, and/or 3 can be entered,
and “Update” subsequently amended from “N” to “Y”,
I find that #x_temp’s contents are lost !
I could probably output #x_temp’s contents to a temporary
AIX file, and use ‘cut’ to preserve the fields for a later
SQL “insert” command, but this seems very cumbersome.
Is there a way to get the user’s input without quitting from SQL, or am I attempting the impossible ?
Any suggestions would be gratefully received.