Netezza 是否具有 ODBC DESCRIBE 函数? [英] Does Netezza have an ODBC DESCRIBE function?

问题描述

我想描述一个保存在 Netezza 上的表(这样可以查看变量格式、distribute on 子句等).我知道这是可能的(本机)使用

I would like to DESCRIBE a table held on Netezza (so can see the variable formats, distribute on clause etc). I know this is possible (natively) using

d <tablename>

但是我使用 SAS 进行连接(通过 ODBC).

However I am using SAS to connect (via ODBC).

这可能使用 SAS 9.1.3 代码吗?

Is this possible using SAS 9.1.3 code?

推荐答案

您需要访问包含表信息的系统视图.您不能在一个查询中执行此操作，但您可以使用两个查询.

You would need to access the system views that hold the information about the tables. You can't do this in one query, but you can do it with two.

SELECT  attname "Attribute", 
        datatype "Type", 
        CASE WHEN attnotnull='t' THEN 
            'Not Null' 
        ELSE 
            'Null' 
        END "Modifier",
        coldefault "Default"
FROM _v_relation_column col_t
    cross join _v_datatype dat_t
WHERE dat_t.objid = col_t.atttypid
    AND name='<table_name>'
ORDER BY attnum
;

SELECT attname  "Distributed on hash"
FROM _v_table_dist_map
    INNER JOIN tb_nm t ON tname = tablename
WHERE tablename ='<table_name>'
;

这篇关于Netezza 是否具有 ODBC DESCRIBE 函数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！