Hitachi Vantara Pentaho Community Forums
Results 1 to 10 of 10

Thread: Netezza-- hw to find no of table in db

  1. #1
    Join Date
    Nov 2007
    Posts
    1

    Exclamation Netezza-- hw to find no of table in db

    Hi all,

    I am pretty new to using Netezza
    Can somebody PL REPLY how to know the no of tables in the database

    EX: 'SELECT * FROM TAB' we use in the ORACLE..
    Wt is the query for the same stmnt in netezza??

    pl rep
    suma

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    No idea... this is also not a Netezza dedicated forum, you're probably better off looking for a real Netezza forum.

    Regards,
    Sven

  3. #3
    Join Date
    Nov 2007
    Posts
    1

  4. #4
    Join Date
    Dec 2007
    Posts
    1

    Default u have to query the system view _v_table

    Hi Suma

    use the below mentioned query to count the number of user created tables excluding the "external tables".

    select count(tablename) from _v_table where objtype = 'table' ;

    ~Kaushik

  5. #5

    Default Netezza related forums

    Hi Everyone-

    I am looking for netezza forums also checked with the url : http://www.netezza.com/netezzaforum/index.php but it is not opening. Can somebody advice me if there is some netezza forum. Help highly appreciated.

    I need 2 information in netezza, if someone found please feel free to post your ideas and knowledge.

    1. How to create a data base in netezza using password option:
    For example, I want to create a data base using create database <dbname> with password option.


    2. I want to load any type of text files (delimitted or fixed width) into netezza table.

    I am using nzload utitlity to load data from file to netezza table, in that there is a option -delim "delimitted_string". Is there any way to load fixed width file format using this utility.

    All experts comments are welcome.

    Thanks in Advance.


    Saravanan Rajavel

  6. #6
    Join Date
    May 2006
    Posts
    4,882

    Default

    And yet their 404 page is a very friendly one: http://www.netezzacommunity.com/index.jspa

    Regards,
    Sven

  7. #7

    Default

    Thanks a lot sven!

    I am trying to find how to post a thread in that community!

  8. #8

    Default

    Hi Sven-

    I am trying to post a thread in that forum which you mentioned earlier, but it seems like we need a special permission.

    When I am trying to post a new thread it's saying that "Unauthorized" even though I logged in.

    Thanks in advance.

    Saravanan Rajavel

  9. #9
    Join Date
    May 2006
    Posts
    4,882

    Default

    okaay... I doubt a lot of people on the Pentaho's forums use Netezza, a couple probably (else it would not be in) but not a lot. So you may need to wait some time if you want/expect an answer here.

    Regards,
    Sven

  10. #10
    Join Date
    Jan 2010
    Posts
    1

    Default netezza forum

    there is a dedicated netezza forum - http://netezzaforum.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.