Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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>>