Hi,
According to the nlserver manual it should be possible to execute sql with nlserver sql.
What is the proper syntax for doing this in a linux environment (build 9356)?
What I have tried so far, without success:
nlserver sql -instance:instance_name "SELECT iworkflowid FROM xtkworkflow WHERE sinternalname = 'workflowname'"
I have also tried putting the query in a file, without success:
nlserver sql instance:instance_name -file:"/usr/local/neolane/query.sql"
Thanks in advance
Solved! Go to Solution.
Views
Replies
Total Likes
Hello @LukasPe1,
The nlserver sql can be used to execute sql object from adobe campaign. Bellow an exemple :
I've created a sql object in the console to insert a row in a table :
i can execute this script using nlserver sql as bellow :
result the row is inserted in my table :
You can also use nlserver sql to execute sql code stored in a file on the server.
I've created a file with sql code to delete previously creates row :
i can execute it as bellow :
result the row is deleted from my table :
Br,
Hello @LukasPe1,
The nlserver sql can be used to execute sql object from adobe campaign. Bellow an exemple :
I've created a sql object in the console to insert a row in a table :
i can execute this script using nlserver sql as bellow :
result the row is inserted in my table :
You can also use nlserver sql to execute sql code stored in a file on the server.
I've created a file with sql code to delete previously creates row :
i can execute it as bellow :
result the row is deleted from my table :
Br,
@Amine_Abedour Thanks for the thorough explanation! Do you know if it is possible to make a SELECT query directly in the terminal on the server, with the nlserver command, so that I can save the result into a variable?
Views
Replies
Total Likes