EXEC(sqlstatement) Resultset usage

From: whornak (whornak_at_discussions.microsoft.com)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 10:01:01 -0800

How do I, from within the same stored procedure, use the result of a sql
statement after executing it using the EXEC() command?

Relevant Pages

  • Re: COBOL stored procedure for DB2
    ... Regarding how you precompile the app, you must specify target mfcob to db2 prep, rather than target ibmcob. ... Have you also confirmed that, prior to executing the CALL statement, the host variables specified within the client app have the appropriate values? ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: COBOL stored procedure for DB2
    ... Have you also confirmed that, prior to executing the CALL statement, the ... The DB2 CREATE PROCEDURE statement. ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)
  • Re: need your helpppp
    ... Also it works fine if I use command "p1.cgi" in unix shell. ... them get printed in <html> section of try.cgi. ... It seems to me that the first thing is to figure out why the exec fails. ... There are differences between executing a Perl script from the command line and executing it as a CGI script, which include the setting of the PATH variable, and the accessability of files in general. ...
    (comp.lang.perl.modules)
  • Re: How to Log errors while executing ingres sql command
    ... The sql UNIX command sends E_ errors to channel 1. ... While executing ingres 'sql' command, all the errors that raises gets ... I am executing this comand through shell script. ...
    (comp.databases.ingres)
  • Re: SQL Parameterized Command versus Custom String
    ... I would use the EXEC String ... command object is trying to execute so you can test it against SQL ... SQL Profiler? ...
    (microsoft.public.dotnet.languages.csharp)
Loading