Re: Copying files from PC to Unix (FTP vs Tables)

Have you try NFS? Or try free version of samba (www.samba.org). At 1/25/99 02:10 PM , Gutierrez, Francisco wrote: >Need help with a dilemma we have in copying files from a PC to the Unix >environment. > >My client/server application uses FTP to copy files (excel, doc, powerpoint, >etc) from a PC to a UX server for archiving and mailing purposes. FTPing >has worked okay without any problems thus far. However, we are wondering if >it would be better, or a more reliable method, to copy files using Informix >tables? Any suggestions/comments? > >Can someone provide me an example of the SQL syntax for a table that has a >blob field, and the syntax to insert/retrieve a binary file to/from the blob >column in the Informix table. The table will be used as a work table just >to copy from the PC to the UX environment, as mentioned above. > >Thanks. Your help is very much appreciated. > >--Francisco Gutierrez >--email: francisco_gutierrez@hp.com ======================== Susik Lee slee@gus.net ========================

Susik Lee wrote: > > Have you try NFS? Or try free version of samba (www.samba.org). > > At 1/25/99 02:10 PM , Gutierrez, Francisco wrote: > >Need help with a dilemma we have in copying files from a PC to the Unix > >environment. > > > >My client/server application uses FTP to copy files (excel, doc, powerpoint, > >etc) from a PC to a UX server for archiving and mailing purposes. FTPing > >has worked okay without any problems thus far. However, we are wondering if > >it would be better, or a more reliable method, to copy files using Informix > >tables? Any suggestions/comments? > > > >Can someone provide me an example of the SQL syntax for a table that has a > >blob field, and the syntax to insert/retrieve a binary file to/from the blob > >column in the Informix table. The table will be used as a work table just > >to copy from the PC to the UX environment, as mentioned above. Check out the ESQL/C manual's description of using LOCFNAME in Dynamic SQL section to load a file into a BLOB field. However, I think that Susik is correct, NFS or Samba, or even continuing to use FTP, will do the job better with less hassle. Remember the old adage when thoughts like this come into your head: "When all you have is a hammer, everything starts to look like a nail!" When you start to cook up ideas on how to use your hammer to drive a screw it is time to go buy a screwdriver! Art S. Kagel