dbTalk Databases Forums  

Dynamic execution of an .sql file

comp.databases comp.databases


Discuss Dynamic execution of an .sql file in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
vimal
 
Posts: n/a

Default Dynamic execution of an .sql file - 07-19-2004 , 03:38 AM






Hi Everybody..
I'd like to execute a .sql file from my PowerBuilder application.
pick up the location of the file from the .ini file and then construc
a string variable containing the same. Eg 'C:\Scripts\scr.sql'. Now
need to run this on a Sybase database. I do so by the following--Rea
'C:\Scripts\scr.sql';
When I carry on this operation from the PowerBuilder code..usin
Execute Immediate :<var_name>; I get an SQL error. The error # i
SQLSTATE=37000 Syntax error or Access violation.

Can you please suggest as to how do I run a .sql file from the PB fro
end tool.

Thanks a zillion
Vima
-
vima
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message313190.htm


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.