Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT carrid connid fldate seatsmax seatsocc
- FROM sflight INTO CORRESPONDING FIELDS OF sflight_str WHERE carrid = AIRLINE.
- sbc_str-carrid = sflight_str-carrid.
- sbc_str-connid = sflight_str-connid.
- sbc_str-fldate = sflight_str-fldate.
- sbc_str-seatsmax = sflight_str-seatsmax.
- sbc_str-seatsocc = sflight_str-seatsocc.
- sbc_str-percentage = sflight_str-seatsocc / sflight_str-seatsmax * 100.
- APPEND sbc_str TO itable.
- ENDSELECT.
Add Comment
Please, Sign In to add comment