Re: dbaccess & length of statements

--- Frank Wehrle <frank.wehrle@mediaaktiv.de> > wrote: >..... >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. Most folks don't try to write everything on one line. Try chopping things up like this. Select field1, field2, field3, .... etc. From table, table Where condition and condition What you are seeing is the detestable Informix editor not working well with the TERM you have defined. It's not really worth trying to get the two to cooperate since any lines longer than 80 chars will scroll the beginning of the line off the screen anyway (if I remember correctly). The above is much more readable and easier to modify/debug. >I want to use SQL and not the tool By 'the tool' I assume you are making reference to dbaccess? Did you know that you can use dbaccess from the commandline without going into the menus? Is that what you'd prefer? You can also use Jonathan Leffler's sqlcmd utility. > 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'm not really sure you explained your problem well enough aside from the 80 char limitation. >I hope I can give any help back to this group soon.... (As soon as I am >getting more known to informix....) Until then, some of us are accepting cash gifts. Or livestock. == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net

Carlos Benjamin wrote: > > --- Frank Wehrle <frank.wehrle@mediaaktiv.de> > > wrote: >[SNIP] > >I hope I can give any help back to this group soon.... (As soon as I am > >getting more known to informix....) > > Until then, some of us are accepting cash gifts. Or livestock. Live livestock, please, my lawn is getting long. Oh, and no chickens! Art S. Kagel