Hi All :
Could anyone tell me what is the file number shown with DBTOOL utility. I tried to query _file (_File-Number). For example :
Current max fieldLen for tr_hist (696) :
Fld# SQLWidth Max Width ERROR NAME
---- --------- --------- ------ ------
2: 30 29 ** tr_part
3: Date 0 tr_date
The _file shows _File-Number as 127 for tr_hist where as DBTOOL uses 696.
I wanted to write a script to do a SQL Width adjustment to only a handful of files.
Any help is greatly appreciated.
Regards,
Ramamurthy Dasari
Could anyone tell me what is the file number shown with DBTOOL utility. I tried to query _file (_File-Number). For example :
Current max fieldLen for tr_hist (696) :
Fld# SQLWidth Max Width ERROR NAME
---- --------- --------- ------ ------
2: 30 29 ** tr_part
3: Date 0 tr_date
The _file shows _File-Number as 127 for tr_hist where as DBTOOL uses 696.
I wanted to write a script to do a SQL Width adjustment to only a handful of files.
Any help is greatly appreciated.
Regards,
Ramamurthy Dasari