Mass insert into IFS file using IFS_WRITE Simon Hutchinson

​There are times when someone asks me a question I think is interesting enough to become a post here. This was the question that was the germ for this post:

How can I read a physical file and for each records, use the IFS_WRITE Function to write the [ IFS ] file?

The IFS_WRITE are really three SQL procedures that writes data to a file in the IFS:

IFS_WRITE:  Write plain text to IFS file
IFS_WRITE_UTF8:  Write UTF8 text
IFS_WRITE_BINARY:  Write binary text

In the following examples I am going to use IFS_WRITE_UTF8 as I want the contents of the IFS file to be UTF8 compatible.
Read more » Read More 

Verified by MonsterInsights