“black belt” LIST command under Jbase

Posted by

SQL: select left(value_date,6), count(*) from security_transfer where broker_no = ‘595701’and transaction_type like ‘F%’ and value_date like ‘2010%’ group by left(value_date,6)

JBASE translation>LIST FBNK.SECURITY.TRANSFER EVAL ‘”1″‘ AS NB BREAK.ON EVAL ‘VALUE.DATE[1,6]’ AS DATE TOTAL NB WITH DATE LIKE “2010…” AND BROKER.NO EQ “595701” AND TRANSACTION.TYPE LIKE “F…” BY DATE ID.SUP DET.SUP

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.