how to execute batch command in SQL assistant?

Tools & Utilities
Enthusiast

how to execute batch command in SQL assistant?

hello fellow members, I need your help..

is it possible to execute a batch command via SQL assistant?  example 

.COMPILE FILE 'C:\Users\vince.gabrielli\Desktop\Mensa_livraison\Usp\USP_MNS_CRR_BASE.sql';commit;

it works well with BTEQ, however I have several programmers and do not want to install BTEQ on their laptops.

there must be a method that works on SQL assistant version13.10

Tags (1)
1 REPLY
Enthusiast

Re: how to execute batch command in SQL assistant?

It is a good idea. However, I 've never encountered or I dont think it is possible.

First execute an OS command then call the DML/DDL/DCL/TCL then outside it finally calling TCL.

It may be CPU intensive.Please share your ideas if you find a solution for this. 

Cheers,