nlserver sql syntax

Question

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

Amine_Abedour · Accepted Answer

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,

Sign up

Login with SSO

Login to the community

Login with SSO