Thanks victor_cleto and patvdv.

I have another question

Output of qptool the record has a text qualifier ' (single quote)
Is there any property setting that can be set to change the qualifier
' to some other character. As the character ' is used in descriptions
..etc We have difficulty in importing the output into excel or converting to another format using custom programs.


'010 ' '010A ' 813 ' ' '060 ' 'Consignment (owned) Warehouse ' 1 25 975

I think that it is the default behaviour of qptool6.1. there have been some changes, but there is no option to allow you to specify the character field separator :(
Maybe it's time to ask for it in an enhancement request :D
I think most people just uses qptool as a test since it is very limited (single queries only). If you are using Oracle or other DB other than Triton, I'll go for sql scripts, not qptool.