selecting data in shell script

Posted in 2005

mustafa sert — Mon, 27 Jun 2005 13:44:51 — source: IIUG Forums & Mailing Lists

hello all, it may very easy but I couln't find any solution. I want to select data from table in command line or inside the shell script. inserting data in shell script is possible with dbload command and did it but I don't know how select is. is there any way? mustafa sert

↪ replying to mustafa sert

Lavoie, Diane — Mon, 27 Jun 2005 15:04:39 — source: IIUG Forums & Mailing Lists

Hi, You may do it : 1 - cat ${DBADIR}/sql/INFtable.sql | dbaccess sysmaster > ${DBADIR}/log/new_INF_t able1_${INFORMIX_DBID}.log 2- dbaccess sysmaster <<EOF set isolation to dirty read; set lock mode to wait;output to $TEMPFILE1 select tabname,(npused*2) size from sysptprof,sysptnhdr where sysptprof.partnum = sysptnhdr.partnum and (npused*2)>25000000 and tabname not like ('°001235000') order by 2 desc;EOF Best Regards Diane Lavoie -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf Of mustafa sert Sent: Monday, June 27, 2005 9:45 AM To: ids@iiug.org Subject: selecting data in shell script [5264] hello all, it may very easy but I couln't find any solution. I want to select data from table in command line or inside the shell script. inserting data in shell script is possible with dbload command and did it but I don't know how select is. is there any way? mustafa sert

↪ replying to mustafa sert

ART KAGEL, BLOOMBERG/ 731 — Mon, 27 Jun 2005 15:37:29 — source: IIUG Forums & Mailing Lists

You can use the dbaccess UNLOAD verb to export data to a delimited text file, or the OUTPUT verb to output to a formatted file. You can also use dbaccess in commandline mode (dbaccess <databasename> - ) with a 'here script' to send commands to and display results of queries. Another option is to use Jonathan Leffler's sqlcmd package which has various output formatting options, is always in commandline mode, and provides a server mode for handling multiple queries without the overhead of making a new connection to the database and starting a new copy of dbaccess or sqlcmd for each query. Sqlcmd is available from the IIUG Software Repository. Art S. Kagel ----- Original Message ----- From: Mustafa Sert <msert@meteor.gov.tr> At: 6/27 11:27 hello all, it may very easy but I couln't find any solution. I want to select data from table in command line or inside the shell script. inserting data in shell script is possible with dbload command and did it but I don't know how select is. is there any way? mustafa sert

↪ replying to mustafa sert

Obnoxio The Clown — Mon, 27 Jun 2005 21:42:08 — source: IIUG Forums & Mailing Lists

mustafa sert said: > hello all, > it may very easy but I couln't find any solution. > I want to select data from table in command line or inside the shell > script. > inserting data in shell script is possible with dbload command and did > it but I don't know how select is. > is there any way? dbaccess dbname <<!EOF select * from tabname!EOF -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere.

↪ replying to mustafa sert

Support Informix — Tue, 28 Jun 2005 05:44:22 — source: IIUG Forums & Mailing Lists

example, with thanks to Art Kagel : capture in variable : tblist() { db=$1 std_err=/dev/null dbaccess $db - 2>${std_err} <<%% | sed -e '/^$/d' output to pipe "cat" without headings select unique tabname from systables where partnum != 0 and tabtype = "T" order by 1;%% do TBLIST=`tblist $DB` for TBL in $TBLIST do ... done or capture in unloaded file and then awk the file : dbaccess $DB - <<eof >>err$$ 2>>err$$ unload to /tmp/unl1$$select d.dbsname ... etc eof cat /tmp/unl1$$ | awk ... -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: 27 June 2005 15:45 To: ids@iiug.org Subject: selecting data in shell script [5264] hello all, it may very easy but I couln't find any solution. I want to select data from table in command line or inside the shell script. inserting data in shell script is possible with dbload command and did it but I don't know how select is. is there any way? mustafa sert ------_=_NextPart_001_01C57BA4.273B0700 Content-Type: text/html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>RE: selecting data in shell script [5264] </TITLE> </HEAD> <BODY> example, with thanks to Art Kagel : capture in variable : tblist() {   db=$1   std_err=/dev/null   dbaccess $db - 2>${std_err} <<%% | sed -e '/^$/d'   output to pipe "cat" without headings   select unique tabname from systables   where  partnum != 0       and tabtype = "T"   order by 1; %% do     TBLIST=`tblist $DB`     for TBL in $TBLIST       do          ...       done or capture in unloaded file and then awk the file :        dbaccess $DB - <<eof >>err$$ 2>>err$$          unload to /tmp/unl1$$          select d.dbsname ... etc        eof        cat /tmp/unl1$$ | awk ... -----Original Message----- From: nobody@ace.iiug.org [<A HREF="mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>] Sent: 27 June 2005 15:45 To: ids@iiug.org Subject: selecting data in shell script [5264] hello all, it may very easy but I couln't find any solution. I want to select data from table in command line or inside the shell script. inserting data in shell script is possible with dbload command and did it but I don't know how select is. is there any way? mustafa sert </BODY> </HTML> ------_=_NextPart_001_01C57BA4.273B0700--