<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Book Antiqua";
panose-1:2 4 6 2 5 3 5 3 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.style11
{font-family:"Book Antiqua";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1094284628;
mso-list-type:hybrid;
mso-list-template-ids:-1383839970 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:1509832920;
mso-list-template-ids:-535257820;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi, all. I’m new to hibernate, and I’m
having a hard time finding examples on how to define a mapping for a stored
procedure. I’m mainly confused on the “call” portion.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=teal
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:teal'><</span></font><font size=2 color="#3f7f7f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#3F7F7F'>sql-query </span></font><font
size=2 color="#7f007f" face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";color:#7F007F'>name</span></font><font size=2
color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>=</span></font><font size=2 color="#2a00ff" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#2A00FF'>"GETFUNDINGTYPES"
</span></font><font size=2 color="#7f007f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#7F007F'>callable</span></font><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black'>=</span></font><font size=2 color="#2a00ff"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#2A00FF'>"true"</span></font><font size=2 color=teal
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:teal'>></span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'> </span></font><font
size=2 color=teal face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:teal'><</span></font><font size=2 color="#3f7f7f"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#3F7F7F'>return </span></font><font size=2 color="#7f007f"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#7F007F'>alias</span></font><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>= </span></font><font
size=2 color="#2a00ff" face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";color:#2A00FF'>"getFundingTypes" </span></font><font
size=2 color="#7f007f" face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";color:#7F007F'>class</span></font><font size=2
color=black face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>=</span></font><font size=2 color="#2a00ff" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#2A00FF'>"FundingType"</span></font><font
size=2 color=teal face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:teal'>></span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>
</span></font><font size=2
color=teal face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:teal'><</span></font><font size=2 color="#3f7f7f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#3F7F7F'>return-property
</span></font><font size=2 color="#7f007f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#7F007F'>name</span></font><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black'>=</span></font><font size=2 color="#2a00ff"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#2A00FF'>"code" </span></font><font size=2 color="#7f007f"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#7F007F'>column</span></font><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>=</span></font><font
size=2 color="#2a00ff" face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";color:#2A00FF'>"CODE"</span></font><font
size=2 color=teal face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:teal'>/></span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>
</span></font><font size=2
color=teal face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:teal'><</span></font><font size=2 color="#3f7f7f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#3F7F7F'>return-property
</span></font><font size=2 color="#7f007f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#7F007F'>name</span></font><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black'>=</span></font><font size=2 color="#2a00ff"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#2A00FF'>"description" </span></font><font size=2
color="#7f007f" face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:#7F007F'>column</span></font><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>=</span></font><font size=2 color="#2a00ff" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#2A00FF'>"DESCRIPTION"</span></font><font
size=2 color=teal face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:teal'>/></span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'>
</span></font><font size=2
color=teal face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:teal'><</span></font><font size=2 color="#3f7f7f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#3F7F7F'>return-property
</span></font><font size=2 color="#7f007f" face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:#7F007F'>name</span></font><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:black'>=</span></font><font size=2 color="#2a00ff"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#2A00FF'>"createTS" </span></font><font size=2 color="#7f007f"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#7F007F'>column</span></font><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:black'>=</span></font><font
size=2 color="#2a00ff" face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";color:#2A00FF'>"CREATE_TS"</span></font><font
size=2 color=teal face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:teal'>/></span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'> </span></font><font
size=2 color=teal face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New";color:teal'></</span></font><font size=2 color="#3f7f7f"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#3F7F7F'>return</span></font><font size=2 color=teal face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:teal'>></span></font><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:black'> <span
style='background:yellow'>{? = call GETFUNDINGTYPES ()}</span></span></font><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=teal face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New";color:teal'></</span></font><font
size=2 color="#3f7f7f" face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New";color:#3F7F7F'>sql-query</span></font><font size=2
color=teal face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:teal'>></span></font><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>It may sound silly, but I need to understand the relevance
of the “?” ‘s. I’m returning all the columns in the
table, so I’ve listed all three as return properties. (CODE, DESCRIPTION,
CREATE_TS)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='mso-list:l0 level1 lfo3'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>What goes in the method call
parens? Is it the number of input/output that the DB2 stored
procedure has defined? Or is it the number of return properties, ie
GETFUNDINGTYPES(?,?,?); one ‘?’ for each return property
listed. Or do I leave it empty as I have done above since I’ve
already listed the return properties?<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-list:l0 level1 lfo3'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>What does the ‘?’
to the left of the ‘=’ mean? Is it the number of actual
results? If that is true, then is it always one ‘?’ to
signify one result set? <o:p></o:p></span></font></li>
</ol>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Any help that anyone can provide is greatly appreciated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thank you,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Paula<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
Private and confidential as detailed <a
href="http://www.sug.com/disclaimers/default.htm#Mail">here</a>. If you cannot access hyperlink, please e-mail sender.
</body>
</html>