dbaccess & length of statements

Hi everyone 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

frank.wehrle@mediaaktiv.de (Frank Wehrle) wrote in <397820AA.C475D476@mediaaktiv.de>: Frank, 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). Does this help? >Hi everyone > >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! =-----

In dbAccess, you should be able to edit the SQL statement in any editor. Usually on UNIX it is vi and on NT it is notepad. Check the menu for "Editor" As far as using other tools is concerned, how does it affect your developement effort. After all, the final goal is to send queries to the DB and it should not matter if you use DBAccess or any other tool "Frank Wehrle" <frank.wehrle@mediaaktiv.de> wrote in message news:397820AA.C475D476@mediaaktiv.de... > Hi everyone > > 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 >

-- Frank Wehrle <frank.wehrle@mediaaktiv.de> wrote in message news:397820AA.C475D476@mediaaktiv.de... > Hi everyone > > 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. > \\ Just hit a return when you approach the end of the line. Most people type in their code in logical lines: select this, that, other from tables where ... so they don't get close to the end of the line. SQL is space independant, so you can write like: select this , that, the other from tables and get away with it. Also remember, you can use the "Use-editor" menu option if you're a vi (or other editor) expert and want to use it. > 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 >

> Thanks to you all... I couldn't solve the problem though. DBaccess still cuts at 80 characters, Using an editor doesn't help at all. I wrote a java Application, that does all statements on the database with jdbc and that works. Frank