Re: Partitioned Table not letting me write to it

[Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>]

now how does "format select" work on writes?

On Thu, Apr 13, 2023 at 8:56 AM Code 1109 via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

>  @Birgitta Hauser Thank you that worked!
>     On Thursday, April 13, 2023 at 12:28:06 AM CDT, Birgitta Hauser <
> hauser@xxxxxxxxxxxxxxx> wrote:
>
>  Have you tried to create an SQL index over all partitions?
> CREATE INDEX LIBNAME.INDEXNAME
>   ON LIBNAME.TABLENAME(COLUMNNAME)
>   NOT PARTITIONED
> ... and have you tried to use this index in composition with native I/O.
> (note: an SQL index cannot be specified in an SQL statement but used in
> composition with native I/O like any keyed logical file).
>
> From the documentation:
> When the file (SQL table) becomes partitioned, the file becomes a
> multimember file and the traditional system application needs to specify
> the member name (partition name).
> The traditional system application can avoid having to specify a member
> name when reading or writing data by changing the application to use an SQL
> index that is based on all the members of the physical file.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
> Modernization – Education – Consulting on IBM i
>
> IBM Champion since 2020
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> „Train people well enough so they can leave, treat them well enough so
> they don't want to.“ (Richard Branson)
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Code
> 1109 via RPG400-L
> Sent: Wednesday, 12 April 2023 21:35
> To: rpg400-l@xxxxxxxxxxxxxxxxxx
> Cc: Code 1109 <code1109@xxxxxxxxx>
> Subject: Partitioned Table not letting me write to it
>
> Hello all, I have a partitioned SQL table with a LF over it and I have a
> quick proof of concept pgm to test writing (using the LF) the value of
> 1012729793 but it doesn't do it. While debugging I get this: "Member number
> needed for member [my file]"
> The table has 5 partitions by range of a 15,0 numeric field named Field001:
> Partition by Range ( Field001 nulls last) ( Partition PART000001 Starting
> (1) InclusiveEnding  (750000000) Inclusive, Partition PART000002 Starting
> (750000001) InclusiveEnding  (1500000000) Inclusive, Partition PART000003
> Starting (1500000001) InclusiveEnding  (2250000000) Inclusive,
> etc..)
> Can someone provide guidance on what I'm doing wrong and how to fix it?
> Many thanksRamon S.
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list To post a
> message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.