I'm a novice at best with FTP and need to know how to trap an FTP error.
My code is;
G Orders.xml (REPLACE
DELETE Orders.xml
This code works just fine most of the time.
We're having a situation that an Orders.xml will show up after the Get...
4 results in 0.0018 seconds.
-
FTP Trap failed GET
-
stopping large spooled files after leaving outq
I have an Epson forms printer that is attached to a dumb terminal. When printing large spooled files, the spooled files leave the outq and there is no way to hold or delete them once they start printing. How can I control - or can I - how much of the spooled file goes to the printer at once? This is... -
Problems Deleting Records in Embedded SQL (V4R3)
I've got a program that's supposed to clear it's records when a job is complete. I added the following procedure into the code. It never returns an error, but the records don't actually get removed. The same SQL statement works if I use it directly from STRSQL. I'm at a loss. Any help would be... -
aliceraunsbaek started a topic SQLRPGLE: How to update/delete without host variables? (sql is in a string)in SQLSQLRPGLE: How to update/delete without host variables? (sql is in a string)
Can anyone tell me how to best run a delete/inster/update that has been stored in a string?
E.g.:
I can code the following:
But, I would like something like:Code:Exec SQL delete from table1 where lastUse < current timestamp - 7 days;
...Code:MyStatement = 'delete