▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 shell-Can you use Shell to query, modify, delete, etc. SQL?
pinterest.com/UnderCodeOfficial

🦑 𝕃𝔼𝕋𝕊 𝕊𝕋𝔸ℝ𝕋 :

#! / Usr / bin / ksh
SQL_EXEC ()
{
sqlplus the USER $ / $ @ $ DB the PASSWD <<!
SET LINESIZE 1024
SET pageSize 1024
$ SQLCOMM
quit
!
}

#select
SQLCOMM = "SELECT 'XXX', username from the all_users;"

SQL_EXEC | grep XXX

#insert, Delete omitted

with INformIX yo prompts what to do if sql_exec cannot be found.

I think this should work,
#vi query.sh
sqlplus $ USER / $ PASSWD << EOF
select …… from …………
insert ………………
delete ………………
EOF
: wq
# query.sh

isql <<!
database dbname;
select * from tbname where fieldname="xxxxx";
delete from tbname;
.....
close database;
!

Written by Underc0de
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁

🦑 shell-Can SHELL be used to query, modify, delete, etc. SQL

! # / Usr / bin / ksh
SQL_EXEC ()
{
sqlplus the USER $ / $ @ $ DB the PASSWD <<!
SET LINESIZE 1024
SET pageSize 1024
$ SQLCOMM
quit
!
}

#select
SQLCOMM = "SELECT 'XXX', username from the all_users;"

SQL_EXEC | grep XXX

#insert, Delete omitted

with What should I do if I cannot find sql_exec in INformIX?

I think this should work,
#vi query.sh
sqlplus $ USER / $ PASSWD << EOF
select …… from …………
insert ………………
delete ………………
EOF
: wq
# query.sh

isql <<!
database dbname;
select * from tbname where fieldname="xxxxx";
delete from tbname;
.....
close database;
!
written by undercode
▁ ▂ ▄ ｕ𝕟𝔻Ⓔ𝐫Ć𝔬𝓓ⓔ ▄ ▂ ▁