|
I have a basic question here. How are you generating the file--
containing these messages from consoles? I notice you're substringing
message numbers, etc. Have you thought about using the SQL services
like those at these links:
https://www.ibm.com/docs/en/i/7.5?topic=services-message-handling
If you're not sure if they are supported at your version of OS you can
check out:
https://www.ibm.com/support/pages/node/1119123
On Thu, Jan 19, 2023 at 4:04 AM Mónica Anastácio <
monicaanastacio@xxxxxxxxx>
wrote:
im so sorrythe
Logical File
A *$PMCCMSG I SST($PMCMSG1 1 7) *
A K *$PMCCMSG *
A K $PMCDTEV
A S $PMCSITU COMP(EQ 'P')
A $PMCDEST COMP(NE 'CG')
INDEX FILE CREATED
CREATE INDEX CONSOLE_MESSAGES_$P_4 FOR SYSTEM NAME $PMCONS4
ON CONSOLE_MESSAGES_$P (*$PMCCMSG *ASC, SEND_DATE ASC)
WHERE (STATUS = 'P' AND RECIPIENT <> 'CG')
RCDFMT RMCONS4;
And this was my tries
CREATE INDEX CONSOLE_MESSAGES_SENT_$P_4 FOR SYSTEM NAME $PMCONS4
ON CONSOLE_MESSAGES_SENT_$P (MESSAGE_FIRST_LEVEL(7), SEND_DATE
ASC)
WHERE (STATUS = 'P' AND RECIPIENT <> 'CG')
RCDFMT RMCONS4;
CREATE INDEX CONSOLE_SENT_MESSAGES_$P_4 FOR SYSTEM NAME $PMCONS4
ON CONSOLE_SENT_MESSAGES_$P AS (MESSAGE_CODE FOR
SUBSTRING(MESSAGE_FIRST_LEVEL,1,7) ASC,
SEND_DATE ASC)
WHERE (STATUS = 'P' AND RECIPIENT <> 'CG')
RCDFMT RMCONS4;
CREATE INDEX CONSOLE_SENT_MESSAGES_$P_4 FOR SYSTEM NAME $PMCONS4
ON CONSOLE_SENT_MESSAGES_$P MESSAGE_CODE AS
SUBSTRING(MESSAGE_FIRST_LEVEL,1,7)
(MESSAGE_CODE ASC, SEND_DATE ASC)
WHERE (STATUS = 'P' AND RECIPIENT <> 'CG')
RCDFMT RMCONS4;
On Wed, Jan 18, 2023 at 6:51 PM Rob Berendt
<robertowenberendt@xxxxxxxxx
wrote:
Sorry for my bad advice from earlier.
I looked at the basic CREATE INDEX at
https://www.ibm.com/docs/en/i/7.5?topic=statements-create-index
and
relatedvery last example is
CREATE INDEX DEPT_TYPE
ON DEPARTMENT (SUBSTR(DEPTNO,2,2))
--
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
--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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.