|
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 mailing list archive is Copyright 1997-2025 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.