SQL SPs 
Author Message
 SQL SPs
Hello,

Is there a way to write to an operating system file from an SQL Stored
Procedure?  UDB EEE 7.2, Sun/Solaris.

Thanks,

/Tomas



Tue, 17 Aug 2004 04:57:07 GMT
 SQL SPs

Thomas,

By definition, SQL stored procedures contain SQL statements - and these
have DB calls, not OS calls.

Of course, you don't HAVE to make it a SQL stored procedure... you could
write it in C/C++, Java, COBOL or other supported language...

Quote:

> Hello,

> Is there a way to write to an operating system file from an SQL Stored
> Procedure?  UDB EEE 7.2, Sun/Solaris.

> Thanks,

> /Tomas

--
====================================
To reply, delete the 'x' from my email

Jerry Stuckle
JDS Computer Training Corp.

====================================



Tue, 17 Aug 2004 07:00:44 GMT
 SQL SPs
Hi Tomas,

There is no predefined procedure or function to do this.
However a simple C Function or Procedure should do the job.
(write once, use everywhere, .. publish as a technote and get paid by DB2
Developer Domain :-)

Cheers
Serge

--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada



Tue, 17 Aug 2004 06:54:51 GMT
 SQL SPs
Thanks for the info, guys!

/T

Quote:

> Hi Tomas,

> There is no predefined procedure or function to do this.
> However a simple C Function or Procedure should do the job.
> (write once, use everywhere, .. publish as a technote and get paid by DB2
> Developer Domain :-)

> Cheers
> Serge



Wed, 18 Aug 2004 03:04:11 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Using SQL SPs to drive Access Reports

2. VB6 ADO and SQL SPs

3. VFP5.0a and SQL SPs

4. SPs queryng Views vs. SPs querying Joined Tables

5. SPs queryng Views vs. SPs querying Joined Tables

6. SPs queryng Views vs. SPs querying Joined Tables

7. Nested transactions via SPs calling SPs

8. Calling SPs from within SPs

9. PB6, MS SQL 6.5, SPs with Text arguments

10. sql client software and sps

11. SQL-DMO bug in enumerating SPs?

12. Debugging SQL server SPs


 
Powered by phpBB® Forum Software