My plan was to load a bunch of names from a txt file and then search for entrys in a large table via SQL with this name. I tried to transfer the selected names into a variable with a peek. But the variable only shows the last value of the list of names.
Hope someone can help me out.
(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);
If you expect it to run for each and every value then you need to place the LOAD..SELECT statement inside the LOOP. You may use ADD LOAD so it appends the values from the database table to the same table.