select command using BTEQ is not returning all fields

[alexcol]

Good morning:

i need your help: i've got 2 questions:

the first one is:
i use bteq to connect to Teradata and i want to select the first 5 records of a table but returned just 2 columns.

select top 5 * from DWH_LOG.procesos where nom_proceso = 'wedo_sqntbalanceexpire';

*** Query completed. One row found. 8 columns returned.
*** Total elapsed time was 1 second.

Num_proceso Nom_proceso
----------- ---------------------------------------------------------------
119 wedo_sqntbalanceexpire

BTEQ -- Enter your DBC/SQL request or BTEQ command:


but the table has 8 colums as you can see below:

Column Name Type Comment
------------------------------ ---- ---------------------------------------
Num_proceso I ?
Nom_proceso CV ?
Fec_proceso TS ?
Periodicidad CV ?
Prefijo_planos CV ?
Tiempo_Estimado I ?
FecUltimoCorteDatos TS ?
Status CV ?

what can i do to return all columns in the query?

2nd - is there any command to show me which databases and tables a database user has access and what kind of permissions. i.e select - insert permissions?

id appreciate your help, thanks

[ray.wurlod]

I suspect (the metadata in) your job design only names two columns.

[alexcol]

thanks for your help

But where can i check out this and can i changed withotut any problem? if so how can i chage it

the 2nd quetion is if is there any command that let me know which tables a desired user has access and what type select,insert.etc.

id appreciate your help

[ray.wurlod]

Look on the Columns tab. How many columns are mentioned there?

[kduke]

I think Teradata can limit the number of fields in select * from table. Talk to your DBA.