Hi Britta,
When I run your statement using CMTCTL I get : Zeichenumsetzung zwischen
CCSID 65535 und CCSID 1200 ungültig.
How do you get around that message ???
Nachrichten-ID . . . . : SQL0332
Ursache . . . . : Es wurde versucht, eine Zeichen- oder Grafikumsetzung
für
nicht verträgliche Daten durchzuführen. Eine Umsetzung zwischen CCSID
65535
und CCSID 1200 ist nicht definiert.
Ist eine CCSID 65535, ist die andere CCSID eine Grafik-CCSID. Die
Umsetzung zwischen der CCSID 65535 und einer Grafik-CCSID ist nicht
definiert.
Handelt es sich um eine Anweisung CONNECT, ist die Umsetzung zwischen
der
Standard-SBCS-CCSID des Anwendungs-Requesters und der SBCS-CCSID des
Anwendungsserver nicht definiert. Ist die zweite CCSID 0, wurde die
Standard-SBCS-CCSID des Anwendungsservers nicht zurückgegeben. Ein
Anwendungsserver, der kein DB2 für IBM i-Anwendungsserver ist, unterstützt
Mit freundlichen Grüßen / Kind regards / Bien à vous,
Seán Courtney
Confidentiality Notice:
This message and any attachments may contain confidential and privileged
information. The information contained herein is transmitted for the sole
use of the intended recipient(s). If you are not the intended recipient or
designated agent of the recipient of such information, please notify the
sender immediately and permanently delete this email. Thank You
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Birgitta Hauser
Sent: Thursday, 9 November 2023 05:46
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Searching in the IFS . . .
You could also use SQL:
Select Path_Name, Get_Clob_From_File(Path_Name) "IFS File Content"
From Table (Qsys2.Ifs_Object_Statistics(Start_Path_Name =>
'/home/Hauser',
Subtree_Directories => 'YES',
Object_Type_List =>
'*ALLSTMF')) x
Where Get_Clob_From_File(Path_Name) like '%Whatever you search%'
Order By Path_Name;
Note:
1. you have to run the statement under commitment control
2. It is not necessary to display the content in the result.
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) "Learning is experience ? everything else
is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of James
H. H. Lampert via MIDRANGE-L
Sent: Wednesday, 8 November 2023 21:45
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx>
Subject: Searching in the IFS . . .
Is there a way, from a terminal session, to search through an entire
directory subtree of the IFS for a character string?
--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
midrange.com
