Re: dbaccess & length of statements

From: RSmith@iiug.iiug.org (R Smith) > >You should be able to develope whatever query you desire in >dbaccess. I don't know what you mean by cutting off the statement >at 80 characters. Granted, the 'editor' in dbaccess is lacking, >but you can use the editor of your choice. In dbaccess, choose 'Q'uery, >then 'U'se-editor, you will then be prompted for your editor of choice, >type in vi (if you have the environment variable DBEDIT=vi, it will >throw you into vi automatically). I tried a really long create table all on one line, and even though the editor cut it off in the display, it still created the table fine... > >I am rather new to informix and I have a question I feel very silly to > >ask, but anyway since I don't have much time here it goes: > > > >I am trying to create Tables with dbaccess. Right now I haven't found a > >way to type in more than 80 charactes per statement. The SQL generator > >just cuts the line. I want to use SQL and not the tool since I am just > >developing and somebody else is going to implement the real system. So I > >figuered out it would be the best to create a setup. > > > >I read the newsgroup, but all I could find was a hint to another tool, > >that's helpfull for my developing environment, but does not really solve > >my problem.... > > > >I hope I can give any help back to this group soon.... (As soon as I am > >getting more known to informix....) > > > >Frank > > > > > > > >-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- >http://www.newsfeeds.com - The #1 Newsgroup Service in the World! >-----== Over 80,000 Newsgroups - 16 Different Servers! =----- ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com