rajbptl
28th July 2008, 11:30
I am an end user and i want to execute a file.sql which is having an sql query
I want to execute it to get an .lst report when ever i need
Can any one help me in getting the steps to execute it.

kbabu1
28th July 2008, 14:17
you can use 'qptool6.2' on unix command line to execute a query in the file and also you can take the out put in to a file.

see qptool6.2 help for more information (qptool6.2 /?)

rajbptl
29th July 2008, 13:01
I could not able find the utility qptool6.2 in my UNIX box , Please let me know if
there is another way or else where can i find the qptool6.2 (path)

bilmaa
30th July 2008, 16:35
qptool is a server utility not a client utility, only can run in baan server in the bin directory.

NPRao
30th July 2008, 22:30
I am an end user and i want to execute a file.sql which is having an sql query
I want to execute it to get an .lst report when ever i need
Can any one help me in getting the steps to execute it.
As an end user, you have to justify why do you need the SQL? From a security perspective, one has to know if & why you are accessing sensitive or confidential information, which is not provided by a Baan session or report. You cannot execute your SQL without knowing your database login and password information. You have to work with your IT/Development team.