IBM i (AS400) fans only ' How to read a TXT file in the IFS with SQL
In this post, I'm going to show how you can easily read a TXT file in IFS using SQL. I create a file named divina.txt and copy it to IFS. Here we can see the file divina.txt into IFS. I use ACS to show it. Here we can see the file divina.txt into IFS. I use WRKLNK to show it. Here we can see the file divina.txt into IFS. I use option 5=Display into WRKLNK ( Work with Object Links ). I read it through SQL and write it to QTEMP/OUTFILE: Execute this SQL command: CREATE TABLE QTEMP.OUTFILE (RECORD) AS (SELECT CAST(LINE AS CHAR(50)) FROM TABLE (QSYS2.IFS_READ('/home/VDOTEST/WSF/DIVINA.txt'))) WITH DATA To display the QTEMP/OUTFILE file, type from the command line: DSPPFM FILE(QTEMP/OUTFILE) That's it. I appreciate all the comments made on this blog.