Hey Chris,
When executing SQL commands that involve variable declarations and multiple statements within MATLAB using the Database Toolbox, the commands should be combined into a single batch execution. This can be achieved using a single exec command with the entire SQL script. But Here's how the SQL command can be structured and executed:
% Establish the database connection
conn = databaseConnect;
% Combine the SQL statements into a single batch
sqlQuery = [
'DECLARE @g geography; ' ...
'SET @g = geography::Point(47.65100, -122.34900, 4326); ' ...
'SELECT @g.ToString();'
];
% Execute the combined SQL command
log = exec(conn, sqlQuery);
% Fetch and display the results
results = fetch(log);
disp(results.Data);
% Close the connection
close(conn);
Executing SQL commands that involve variable declarations across separate exec calls in MATLAB will not work as expected. This is because each exec call is treated as a separate transaction, and any variables declared in one transaction are not recognized in subsequent transactions.
Note that, The exec function is not recommended now. For SQL statements that return data, use the fetch function or the select function instead. For other SQL statements, use the execute function instead.
Refer to below documentation for more clarity:
Hope this helps!
Thanks
