-770 (bad fragment id) on a local insert querying
11.5.FC6, linux = ncmsimages
11.5.UC5, linux = cmsimages
I have a shell script with a dbaccess embedded within, surrounded by two
"date" commands.
Any ideas as to what the -770 is trying to tell me? I don't recall seeing that
message before, nor do I know why it put a "()-" before the error
number/message as that is not in the script. Thanks in advance for any
assistance.
cat do_tci.out
Fri Jan 22 10:52:11 EST 2010
database tcimages;Database selected.
insert into images
(
i_citation_id,
i_docket_id,
d_image_date,
c_image_time,
c_image_user,
i_image_page,
c_image_box,
b_image_byte,
i_image_id,
c_bestavailable
)
select
i_citation_id,
i_docket_id,
d_image_date,
c_image_time,
c_image_user,
i_image_page,
c_image_box,
b_image_byte::blob,
i_image_id,
c_bestavailable
from tcimages@cmsimagesra_net:images;
() -
770: Bad fragment id specified.
Error in line 26Near character position 35
Database closed.
Fri Jan 22 10:52:12 EST 2010
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/196390709/direct/01/
IB that the error is caused by the "()-" string. Look into the script.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Fri, Jan 22, 2010 at 11:22 AM, Clifton Bean <clifton_bean@hotmail.com>wrote:
> 11.5.FC6, linux = ncmsimages
>
> 11.5.UC5, linux = cmsimages
>
> I have a shell script with a dbaccess embedded within, surrounded by two
> "date" commands.
>
> Any ideas as to what the -770 is trying to tell me? I don't recall seeing
> that
> message before, nor do I know why it put a "()-" before the error
> number/message as that is not in the script. Thanks in advance for any
> assistance.
>
> cat do_tci.out
>
> Fri Jan 22 10:52:11 EST 2010
> database tcimages;> Database selected.
>
> insert into images
> (>
> i_citation_id,
>
> i_docket_id,
>
> d_image_date,
>
> c_image_time,
>
> c_image_user,
>
> i_image_page,
>
> c_image_box,
>
> b_image_byte,
>
> i_image_id,
>
> c_bestavailable
> )
>
> select
>
> i_citation_id,
>
> i_docket_id,
>
> d_image_date,
>
> c_image_time,
>
> c_image_user,
>
> i_image_page,
>
> c_image_box,
>
> b_image_byte::blob,
>
> i_image_id,
>
> c_bestavailable
> from tcimages@cmsimagesra_net:images;
> () -
>
> 770: Bad fragment id specified.
> Error in line 26> Near character position 35
>
> Database closed.
>
> Fri Jan 22 10:52:12 EST 2010
>
> _________________________________________________________________
> Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
> http://clk.atdmt.com/GBL/go/196390709/direct/01/
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c59874765c7f047dc3f434
This is the script:
date
dbaccess -e - <<EOFdatabase tcimages;
insert into images
(
i_citation_id,
i_docket_id,
d_image_date,
c_image_time,
c_image_user,
i_image_page,
c_image_box,
b_image_byte,
i_image_id,
c_bestavailable
)
select
i_citation_id,
i_docket_id,
d_image_date,
c_image_time,
c_image_user,
i_image_page,
c_image_box,
b_image_byte::blob,
i_image_id,
c_bestavailable
from tcimages@cmsimagesra_net:images;
EOF
date
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: -770 (bad fragment id) on a local insert q.... [18754]
> Date: Fri, 22 Jan 2010 12:14:45 -0500
>
> IB that the error is caused by the "()-" string. Look into the script.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> IIUG Board of Directors (art@iiug.org)
>
> See you at the 2010 IIUG Informix Conference
> April 25-28, 2010
> Overland Park (Kansas City), KS
> www.iiug.org/conf
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Fri, Jan 22, 2010 at 11:22 AM, Clifton Bean
> <clifton_bean@hotmail.com>wrote:
>
> > 11.5.FC6, linux = ncmsimages
> >
> > 11.5.UC5, linux = cmsimages
> >
> > I have a shell script with a dbaccess embedded within, surrounded by two
> > "date" commands.
> >
> > Any ideas as to what the -770 is trying to tell me? I don't recall seeing
> > that
> > message before, nor do I know why it put a "()-" before the error
> > number/message as that is not in the script. Thanks in advance for any
> > assistance.
> >
> > cat do_tci.out
> >
> > Fri Jan 22 10:52:11 EST 2010
> > database tcimages;> > Database selected.
> >
> > insert into images
> > (> >
> > i_citation_id,
> >
> > i_docket_id,
> >
> > d_image_date,
> >
> > c_image_time,
> >
> > c_image_user,
> >
> > i_image_page,
> >
> > c_image_box,
> >
> > b_image_byte,
> >
> > i_image_id,
> >
> > c_bestavailable
> > )
> >
> > select
> >
> > i_citation_id,
> >
> > i_docket_id,
> >
> > d_image_date,
> >
> > c_image_time,
> >
> > c_image_user,
> >
> > i_image_page,
> >
> > c_image_box,
> >
> > b_image_byte::blob,
> >
> > i_image_id,
> >
> > c_bestavailable
> > from tcimages@cmsimagesra_net:images;
> > () -
> >
> > 770: Bad fragment id specified.
> > Error in line 26> > Near character position 35
> >
> > Database closed.
> >
> > Fri Jan 22 10:52:12 EST 2010
> >
> > _________________________________________________________________
> > Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
> > http://clk.atdmt.com/GBL/go/196390709/direct/01/
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c59874765c7f047dc3f434
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
http://clk.atdmt.com/GBL/go/196390708/direct/01/
Weird, nothing there.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Fri, Jan 22, 2010 at 12:22 PM, Clifton Bean <clifton_bean@hotmail.com>wrote:
> This is the script:
>
> date
>
> dbaccess -e - <<EOF> database tcimages;>
> insert into images
> (>
> i_citation_id,
>
> i_docket_id,
>
> d_image_date,
>
> c_image_time,
>
> c_image_user,
>
> i_image_page,
>
> c_image_box,
>
> b_image_byte,
>
> i_image_id,
>
> c_bestavailable
> )
>
> select
>
> i_citation_id,
>
> i_docket_id,
>
> d_image_date,
>
> c_image_time,
>
> c_image_user,
>
> i_image_page,
>
> c_image_box,
>
> b_image_byte::blob,
>
> i_image_id,
>
> c_bestavailable
> from tcimages@cmsimagesra_net:images;
> EOF
>
> date
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: -770 (bad fragment id) on a local insert q.... [18754]
> > Date: Fri, 22 Jan 2010 12:14:45 -0500
> >
> > IB that the error is caused by the "()-" string. Look into the script.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > IIUG Board of Directors (art@iiug.org)
> >
> > See you at the 2010 IIUG Informix Conference
> > April 25-28, 2010
> > Overland Park (Kansas City), KS
> > www.iiug.org/conf
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> > do not reflect on my employer, Advanced DataTools, the IIUG, nor any
> other
> > organization with which I am associated either explicitly, implicitly, or
> by
> > inference. Neither do those opinions reflect those of other individuals
> > affiliated with any entity with which I am affiliated nor those of the
> > entities themselves.
> >
> > On Fri, Jan 22, 2010 at 11:22 AM, Clifton Bean
> > <clifton_bean@hotmail.com>wrote:
> >
> > > 11.5.FC6, linux = ncmsimages
> > >
> > > 11.5.UC5, linux = cmsimages
> > >
> > > I have a shell script with a dbaccess embedded within, surrounded by
> two
> > > "date" commands.
> > >
> > > Any ideas as to what the -770 is trying to tell me? I don't recall
> seeing
> > > that
> > > message before, nor do I know why it put a "()-" before the error
> > > number/message as that is not in the script. Thanks in advance for any
> > > assistance.
> > >
> > > cat do_tci.out
> > >
> > > Fri Jan 22 10:52:11 EST 2010
> > > database tcimages;> > > Database selected.
> > >
> > > insert into images
> > > (> > >
> > > i_citation_id,
> > >
> > > i_docket_id,
> > >
> > > d_image_date,
> > >
> > > c_image_time,
> > >
> > > c_image_user,
> > >
> > > i_image_page,
> > >
> > > c_image_box,
> > >
> > > b_image_byte,
> > >
> > > i_image_id,
> > >
> > > c_bestavailable
> > > )
> > >
> > > select
> > >
> > > i_citation_id,
> > >
> > > i_docket_id,
> > >
> > > d_image_date,
> > >
> > > c_image_time,
> > >
> > > c_image_user,
> > >
> > > i_image_page,
> > >
> > > c_image_box,
> > >
> > > b_image_byte::blob,
> > >
> > > i_image_id,
> > >
> > > c_bestavailable
> > > from tcimages@cmsimagesra_net:images;
> > > () -
> > >
> > > 770: Bad fragment id specified.
> > > Error in line 26> > > Near character position 35
> > >
> > > Database closed.
> > >
> > > Fri Jan 22 10:52:12 EST 2010
> > >
> > > _________________________________________________________________
> > > Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
> > > http://clk.atdmt.com/GBL/go/196390709/direct/01/
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001636c59874765c7f047dc3f434
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> _________________________________________________________________
> Hotmail: Free, trusted and rich email service.
> http://clk.atdmt.com/GBL/go/196390708/direct/01/
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0cdf9b44a3713c047dc45fe1