trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Qifan Chen <qifan.c...@esgyn.com>
Subject Re: In sqlci: how to show column names and associated data types?
Date Thu, 07 Apr 2016 19:04:04 GMT
Any SQL actions from within sqlci can be logged via the log command.

log <logfile> clear;  -- start logging into <logfile>.  Clear any content
in <logfile> first.

showddl <t>;

log;  --stop logging

--Qifan

On Thu, Apr 7, 2016 at 1:56 PM, Selva Govindarajan <
selva.govindarajan@esgyn.com> wrote:

> You can either issue
>
> invoke trafodion.<schema_name>.tablename or
> showddl trafodion.<schema_name>.tablename
>
> Showddl output is such that it can be used to re-create the table when
> needed.
>
> Selva
>
> On Thu, Apr 7, 2016 at 11:52 AM, Pierre Smits <pierre.smits@gmail.com>
> wrote:
>
> > Hi all,
> >
> > Maybe this is question answered in the documentation/pages already, but I
> > might be overlooking it: how do I, in sqlci, get the information of a
> table
> > (meaning the column names, their data types and such) in a
> > TRAFODION.SCHEMA?
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > ORRTIZ.COM <http://www.orrtiz.com>
> > OFBiz based solutions & services
> >
> > OFBiz Extensions Marketplace
> > http://oem.ofbizci.net/oci-2/
> >
>
>
>
> --
> - cheers
> selvag
>



-- 
Regards, --Qifan

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message