Arcane bits (was Re: piping scripts into isql revisited)

Path: emory!swrinde!zaphod.mps.ohio-state.edu!cis.ohio-state.edu!banana.cis.ohio-state.edu!ackley From: ackley@banana.cis.ohio-state.edu (john james ackley) Newsgroups: comp.databases.informix Keywords: FAQ features arcane Message-ID: <1992Jan16.120825.24238@cis.ohio-state.edu> Date: 16 Jan 92 12:08:25 GMT References: <1600@das13.snide.com> <1992Jan14.201257.14449@cpqhou.uucp> <1992Jan15.201722.10567@anasaz> Sender: news@cis.ohio-state.edu (NETnews ) Organization: The Ohio State University, Department of Computer and Information Science In article <1992Jan15.201722.10567@anasaz> briand@anasaz (Brian Douglass) writes: >In article <1992Jan14.201257.14449@cpqhou.uucp> thomasr@cpqhou.UUCP (Thomas Rush) writes: > >Or, > isql - - >>! > > database whatever; > > select * from foo;> >! > >And it runs. The ! gets set as the end of extended input character. Watch out! It may have run, but you have a new file named "!". You want "<<" for the here-document operator. BTW, by using "<<", (at least in the ksh), all your sql commands are saved in your history, to be edited and/or re-run again without the need to type them. Wouldn't it be nice to have command editing and history in an sql interpreter? My thanks to those who shed the light on this operating mode, it has already paid for itself in the last 25 hours. I only wish I would have known about 4 years ago. Also, someone suggested a faq of little known/undocumented features: good idea! The folks at Snide seem to have discovered a few things, particularly the 'last key struck' thing. I know a few things about the datetime doo-hickey. And Walt has been watching the mailing list forever, so he might have a tidbit or two. Regards, John Ackley <ackley@cis.ohio-state.edu> // Disclaimers Anonymous >-- >Brian Douglass briand%anasaz.UUCP@asuvax.eas.asu.edu > 602-870-3330 X657