Search code examples
sybasesap-iqisql

Run script with create table on sybase-iq

I want to create table from a script on sybase-iq. Script table.sql contains:

create table abc
(
 id int
)
go

I run the script command

isql -U*** -P*** -S*** -D*** -itable.sql  -oout.txt

I'm sure connection parameters are ok. Name of script is correct too.

But It doesn't work, script did not create the table and I have not any errors in output file.

Thanks in advance for your advice.

PX

Solution

  • I found it!

    The script was generated by isql with option -o and it was Macintosh format! I have seen it in np++. I have changed format to DOS\Windows and it's work!

    A problem was with EOL. I had char(13) (Mac), but correct is char(13)+char(10) (DOS).

    Thanks for your answers!