All Forums Database
rupert160 131 posts Joined 09/10
29 Aug 2015
Submitting Procedures using BTEQ

It seems the only way to submit a Stored Procedure using BTEQ is to execute the compile command, as I've had heaps of trouble trying to

pump "Create Procedure..." straight into bteq.


To create an SQL stored procedure:

"invoke a text editor to create a file named example.spl, and enter the SQL stored procedure

....Submit the COMPILE command with this file name."


Does anybody know why it is that BTEQ unable to execute the PROC directly and needs to run "COMPILE"?

The GUI's seem able to but BTEQ does not. I realise it is CLIv2 rather than odbc, but I thought this would be more versitile not less...

Adeel Chaudhry 773 posts Joined 04/08
30 Aug 2015

I would assume it can be due to the different nature of BTEQ and SPL.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.