While using ISQL in linux for POSTGRES, I am able to make a connection to the database and execute select/update/insert/delete statements on tables.

But I am unable to execute create/drop/grant statements. I am getting error as below,

1.CREATE

SQL> create table shop (item1 integer);
[S1000]ERROR: syntax error at or near "create" at character 29;
Error while executing the query
[ISQL]ERROR: Could not SQLExecute
SQL> create table shop (item1 int);
[S1000]ERROR: syntax error at or near "create" at character 29;
Error while executing the query
[ISQL]ERROR: Could not SQLExecute
2.DROP

SQL> drop table persons2;
[S1000]ERROR: syntax error at or near "drop" at character 29;
Error while executing the query
[ISQL]ERROR: Could not SQLExecute
3.SELECT

SQL> select * from persons2;

| personid | pname
+------------+----------------------------------------------------------
------------+
| 1 | test1
| 2 | test2
| 3 | test3
| 4 | test4
SQLRowCount returns 4
4 rows fetched
Grant does not work as well. Is this a permission issue? Please find my permissions below

SQL> SELECT rolname, rolsuper, rolcreaterole FROM pg_roles WHERE rolname
= 'me';
+-----------+---------+--------------+
| rolname | rolsuper| rolcreaterole|
+-----------+---------+--------------+
| me | 1 | 0 |
+-----------+---------+--------------+
Also I am unable to find any documents for ISQL to check how to find the roles, permissions of a user etc.

I am able to execute all the above statements using PSQL in linux though.

psqltest=# create table shop(item1 int);

CREATE TABLE

Does it work with the native tool `psql`?
https://www.postgresql.org/docs/current/app-psql.html

Edit: now I see it does work. What's the point in using a middleware?

I am using RM/COBOL InstantSql to access postgreSql. InstantSQL is an interface that allows access to ODBC drivers using a COBOL-like set of statements

> I am using RM/COBOL InstantSql to access postgreSql.

In the first post you used isql from unixODBC. Maybe they aren't the same. Anyways, I tried unixODBC-2.3.7 with Oracle-10.2 on Aix, it sort of worked:
Mind you, `commit` didn't work.

The issue occured when I connect to isql using my userid and password.
$isql dbname userid (with password it does not let me connect at all thought it is the correct password)
SQL> create table test4 (id int);
[ISQL]ERROR: Could not SQLExecute
SQL> quit


But when I connect to just with the dbname I could create table,
$ isql dbname
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> create table test4 (id int);
SQLRowCount returns 0

If you are using isql, maybe this page will help https://manpages.ubuntu.com/manpages...n1/isql.1.html. ?

It sounds to me as if you haven't setup the ini file correctly/at all.
It may also be that your 'username' hasn't been given enough rights to create etc.
Ask your DBA.

@OP please clearly state what platform(s) and software(s) are you using, e.g.:

"I am using Power64 platform, IBM AIX 6.1 OS, Oracle Instant Client 12.1.0.2.0, client program is sqlplus."


Also please explain why you want to use isql instead of the native command line tool.