Re: dbaccess

June Tong wrote: > > Steve Leung wrote: > > > > dbaccess seems to be processing the input when it gets > > the EOF mark. > > > > is there a way to make it process each line immediately > > after the EOL mark? > > Maybe I don't understand what you're asking for, but if > you're using DB-Access interactively > > $ dbaccess stores7 -> > it processes each line when it encounters a ";" and <CR>. > It does not wait for an EOF. > > If you're using it with the menu interface, then it processes > when you hit <ESC> and then "Run". If steve is using the command line interface to dbaccess or reading an SQL file from the command line it will seem to not process until the EOF mark. This is an artifact of dbaccess, it does not ordinarily echo its inputs and if the '-e' flag is included it unfortunately echos each command after processing the next SQL statement so if the script or 'here script' only has 2 statements it will still seem to process after reading EOF. Try putting the semi-colon on a line by itself following the SQL it completes. This sometimes works to echo the command before executing it. Art S. Kagel