Again - thanks Elvis
When I saw what your response was to my problem, I thought, well DUH, of
course
anyway, I tried your suggestion and the response I got was,
Conversion error on assignment to column AVAIL.
When I F1'ed it
Message ID . . . . . . : SQL0406 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Message . . . . : Conversion error on assignment to column AVAIL.
Cause . . . . . : During an attempt to assign a value to column AVAIL
with
an INSERT, UPDATE, ALTER TABLE, or REFRESH TABLE statement, conversion
error
type 6 occurred. If precompiling, the error occurred when converting a
numeric constant to the same attributes as column AVAIL. A list of the
error
types follows:
-- Error type 1 is overflow.
-- Error type 2 is floating point overflow.
-- Error type 3 is floating point underflow.
-- Error type 4 is a floating point conversion error.
-- Error type 5 is not an exact result.
-- Error type 6 is numeric data that is not valid.
-- Error type 7 is DBCS data that is not valid.
Which makes some sense, when you think back to the results of my first
attempt, when I received ++++++++++
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxxxxx
P:(631) 244-2000 ext. 5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
"Elvis Budimlic"
<ebudimlic@center
fieldtechnology.c To
om> "'Midrange Systems Technical
Sent by: Discussion'"
midrange-l-bounce <midrange-l@xxxxxxxxxxxx>
s@xxxxxxxxxxxx cc
Subject
09/29/2008 01:11 RE: Creating an SQL function
PM
Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>
Try adding a column alias to the function call, i.e.:
CREATE TABLE tempTable AS
(SELECT SUFFIX, SKUNO, AVAILQTY(SUFFIX, SKUNO) AS AVAILQTY
FROM ITEMMSTR
WHERE SUFFIX = '0011' AND SKUNO = '000070')
WITH DATA
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
Subject: RE: Creating an SQL function
Thanks for your reply Elvis
I tried what you suggested, but the only thing I got was
Column list required.
with the cursor on AVAILQTY
Alan Shore
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l..
midrange.com
