Really, do you want to retrieve data from another database and show it with CSP ?

Well, it still possible, but needs more details. You can do it by creating some connection via JDBC or ODBC or in any other ways to this particular database, and call queries to get needed data. But it means you should know, how to connect to this database. Can you say, which database you should connect to? And maybe you can describe reasons why you should do so?

And also, I forgot to mention about method CreateDirectoryChain in %File class. And you should use it, if you want just create a folder.

But back to $zf, can you try this command ?

set cmd="mkdir e:\Sample\new" > output.log 2> output.log"
set res=$zf(-1, cmd)

and what will be in res variable, and in output.log file which you can find in database folder for your namespace.

Yes, you right, but you should also remember, that your file can also be in another property, like `Content`. 

I think that you want to set some limit, for file which is available to upload to server. And in this case, this file will be uploaded at the server any way. And I would recommend to use FileAPI on client side, and you can check file size before loading it to the server.

What do you mean ?

To get this task running every hour every day, you should use Daily, and set every 60 minutes or 1 hours, and set a limit for this task in days time, like working only in business hours. And you can also use Weekly and Monthly schedule, with working every hours. It means that you can set task to work only in working days at business hours every hour.

And OnDemand tasks, will run only by manual, and will be run only once after start.