Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. CREATE FUNCTION FuncTest1 ()
  2. RETURNS TABLE
  3. (
  4. USE_NAME VARCHAR(48),
  5. USE_PARTNER_LINK FLOAT
  6. )
  7. LANGUAGE SQL
  8. MODIFIES SQL DATA
  9. DETERMINISTIC
  10. BEGIN
  11. DECLARE GLOBAL TEMPORARY TABLE USE_TRUNC
  12. (
  13. USE_NAME VARCHAR(48) NULL,
  14. USE_PARTNER_LINK FLOAT NULL
  15. );
  16. INSERT INTO SESSION.USE_TRUNC
  17. (USE_NAME,USE_PARTNER_LINK)
  18. SELECT USE_NAME,USE_PARTNER_LINK FROM F_USERS;
  19. RETURN
  20. SELECT USE_NAME,USE_PARTNER_LINK FROM F_USERS;
  21. END
  22.  
  23. An unexpected token "USE_NAME" was found following "
  24. RETURN
  25. SELECT". Expected tokens may include: "(".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.9.78
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement