1. Forum
  3. JAVA / TAFJ Discussions
  5. TAFJ Installation / Developments
  7. COUNT command always returns 0 results in DBTools

COUNT command always returns 0 results in DBTools

  • malai
  • malai's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
8 years 3 days ago #20739 by malai
COUNT command always returns 0 results in DBTools was created by malai
Hi,

I am running R15 TAFJ on Windows with H2 database.

When I issue the COUNT JQL command it always returns 0 records

>JQL
>COUNT V_FBNK_SECTOR

It returns '0 Records Counted'

But when I do with SQL it returns 47 records

>SQL
>SELECT COUNT(*) FROM V_FBNK_SECTOR

It returns COUNT(*) 47

Why the JQL command always returns 0. Is there something wrong?

Please Log in or Create an account to join the conversation.

  • Valleyman1
  • Visitor
  • Visitor
8 years 2 days ago #20748 by Valleyman1
Replied by Valleyman1 on topic COUNT command always returns 0 results in DBTools
Please try in the format below:

sh DBTools -s JQL count FBNK.SECTOR

Please Log in or Create an account to join the conversation.

  • malai
  • malai's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
7 years 11 months ago #20779 by malai
Replied by malai on topic COUNT command always returns 0 results in DBTools
It works great.

In JQL it works for FBNK.SECTOR

Please Log in or Create an account to join the conversation.

  1. Forum
  3. JAVA / TAFJ Discussions
  5. TAFJ Installation / Developments
  7. COUNT command always returns 0 results in DBTools
Time to create page: 0.076 seconds