Subject | Insert into BLOB field using isql |
---|---|
Author | aleskahanek |
Post date | 2005-04-28T20:09:37Z |
Hi,
I would like to ask, if there is possibility to insert into blob field
with isql, something like
INSERT INTO MYTABLE (SOMEBLOB) VALUES (SOMEBLOBVALUE)
I know, that there are lots of recommendation to prepare parametrized
query and load blob content into a parameter, but that is not I am
looking for. I am interested in a commandline tool that can handle SQL
scripts like isql does.
I also know that IBExpert (commandline version IBEScript precisely)
can do something like
INSERT INTO MYTABLE (SOMEBLOB) VALUES (:h00006143_0000051B);
where the parameter specifies the hexa start and end positions from
external file specified by some other command before the insert is
issued. This is nice because it does not matter what type of data the
file holds (text, pictures, pdf, ...), preparing such file is not a
problem, then you distribute only this file and sql script.
Can isql do this or something similar?
I would like to ask, if there is possibility to insert into blob field
with isql, something like
INSERT INTO MYTABLE (SOMEBLOB) VALUES (SOMEBLOBVALUE)
I know, that there are lots of recommendation to prepare parametrized
query and load blob content into a parameter, but that is not I am
looking for. I am interested in a commandline tool that can handle SQL
scripts like isql does.
I also know that IBExpert (commandline version IBEScript precisely)
can do something like
INSERT INTO MYTABLE (SOMEBLOB) VALUES (:h00006143_0000051B);
where the parameter specifies the hexa start and end positions from
external file specified by some other command before the insert is
issued. This is nice because it does not matter what type of data the
file holds (text, pictures, pdf, ...), preparing such file is not a
problem, then you distribute only this file and sql script.
Can isql do this or something similar?