Steve, Amplifying Dennis's comment. To the best of my knowledge if you don't specify a data type for "RETURN" in the PUT command it defaults to TEXT(8).
Jim --- Dennis McGrath <[EMAIL PROTECTED]> wrote: > Check your stored procedure definition. I'll bet the return > datatype is TEXT (8) > > Dennis McGrath > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Wills, Steve > Sent: Tuesday, February 19, 2008 4:06 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Forget That Crosstab for Now, My > STP_RETURN Is Truncating My Value > > Don't know why, but, as shown below, the values I'm trying to > return via > my Stored Procedure CALL are being truncated. Any ideas? > > Thanks, > Steve in Memphis > > > R>SELECT Proposal_Number,(CALL > CHK_4_AWARD(Proposal_NUMBER))=16 FROM > R_PROPOSAL WHERE PROPOSAL_NUMBER LIKE '0806%' AND > SEQUENCE_NUMBER = > (SELECT MAX(SEQUENCE_NUMBER) FROM R_PROPOSAL r WHERE > r.PROPOSAL_NUMBER=R_PROPOSAL.PROPOSAL_NUMBER) AND LIMIT=10 > Proposal (CALL CHK_4_AWAR > -------- ---------------- > 08061541 010847-0 > 08061542 010847-0 > 08061543 010847-0 > 08061544 010847-0 > 08061545 010847-0 > 08061546 010847-0 > 08061547 010847-0 > 08061548 010830-0 > 08061549 010830-0 > 08061550 010830-0 > Columns have been updated in 1 row(s) in SYS_PROCEDURES > Successful INSERT operation, 1 rows generated. > > R>sho var > Variable = Value > Type > ------------------ ------------------------------ > -------- > #DATE = 02/19/2008 > DATE > #TIME = 16:02:58 > TIME > #PI = 3.14159265358979 > DOUBLE > SQLCODE = 0 > INTEGER > SQLSTATE = HY000 > TEXT > #NOW = 02/19/2008 16:02:58 > DATETIME > STP_RETURN = 010830-0 > TEXT > vMIT_AWARD_NUMBER = 010830-001 > TEXT > viMAN = 0 > INTEGER > > J. Stephen Wills > Program Manager, Research Informatics > Office of the Vice Chancellor for Research > University of Tennessee Health Science Center > 62 S. Dunlap, Suite 400 > Memphis, TN 38163 > Office: 901-448-2389 > FAX : 901-448-7133 > > > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
