Appendix A Executing Methods As Stored Procedures

Using MASP from isql

Using the MASP interface, you can use isql to quickly test methods. For example, the following command invokes the getMajors method in the SVUEnrollment component in the SVU package:

1> exec SVU.SVUEnrollment.getMajors
2> go
                     
 --- ----------------
 Eng English         
 Phy Physics         
 Ant Anthropology    
            
           0

If you are using isql with a multi-byte character set, you should specify that character set using the isql -J option. For example, the following command sets the isql codeset to the sjis codeset.

isql -Usa -P -Sjaguar -Jsjis

Because Jaguar does not support languages, the isql -z option is not valid nor can you set the client machine's LANG environment variable to a language other than US English.

This section applies to any client that sends a MASP request as a Transact-SQL command.