LIST TRANSACTION FROM TELLER FOR PREDEFINED SELECT
- EDA001
- Topic Author
- Visitor
-
11 years 3 months ago #15817
by EDA001
LIST TRANSACTION FROM TELLER FOR PREDEFINED SELECT was created by EDA001
dear all i have inactive accounts for a single company in account file /FBNK.ACCOUNT/. I wanted to list all transaction from TELLER$HIS for those inactive account only.
i am able to select the inactive account for that branch using the following command.
SELECT FBNK.ACCOUNT WITH CO.CODE = ET0010016 AND INACTIV.MARKER = Y
2279 Records selected
>
but further to this i wanted to access FBNK.TELLER$HIS and list transactions from FBNK.TELLER$HIS for only those selected accounts above
can anyone help ??
i am able to select the inactive account for that branch using the following command.
SELECT FBNK.ACCOUNT WITH CO.CODE = ET0010016 AND INACTIV.MARKER = Y
2279 Records selected
>
but further to this i wanted to access FBNK.TELLER$HIS and list transactions from FBNK.TELLER$HIS for only those selected accounts above
can anyone help ??
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
11 years 3 months ago #15820
by jpb
Replied by jpb on topic LIST TRANSACTION FROM TELLER FOR PREDEFINED SELECT
In jBase it's not possible to select from a list on a not-ID field (sounds stupid, hope you get my point).
But what you can do is using EVAL, it's a mighty utility.
For Example :
LIST FBNK.TELLER$HIS ACCOUNT.2 EVAL"ACCOUNT.2;SUBR('ENQ.TRANS','ACCOUNT',@1,'INACTIV.MARKER')" AS INACTIV WITH INACTIV EQ "Y"
should come close to your needs.
Just make sure you logged on in classic to the correct company before launching the JQL.
But what you can do is using EVAL, it's a mighty utility.
For Example :
LIST FBNK.TELLER$HIS ACCOUNT.2 EVAL"ACCOUNT.2;SUBR('ENQ.TRANS','ACCOUNT',@1,'INACTIV.MARKER')" AS INACTIV WITH INACTIV EQ "Y"
should come close to your needs.
Just make sure you logged on in classic to the correct company before launching the JQL.
Please Log in or Create an account to join the conversation.
Time to create page: 0.035 seconds