UNIX bteq sql output

Tools
c19
Enthusiast

UNIX bteq sql output

Hi,

I'm wondering how to echo the output of a select statement in bteq.

I am able to put the output to a file but not the screen.

Here is my script

#!/bin/ksh

DIR="/userhome/isc/SMI_PROCESSES_2/complaints/ksh/parallel_run"

bteq &1

Any help would be appreciated.

Thanks
1 REPLY
c19
Enthusiast

Re: UNIX bteq sql output

Guys,

To display the output directly to a unix shell just use

bteq < pathtosqlfile.sql

So my next question is, how to just display the result set rather than all of the bteq messages?

Thanks