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 < [email protected]> 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 <[email protected]> > 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
