Here's what I would like to do.

I would like to store the contents of large Adobe PDF files inside a table.
Reading the Sybase manuals I know this is possible via text and binary
datatypes etc...

My question is how to get the darn things in there to begin with.

I'm running UNIX and I would like to write a script to load them. This would
be a one time load. Can anyone give me any ideas about how to get the file
contents into Sybase from a script and/or command line to begiin with?

Regards,

Wayne

No, you really, really, really don't want to do that unless someone has
a large gun to your head (just wink if they do). Store the files on a
filesystem and store links to the files in the database. Storing large
amounts of binary data in the database, while possible, is not an
optimal solution. Database gets bloated, database recovery is slow,
manipulation is problematic; it's nothin' but pain and ugliness. One
more hint, use some level of indirection (symlinks, whatever) to your
'real' files and store the link in the database. Helps if you ever have
to move/restore the files to their not-so-original locations in that
emergency you figured would never happen. My .02.

Wayne Happ wrote:
> Here's what I would like to do.
>
> I would like to store the contents of large Adobe PDF files inside a table.
> Reading the Sybase manuals I know this is possible via text and binary
> datatypes etc...
>
> My question is how to get the darn things in there to begin with.
>
> I'm running UNIX and I would like to write a script to load them. This would
> be a one time load. Can anyone give me any ideas about how to get the file
> contents into Sybase from a script and/or command line to begiin with?
>
> Regards,
>
> Wayne
>
>

The guy who signs my invoices loves the idea.

"dUnit" <jackripper@purityofessence.edu> wrote in message
news:EY_gc.143480$2oI1.48495@twister01.bloor.is.ne t.cable.rogers.com...
> No, you really, really, really don't want to do that unless someone has
> a large gun to your head (just wink if they do). Store the files on a
> filesystem and store links to the files in the database. Storing large
> amounts of binary data in the database, while possible, is not an
> optimal solution. Database gets bloated, database recovery is slow,
> manipulation is problematic; it's nothin' but pain and ugliness. One
> more hint, use some level of indirection (symlinks, whatever) to your
> 'real' files and store the link in the database. Helps if you ever have
> to move/restore the files to their not-so-original locations in that
> emergency you figured would never happen. My .02.
>
> Wayne Happ wrote:
> > Here's what I would like to do.
> >
> > I would like to store the contents of large Adobe PDF files inside a
table.
> > Reading the Sybase manuals I know this is possible via text and binary
> > datatypes etc...
> >
> > My question is how to get the darn things in there to begin with.
> >
> > I'm running UNIX and I would like to write a script to load them. This
would
> > be a one time load. Can anyone give me any ideas about how to get the
file
> > contents into Sybase from a script and/or command line to begiin with?
> >
> > Regards,
> >
> > Wayne
> >
> >
>