From the client to upload a. SQL file to headquarters, want to call the WEBSERVICE SQLCMD to carry out the. SQL file suffix,

CodePudding user response:

Webservice is PB you write? You can adopt the way of PB dynamic execution of SQL to execute the file, through the file before you perform function. SQL file read string variable,

CodePudding user response:

I think that, in the client to generate a. SQL file (larger), compression and send to the server, then the server SQLCMD to execute the SQL files, so efficiency of execution should be higher than read out the document to perform,

CodePudding user response:

If is the script execution want to use the database function to perform. SQL file, different database schema is not the same, I only know that oracle is performed using up sqlplus executable program,