Re: Partitioned Table not letting me write to it

@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.