Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    34

    Question Unanswered: output of a query

    Hi All,
    I executed the below query

    select field_name,value from sysmonitors where group_name='resource_stats'
    and i get the following out put

    field_name value
    ------------------------------------------------------------------------------- --------
    0
    0
    0
    0
    0
    0
    0
    0
    0
    7
    7
    0
    0
    29593
    0
    0
    0
    0
    1
    1
    0
    0
    0
    0
    0
    0
    0
    0
    1
    1
    0
    0
    0
    0
    0
    0
    0
    0

    I dono y i didnt get the field_name and i can get only values can any one explain this.....pls


    Thanx n advance

    Arun

  2. #2
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Weird. First thing to check is that your client s/w is not doing something funny (try executing the posted code from isql). Second thing is check that you do NOT have a view called sysmonitors. Third is check that you are on a supported and patched (ESD release) version of ASE.

    Cheers
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •