Working with SQL on Informix 5.02

Posted in 1999

Kho Irani — Wed, 10 Nov 1999 15:56:34 -0600 — source: Informix-list mailing list archive (1991-1998)

I'm trying to extract data from an Informix 5.02 database using sql scripts and I don't know how to execute the scripts. I found the SQL engine which is named SQLEXEC and attempted to execute the SQL scripts I generated by typing: sqlexec <filename> But the program seems to lock up and never returns. If anyone has any information on this older version of informix, I would greatly appreciate it Regards Kho Irani

↪ replying to Kho Irani

Art S. Kagel — Wed, 10 Nov 1999 17:09:03 -0500 — source: Informix-list mailing list archive (1991-1998)

The SQLEXEC process is the user's engine process it is not an interactive process. It will be started automatically by any Informix front-end tasks. The interactive SQL editor/processor is dbaccess. Just type dbaccess and it will start up its menus where you can select a database to connect to then enter your SQL or select a .sql file to load in and execute and many other things like a menu driven table creation utility. If you prefer a commandline you can use: dbaccess dabasename sql_script_name -OR- dbaccess database_name - <sql_script_name To run a script or just dbaccess database_name - to get an SQL prompt (> ) you can type SQL on. Art S. Kagel Kho Irani wrote: > > I'm trying to extract data from an Informix 5.02 database using sql scripts > and I don't know how to execute the scripts. > > I found the SQL engine which is named SQLEXEC and attempted to execute the > SQL scripts I generated by typing: > > sqlexec <filename> > > But the program seems to lock up and never returns. > > If anyone has any information on this older version of informix, I would > greatly appreciate it > > Regards > > Kho Irani

↪ replying to Kho Irani

Mehdi / QueriX — Thu, 11 Nov 1999 10:29:23 +0000 — source: Informix-list mailing list archive (1991-1998)

Kho Irani wrote: > I'm trying to extract data from an Informix 5.02 database using sql scripts > and I don't know how to execute the scripts. > > I found the SQL engine which is named SQLEXEC and attempted to execute the > SQL scripts I generated by typing: > > sqlexec <filename> > > But the program seems to lock up and never returns. > > If anyone has any information on this older version of informix, I would > greatly appreciate it > > Regards > > Kho Irani Try any of the following dbaccess <database_name> <file_name.sql> isql <database_name> <file_name.sql> -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible. Some features are: True Windows GUI Clients. ActiveX support. HTML Report Generation. More rigorous error handling. Connection to other RDBMS such as Oracle. Connection to all versions of Informix 4GL with no need to change compiler. For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------