FTP is great, but when your looking to send files quickly over the network you may want to look at the commands: scp, rcp, and pscp. The use case scenario my friend Chuk brought up is the initial load of a project with many dependencies that were quickly retrieved from the internet but pushing to the hosting server is slower. On a Mac or Linux box you just need to get to the terminal to use the command and on Windows you just need to use Putty. The links below will show you how to use them:
Other reasons for your file transfer being slow could be a slow connection to the server which if you can upgrade your connection, routers and internet connect to gigabit or better you’ll remove some of these issues
The translate function is pretty amazing. You pass in the variable, a string of characters you want the character to be replaced with followed by a string of characters you want to search for. In the example below all numeric characters become N and all N’s become X. This makes all your Digits the character N which you can then compare to ‘NNNNN’ in this instance of a char(5) datatype column to select your numeric only fields, you can then do a numeric comparison such as greater than <10000 without running into a SQL exception with casting nonnumeric characters.
SQL Reference for IBM i – to learn more about TRANSLATE
So I tried deleting a file on the IFS and the only permission a user needs is *OBJEXIST. So make sure your not granting public or QTMHHTTP *OBJEXIST permission blindly and to lock down the $filename passed to unlink to make sure you don’t have someone deleting all your files.