Results 1 to 5 of 5

Thread: SQL0440N error

  1. #1
    Join Date
    Aug 2010
    Posts
    17

    Unanswered: SQL0440N error

    Hi All,

    I have following error when I try to get data from syscat.tablespaces. However everything works fine when I have similar SQL to get get from syscat.tables. Any idea on this issue? I also check the privilage of syscat.tables and syscat.tablespaces. They are the same.

    Thanks,

    Mike
    ----------------------------- Commands Entered ------------------------------
    Select 'list tablespace containers for ' || tbspaceid || ' show details;'
    from syscat.tablespaces
    where tbspace like 'SGIRA%'
    ;
    ------------------------------------------------------------------------------
    Select 'list tablespace containers for ' || tbspaceid || ' show details;' from syscat.tablespaces where tbspace like 'SSS%'
    SQL0440N No authorized routine named "||" of type "FUNCTION" having
    compatible arguments was found. SQLSTATE=42884

    SQL0440N No authorized routine named "||" of type "FUNCTION " having compatible arguments was found.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Concatenation only works on character data.

  3. #3
    Join Date
    Aug 2010
    Posts
    17
    How can I list the container of all tablespaces. I can only find the following command to list, but it can show the container for individual tablespace. Is there any way I can get the container of all tablespaces?

    list tablespace containers for # show details

    Thanks a lot!

    Mike

  4. #4
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963

    Lightbulb

    Quote Originally Posted by mail4mz View Post
    How can I list the container of all tablespaces. I can only find the following command to list, but it can show the container for individual tablespace. Is there any way I can get the container of all tablespaces?

    list tablespace containers for # show details

    Thanks a lot!

    Mike
    n_i gave you a point.
    You have to change:

    Code:
    Select 'list tablespace containers for ' || CHAR(tbspaceid) || ' show details;'
    from syscat.tablespaces
    where tbspace like 'SGIRA%'
    ;

  5. #5
    Join Date
    Aug 2010
    Posts
    17
    Got it. Thx a lot!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •