Sample 31096: How to Extract SYBASE Stored Procedures Using PROC SQL
 |  |  |  |  |
This sample provides a simple way of extracting SYBASE stored procedures using PROC SQL. The code below:
- connects to a SYBASE databse on a UNIX server
- extracts all of the information in SYSCOMMENTS (SYBASE stores procedures here)
- stores the procedures in a SAS variable named TEXT
- stores the variable TEXT in a SAS table named ONE
- disconnects from the SYSBASE database
NOTE: In retrieving all of the information stored in SYSCOMMENTS, you might find any or all of the following to be true:
- unexpected or unwanted information
- that the expected information has been deleted
- that the user may not have administrative access/end user permission to access SYSCOMMENTS
Therefore, you may have to confirm access to the information and may have to do additional programming to ensure that the results are totally inclusive of what is wanted and mutally exclusive of what is not wanted.
About the Author
Bryan K. Beverly is a Software Architect and Team Leader with BAE Systems Information Technology. He has been using SAS for 20+ years and is currently supporting SAS-based systems at the Bureau of Labor Statistics. Bryan has served as a presenter and volunteer at SAS conferences for more than 10 years.
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
proc sql;
connect to sybase(user=USER NAME
password=PASSWORD
server=UNIX SERVER NAME
database=DATABASE NAME
);
reset noprint;
create table one as
select * from connection to sybase
(select text = convert(char(255) not null, text)
from syscomments);
disconnect from sybase;
quit;
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
| Type: | Sample |
| Topic: | SAS Reference ==> Procedures ==> SQL Data Management ==> Data Sources ==> External Databases ==> Sybase |
| Date Modified: | 2008-02-04 13:19:15 |
| Date Created: | 2008-02-04 12:52:38 |
Operating System and Release Information
| Product Family | Product | Host | SAS Release | |
| Starting | Ending | |||
| SAS System | Base SAS | z/OS | ||
| OpenVMS VAX | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | ||||
| Microsoft Windows XP 64-bit Edition | ||||
| Microsoft® Windows® for x64 | ||||
| OS/2 | ||||
| Microsoft Windows 95/98 | ||||
| Microsoft Windows 2000 Advanced Server | ||||
| Microsoft Windows 2000 Datacenter Server | ||||
| Microsoft Windows 2000 Server | ||||
| Microsoft Windows 2000 Professional | ||||
| Microsoft Windows NT Workstation | ||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||
| Microsoft Windows Server 2003 Standard Edition | ||||
| Microsoft Windows XP Professional | ||||
| Windows Millennium Edition (Me) | ||||
| Windows Vista | ||||
| 64-bit Enabled AIX | ||||
| 64-bit Enabled HP-UX | ||||
| 64-bit Enabled Solaris | ||||
| ABI+ for Intel Architecture | ||||
| AIX | ||||
| HP-UX | ||||
| HP-UX IPF | ||||
| IRIX | ||||
| Linux | ||||
| Linux on Itanium | ||||
| OpenVMS Alpha | ||||
| OpenVMS on HP Integrity | ||||
| Solaris | ||||
| Solaris for x64 | ||||
| Tru64 UNIX | ||||