External Stored procedures issue
I have created a stored procedure using shell script and registered/installed the stored procedure in my Vertica database.
Shell script uses linux sqlcmd SQL Server command-line tool to run a SQL server stored procedure and update single table in SQL server.
When I execute the shell script it works fine and I see SQL Server table data updated, but when I call the stored procedure in vsql it runs fine, doesn't generate any error, but the SQL table data is not changed.
Just curious if any of you had the same issue.
Any recommendation is welcome.