Somebody once told me that qptool uses the database driver to collect its data, and as such can be used to "translate" Baan SQL into Oracle SQL.

Well, SOMEbodies email is no longer deliverable....(MIKE!!!!!).

Does anybody have any idea what somebody was talking about, or was somebody smoking dope at the time?

In Baan's 103533 solution, I noticed they mention a TRACE option but they don't elaborate on that.

qptool(6.x) is another client to the Baan system like the bshell is another. You can put a query into qptool and that will generate the output. Like in the bshell you can set up the same logging and tracing variables with TT_SQL_TRACE / DBSLOG / BDB_DEBUG / BLAT (and BAAN_ART_TRACE).$ qptool6.1 -u
Usage : qptool6.1 script_with_query
or : qptool6.1 [options]
options: -c compnr
-q query
-a actions
p: parse query
e: execute query
f<nr>: fetch <nr> rows from query, '*' is all rows
b: break query
c: close query
t: commit
a: abort
d<nr>: set rds_full to <nr>
s: save retry point
r: retry query
m: get sql error message
n<nr>: set default company number to <nr>
o<nr>: set query timeout to <nr>
Default actions 'pef*bc'
-p parse mode
-f script_with_queries
Format: [ '@'<actions> ] <query> [ ';' [ '@'<actions> ] <query> ... ]
-r load references
-o output file for query result
-b size of rds full
-t set global query timeout

Amazing how little I know of the client options. I really should dig into that some time.

Anyway, I found the options there that give me the information I was looking for, but I still want to explore the qptool path because it will allow me to build it into a script (or maybe even a session).

So I got two questions.

Do I set the TRACE options as an environment variable?

BWclient trace information is written to the bshell. Does the trace info from qptool go to standard error like the rest of it?

Check out this thread! (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=6783)

This should answer how to set the environment setting.

Where the logfile will be send to and what will be logged, there is only one answer to that: see for yourself... I don't know.