I am running sybase ASE db in a docker container for local development and testing purpose, I am able to successfully run the container and I can see that server is up and running and databases are created. Now I wrote a small sql script to test if the server and databases are up or not before running the test and I am running script inside the sybase container using isql. However I see that when executing the script with isql there is no output but if I execute the commands manually via isql it gives the output properly.
2> exit
[root@dib10-XTYH8OK2 /]# /opt/sybase/OCS-16_0/bin/isql -U sa -P myPassword -S MYSYBASE -i sybase_test.sql
[root@dib10-XTYH8OK2 /]#
Executing via script gives no output
drwxrwxrwt 1 root root 4096 May 2 11:14 tmp
[root@dib10-XTYH8OK2 /]# /opt/sybase/OCS-16_0/bin/isql -U sa -P myPassword -S MYSYBASE
1> use configDB
2> select getDate()
3> go
-------------------------------
May 2 2024 11:16AM
(1 row affected)
Executing comamnds manually via isql gives correct output
Below is the script
use configDB
SELECT getdate()
go
~