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