Setting table count to variable in shell script..?

Question

I'm looking to return a numeric value within the "count" variable from my SQL I wrote. Unfortunately I am just getting an Ingres error message. Any ideas what I am doing wrong?

See shell script code below:

#!/bin/ksh
###############

count=$(sql db_name -s -N "SELECT COUNT(*) FROM temp_table;")

echo "Table count = $count"

See Ingres error below:

Table count = INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation 
E_US0022 Either the flag format or one of the flags is incorrect,
    or the parameters are not in proper order.

Expected outcome:

Table count = 8

If you are using the Korn shell, use the ksh tag, not the bash tag. Regardless, this isn't a shell issue; there's a problem with your SQL command. — chepner
– chepner, Commented Feb 16, 2017 at 17:41
Have you tried executing sql db_name -s -N "SELECT COUNT(*) FROM temp_table;" to see what the output is outside your script? — Fred
– Fred, Commented Feb 16, 2017 at 17:44

User9102d82 · Accepted Answer · 2017-02-16 20:22:38Z

1

Try this:

=>|Fri Feb 17|01:51:01|postgres@[STATION]:/var/lib/pgsql> ./test.sh
count ------- 3 (1 row)

=>|Fri Feb 17|01:51:04|postgres@[STATION]:/var/lib/pgsql> cat test.sh
#!/bin/bash

count=$(psql <<EOF
select count(*) from mdn_2 ;
EOF
)
# Prints the result captured from DB
echo $count

=>|Fri Feb 17|01:51:05|postgres@[STATION]:/var/lib/pgsql>

answered Feb 16, 2017 at 20:22

User9102d82

1,1901 gold badge10 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

TCP Over a year ago

Result is now: "INGRES TERMINAL MONITOR Copyright 2008 Ingres Corporation Ingres SPARC SOLARIS Version II 9.2.1 login Thu Apr 20 11:30:40 2017 continue Executing . . . +-------------+ |col1 | +-------------+ | 8| +-------------+ (1 row) Your SQL statement(s) have been committed. Ingres Version II 9.2.1 logout Thu Apr 20 11:30:40 2017" Any idea's how I can just return "8"?

User9102d82 Over a year ago

Possible for you to share the screenshot here? I can then check and respond.

G Jones · Accepted Answer · 2017-02-17 08:12:18Z

1

-N isn't a valid flag for the Ingres terminal monitor (sql command). You probaby want something like this (in bash):

count=`echo "select count(*) from iitables;\g" | sql -S iidbdb`

For more info on the flags accepted, see the documentation: http://docs.actian.com/#page/Ing_CommandRef%2FCommandRef_Body.1.235.htm%23

answered Feb 17, 2017 at 8:12

G Jones

3671 silver badge6 bronze badges

Collectives™ on Stack Overflow

Setting table count to variable in shell script..?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related