ADSM-L

sql display output with wide format

2001-09-28 09:06:57
Subject: sql display output with wide format
From: "Guan, Phillip" <Guan_P AT VDOT.STATE.VA DOT US>
Date: Fri, 28 Sep 2001 08:59:00 -0400
Hi all,

Is there a way to force the SQL select results in wide format output? I need
to put my own column names. If I use '-tab' option, the columns data are
messed up. If I run from a wide enough korn shell window, it displays in
wide format; otherwise, it displays in narrow format. I tried the
SQLDISPLAYMODE but iit doesn't work. I need to put this SQL statement in a
cron job. Any suggestions? Thanks.

Best regards,
Phillip Guan
<Prev in Thread] Current Thread [Next in Thread>