Hi, i am running ASE 15.0 free developer version

i have a file with these sentences:

---------
print 'Preparing pass procedures'
go

read ./sy/passCtrl/structure/ctrl/fnDatePeriods.sql
go
---------

then, i use these sentece to call that file:

---------
isql -Ufr -Pfactorepo -SFACTOREPO < ./sy/passCtrl/initialize/preparePassProcedures.sql
---------

but i am getting this error

---------
Preparing pass procedures
Msg 156, Level 15, State 2:
Server 'JMIGUEL77DESKTOP', Line 2:
Incorrect syntax near the keyword 'read'.
---------

The file was tested against sqlAnywhere and it worked

thanks

I get the same error.Will check it out and let you know.

Msg 156, Level 15, State 2:
Server 'TEST_SYBASE15', Line 1:
Incorrect syntax near the keyword 'read'.

Looks like it is something to do with the syntax. will see !

I don't think we can use 'READ' here in Sybase ASE isql.

READ is an Interactive SQL command.This command is intended only for Interactive SQL and are not sent to Adaptive Server for execution The database engine has no idea of the READ command, so we get the error "Incorrect syntax near the keyword 'read'.

Hope this helps a bit !

ok, so, what if i want to execute a .sql file from another .sql call ??

is there any command to execute a file with sentences from inside isql ??

thanks

Did you try using Interactive SQL on your PC and execute this?
Never tried in isql command line

thats not the problem
i want to create a task for buliding an entire database schema and i want to call other .sql files from one callable point