× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



SQL Gurus,
   
  I did create a User Defined Function to call the LowerAdjust Prototype.
   
  I can update the FirstName by set FirstNme = LowerAdjust(FirstNme), shown 
below on Line 40.
   
  I need assistance,  to set a Returning value from a prototype to a host 
variable, as shown below in Line 35.
                                                             
                  C/exec sql                                             
0035.00      C+ set :Test3 =  LOWERADJUST(TEST3)                   
0036.00      C/end-exec                                             
0037.00                                                             
0038.00      C/exec sql                                             
0039.00      C+ Update TESTLIB/EMPLOYEE                             
0040.00      C+ set FirstNme = LOWERADJUST(FIRSTNME) with NC       
0041.00      C/end-exec                                             
0042.00   
   
  Compile Fails.
                                                  DIAGNOSTIC MESSAGES           
    
 MSG ID  SEV  RECORD  TEXT                                                      
 SQL0104  30      35  Position 35 Token TEST3 was not valid. Valid tokens: :.   
 .                

  Your hlep is greatly appreciated.
   
  
 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.