"LIST" with MultiValue and SubValue

Start
Prev
1
Next
End

elix545
Topic Author
Offline
Junior Member

12 years 3 months ago #12343 by elix545

"LIST" with MultiValue and SubValue was created by elix545

How can I using "List" with MultiValue fields and SubValue fields?

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

jpb
Offline
Moderator
retired

12 years 3 months ago #12349 by jpb

Replied by jpb on topic "LIST" with MultiValue and SubValue

Just LIST them, they will be displayed correctly

LIST FBNK.FT.COMMISSION.TYPE CURRENCY CALC.TYPE PERCENTAGE
@ID.................    CURRENCY    CALC.TYPE    PERCENTAGE.

             CASHDEP    CHF             LEVEL             .5
                        AUD             LEVEL             .5
                        CAD             LEVEL             .5
                        CZK             LEVEL             .5
                        DKK             LEVEL             .5
                        EUR             LEVEL             .5
                        GBP             LEVEL             .5
                        HKD             LEVEL             .5
                        IDR             LEVEL             .5
                        INR             LEVEL             .5
...

For fine-tuning your LIST you can use BY.EXP to "explode" all fields to the MV

LIST FBNK.FT.COMMISSION.TYPE BY-EXP CURRENCY CURRENCY CALC.TYPE PERCENTAGE WITH @ID LIKE C...

@ID.................    CURRENCY    CALC.TYPE    PERCENTAGE.
             CASHDEP    AUD             LEVEL             .5
          CASHWITHDR    AUD             LEVEL             .5
             CASHDEP    CAD             LEVEL             .5
          CASHWITHDR    CAD             LEVEL             .5
            CASHCARD    CHF             LEVEL             .5
         CASHCARDEXT    CHF             LEVEL             .5
...

and last but not least you can use WHEN to select on MV-level

LIST FBNK.FT.COMMISSION.TYPE BY-EXP CURRENCY CURRENCY UPTO.AMT CALC.TYPE PERCENTAGE WHEN CURRENCY EQ "USD" AND WHEN PERCENTAGE LT .5

@ID.................    CURRENCY    UPTO.AMT..........    CALC.TYPE    PERCENTAGE.

             SCPM911    USD                  500000.00         BAND           0.35
                                            1000000.00         BAND            0.3
                                            5000000.00         BAND           0.25
                                                               BAND            0.2
             SCPM968    USD                 3000000.00        LEVEL            0.5
                                            5000000.00        LEVEL            0.4
                                            8000000.00        LEVEL            0.3
                                           10000000.00        LEVEL          0.275
                                           14000000.00        LEVEL           0.25
                                                              LEVEL            0.2
...

The following user(s) said Thank You: elix545

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

elix545
Topic Author
Offline
Junior Member

12 years 3 months ago - 12 years 3 months ago #12362 by elix545

Replied by elix545 on topic "LIST" with MultiValue and SubValue

Thank you very much.

Last edit: 12 years 3 months ago by elix545.

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

Start
Prev
1
Next
End

Time to create page: 0.072 seconds