Subject SQL save to ignores database setting From Pieter van Heerden <psvh@mweb.co.za> Date Thu, 19 Apr 2018 04:55:06 -0400 Newsgroups dbase.getting-started I have tried the following code to extract data and to save it to a different table for the sake of saving code lines. set database to sapwat select DISTINCT stationid, wstation, countryid, type from importtemp save to wstemp The SQL statement selects the right table in the database and does the expected extraction, but the result is saved not to the database, but to the working directory.  I have tried the following: set database to sapwat select DISTINCT stationid, wstation, countryid, type from importtemp save to :sapwat:wstemp But the result is still the same, the database statement/indicator is ignored. Is something wrong in the code?  How does one manage this problem?