[sqr-users] FTP from SQR.

["Sudeep Vaidya" <sudeep.vaidya@patni.com>]

Hi All,

We are creating a report (PDF ) file from a SQR. The PDF is to be FTPd to a
remote server.

1.My Procedure Print-to-file is Printing the data to the PDF file using the
Print Statements.
2. After Print-to-file is complete, I'm calling my procedure Do-FTP-File
which would FTP the file using the Call system commands
in Unix.

Even When the procedure Print-to-File is complete, probably the control of
the PDF is not released till the SQR is executing.
Hence my procedure Do-FTP-File  fails as it cannot find the file . Probably
the file is not even written to the disk at that time.
And even if it is written, perhaps the SQR is holding the Control through
the Operating System.

If I were creating a DAT file using Write Statements, I could have
explicitly closed the file using the Close Statement.

Question .How can I force the SQR to release the Control of the PDF after
the Print-to-file procedure is complete, so that the file is closed and can
be picked for FTP by the procedure Do-FTP-File .

Best Regards,

Sudeep

http://www.patni.com
World-Wide Partnerships. World-Class Solutions.
_____________________________________________________________________

This e-mail message may contain proprietary, confidential or legally
privileged information for the sole use of the person or entity to
whom this message was originally addressed. Any review, e-transmission
dissemination or other use of or taking of any action in reliance upon
this information by persons or entities other than the intended
recipient is prohibited. If you have received this e-mail in error
kindly delete  this e-mail from your records. If it appears that this
mail has been forwarded to you without proper authority, please notify
us immediately at netadmin@patni.com and delete this mail. 
_____________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users