When I am firing the below 2 query,I am getting the same output as abc_stg,test_mdl,123_srci for databasename columns
But when I replace Dbc.diskspacev with dbc.diskspace the output is blank.
I am trying to fetch the same output using dbc.diskspace
Also can anyone pleqse explain why we have three different type of view for most dbc objects like(dbc.diskspace,dbc.diskspacev,dbc.diskspacevx)is there any difference ?which one should be considered?
Where there are both, the views with "V" are the ones everyone should be using - since TD12. The ones without V are only for backward compatibility.
Currently, object names are Unicode VARCHAR. Previously they were Latin CHAR(30) so LIKE with the compatibility view requires trailing spaces or % to match.