Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 11 Dec 2001 @ 16:03:20 GMT

  <Prev Next>  
Next> Last>>  

Subj:   ODBC SQLColumns() for view returns no rows
From:   Mark Landry

Can anyone explain the following behavior? After creating a view on a table in another database, the view metadata returns no rows.

For example,

create view my_work_db.v as select * from dbc.users

produces the following results from ODBC Test:


    In:    StatementHandle = 0x008218E0, CatalogName = SQL_NULL_HANDLE,
          NameLength1 = 0, SchemaName = "my_work_db", NameLength2 = 10, TableName = "v",
          NameLength3 = 1, ColumnName = SQL_NULL_HANDLE, NameLength4 = 0
    Return: SQL_SUCCESS=0

Get Data All:

0 rows fetched from 15 columns.

Yet creating a view on a table in the same database produces metadata results.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020