Re: Formula for loading subfile with multiple records across

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Jeff,

Off the top of my head...

Use embedded SQL to fetch 45 rows at a time, then use a loop to load
the subfile as you want.

Charles



On Wed, Sep 16, 2009 at 3:35 PM, Jeff Young <cooljeff913@xxxxxxxxx> wrote:
> I have a subfile with 15 lines per page and 3 records per line.
> The normal way the system loads the subfile is down and then across.
> I would like to load it across, then down.
>
> Ex: Record 1 = RR# 1
>      Record 2 = RR# 16
>      Record 3 = RR# 31
>
>      Record 4 = RR# 2
>      Record 5 = RR# 17
>      Record 6 = RR# 32
> .....
>
> Does anyone have a formula or method that will do this?
>
>
> TIA
>
> Jeff Young
> Sr. Programmer Analyst
> IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
> IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
> IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.