iSQL error and won't run under Ubuntu 16.0.4

[former_SQLA_member1694877]

Hello,

I am running an Ubuntu 16.0.4 host for a SQL Anywhere v17 server. I am trying to run iSQL but failing. Here are the two commands:

ubuntu@ip-172-26-8-253:~/SQL Anywhere Scripts$ source /opt/sqlanywhere17/bin64/sa_config.sh ubuntu@ip-172-26-8-253:~/SQL Anywhere Scripts$ dbisql -c "UID=dba;PWD=<passwd>;SERVER=<servername>;DBN=<dbname>"

Here is the error:

The DISPLAY environment variable is not set. It must be set for Interactive SQL to operate correctly.

What am I doing wrong here?

Thank you.

[MarkCulp · Accepted solution]

Dbisql is a GUI application and needs to use your xwindow display. As the error message states, you need to set the DISPLAY environment variable in the shell before you run dbisql.

[former_SQLA_member1694877 · Accepted solution]

Sound of hand slapping forehead! Thanks Mark.