| View previous topic :: View next topic |
| Author |
Message |
joergensen
Beginner
Joined: 05 Nov 2003
Posts: 9
Topics: 7
|
 Posted: Fri Jan 28, 2011 2:59 am Post subject: z/os db2 v9r1 UDF |
 |
|
hello
I have som problems with this create function and the manuals
lack of gpod examples:
| Code: |
CREATE FUNCTION TEST.JR40151F
( INP1 SMALLINT
,INP2 INTEGER
)
RETURNS INTEGER
LANGUAGE SQL
SPECIFIC TEST.JR40151F
NOT DETERMINISTIC
READS SQL DATA
RETURN (
SELECT
COUNT(*)
FROM
TEST.JR40000T GRU
,TEST.JR40100T BYG
WHERE
GRU.VUR_AAR = 9999
AND GRU.KOMMUNENUMMER = INP1
AND GRU.EJENDOMSNR = INP2
AND GRU.OBJTYPE = 1
AND BYG.FK_GRUND_ID = GRU.GRUND_ID
AND BYG.OBJTYPE = 1
AND BYG.BYG_ANVEND_KODE < 910 );
---------+---------+---------+---------+---------+---------+---------+---------+
DSNT408I SQLCODE = -214, ERROR: AN EXPRESSION IN THE FOLLOWING POSITION, OR
STARTING WITH 0 IN THE RETURN CLAUSE IS NOT VALID. REASON CODE = 6
DSNT418I SQLSTATE = 42822 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOP1 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -140 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF74' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
|
kind regards joergensen |
|
| Back to top |
|
 |
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Fri Jan 28, 2011 7:41 am Post subject: |
|
|
why don't you start with the description of the -214 sqlcode ?
or see what datatype COUNT returns?
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
joergensen
Beginner
Joined: 05 Nov 2003
Posts: 9
Topics: 7
|
| Posted: Sun Jan 30, 2011 8:47 am Post subject: |
|
|
count returns integer and the sqlcode=-214 is something about full-select, but difficult to understand
kind regards Ib |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Mon Jan 31, 2011 4:24 am Post subject: |
|
|
count returns a large integer (BIGINT).
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
