jbase error
- Andi
- Topic Author
- Visitor
-
10 years 3 weeks ago - 10 years 3 weeks ago #17553
by Andi
jbase error was created by Andi
Dear JBP thank you for your suggestion
and i have another issues which is related with the tuning
To execute the following query it take more time . is there a method to solve this problem( to minimize the time taken during the execution)
jsh t24test ~ -->SQLSELECT a.ACCOUNT_TITLE_1, a.ACCOUNT_NUMBER, a.OPEN_ACTUAL_BAL, a.WORKING_BALANCE, b. AMOUNT_LCY FROM FBNK.ACCOUNT a, FBNK."STMT.ENTRY" b WHERE a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER AND a.CATEGORY = '6602’
and i have another issues which is related with the tuning
To execute the following query it take more time . is there a method to solve this problem( to minimize the time taken during the execution)
jsh t24test ~ -->SQLSELECT a.ACCOUNT_TITLE_1, a.ACCOUNT_NUMBER, a.OPEN_ACTUAL_BAL, a.WORKING_BALANCE, b. AMOUNT_LCY FROM FBNK.ACCOUNT a, FBNK."STMT.ENTRY" b WHERE a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER AND a.CATEGORY = '6602’
Last edit: 10 years 3 weeks ago by Andi.
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
10 years 3 weeks ago - 10 years 3 weeks ago #17555
by jpb
Replied by jpb on topic jbase error
The trick for table names containing a dot is not like for columns to replace them by underscore but to enclose them in quotes, e.g.
SQLSELECT a.ACCOUNT_TITLE_1, a.ACCOUNT_NUMBER, a.OPEN_ACTUAL_BAL, b. AMOUNT_LCY FROM FBNK.ACCOUNT a, FBNK."STMT.ENTRY" b WHERE a.CO_CODE = b.CO_CODE AND a.CATEGORY = '6602'
a selection AND a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER would help a lot to reduce output :-)
SQLSELECT a.ACCOUNT_TITLE_1, a.ACCOUNT_NUMBER, a.OPEN_ACTUAL_BAL, b. AMOUNT_LCY FROM FBNK.ACCOUNT a, FBNK."STMT.ENTRY" b WHERE a.CO_CODE = b.CO_CODE AND a.CATEGORY = '6602'
a selection AND a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER would help a lot to reduce output :-)
Last edit: 10 years 3 weeks ago by jpb. Reason: additional selection
The following user(s) said Thank You: Andi
Please Log in or Create an account to join the conversation.
Time to create page: 0.036 seconds