Re: Save a BLOB only with SQL

Hello Daniel,

IFS_WRITE_BINARY is a stored procedure that cannot be called directily from
a SELECT statement, as in the case of 'get_blob_from_file'.

Will I have to create a user-defined function for this purpose?

Thanks

Javier Mora

El dom, 5 ene 2025 a las 22:07, Daniel Gross (<daniel@xxxxxxxx>) escribió:

Hi Javier,

i would try IFS_WRITE_BINARY.

->
https://www.ibm.com/docs/en/i/7.5?topic=is-ifs-write-ifs-write-binary-ifs-write-utf8-procedures

HTH
Daniel

Am 05.01.2025 um 21:51 schrieb datil400 <datil400@xxxxxxxxx>:

Hi guys,

Is there any way to save a BLOB type in the IFS without having to use

RPG?

To load a BLOB you can use the function 'get_blob_from_file' but I can't
find the complementary one. Does this exist?

Best regards

--
Javier Mora
https://github.com/datil400
--
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.