Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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:

SQLColumns:

    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:

"TABLE_QUALIFIER", "TABLE_OWNER", "TABLE_NAME", "COLUMN_NAME", "DATA_TYPE", "TYPE_NAME", "PRECISION", "LENGTH", "SCALE", "RADIX",
"NULLABLE", "REMARKS", "LABEL", "FORMAT", "CHAR_TYPE"
0 rows fetched from 15 columns.

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



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