IDS Forum

RE: SCHAPI: Error -23197 Database locale infor....

Posted By: Alexandre Marini
Date: Tuesday, 20 October 2015, at 3:03 p.m.

In Response To: Re: SCHAPI: Error -23197 Database locale infor.... (Peter Lempochner)

I think your question must be answered by some of our IBMers friends.
Even though I think this might be a bug, have your tried to call support? Maybe it's already fixed.

Somebody could help???
Regards.

Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10

IBM Information Management Informix Technical Professional

IBM Certified Developer - Informix Genero
BRIUG website administrator
Informix independent consultant

> To: ids@iiug.org
> From: peter.lempochner@dignitas.sk
> Subject: Re: SCHAPI: Error -23197 Database locale infor.... [35911]
> Date: Tue, 20 Oct 2015 14:21:11 -0400
>
> Hello, thanks for reaction.
>
> Collation must be sk_SK.912 this is customer request and production
> database use it.
> So I haven`t tried other collation.
> My sql statement have no problem if I run it through dbaccess from
> session connected to sysadmin database.
> Sysadmin database have en_us.819 - confirmed.
> Question is:
> Is there any way how to unload table to FS through IDS scheduler if
> There is difference between collation of sysadmin and source database?
>
> I want to schedule this through IDS rather then through shell script
> scheduled in cron :(
>
> Peter
>
> Dòa 20.10.2015 o 20:00 Alexandre Marini napísal(a):
> > Hello.
> > Have you tried (or can you) try to use utf8 in your collation?
> > Did you try to run the statement through a dbaccess connection? Does it
> works?
> > It must do... just in case.
> > I think that issue is happening because your sysadmin database is en_us.819,
> > which is different from your db1 locale.
> >
> > Alexandre Marini
> > IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
> >
> > IBM Information Management Informix Technical Professional
> >
> > IBM Certified Developer - Informix Genero
> > BRIUG website administrator
> > Informix independent consultant
> >
> >> To: ids@iiug.org
> >> From: peter.lempochner@dignitas.sk
> >> Subject: SCHAPI: Error -23197 Database locale informati.... [35909]
> >> Date: Tue, 20 Oct 2015 13:33:12 -0400
> >>
> >> Hello,
> >>
> >> we are runnig on IDS 11.70.UC3. I have table with CLOB - for example in
> >> database db1 (COLLATE is sk_SK.912):
> >>
> >> create table abc ( id serial, c clob);
> >>
> >> There are some data in this table.
> >> I need to schedule custom task for periodicaly unload data from this
> >> table to filesystem.
> >> So I have created external table like this:
> >>
> >> CREATE EXTERNAL TABLE abc_ext SAMEAS abc
> >> USING (DATAFILES ("DISK:/tmp/UNLOAD/abc.dat"),REJECTFILE
> >> "/tmp/UNLOAD/abc.rej");
> >>
> >> When I run following sql command:
> >> insert into db1:abc_test select * from db1:abc;
> >> The result is expected: in /tmp/UNLOAD/abc.dat are unloaded data.
> >>
> >> When I create new task (test) in scheduler with command :
> >> insert into db1:abc_test select * from db1:abc;
> >> I get this error in online:
> >> SCHAPI: [test 36-104] Error -23197 Database locale information mismatch.
> >> and no record are unloaded.
> >>
> >> Can you please help me with this issue?
> >> Thanks for your assistance.
> >>
> >>
> >>
> >
> *******************************************************************************
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >
> >
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2015.0.6172 / Virus Database: 4447/10855 - Release Date: 10/20/15
> >
> >
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• SCHAPI: Error -23197 Database locale information m
  Peter Lempochner -- Tuesday, 20 October 2015, at 1:33 p.m.
  • RE: SCHAPI: Error -23197 Database locale informati
    Alexandre Marini -- Tuesday, 20 October 2015, at 2:00 p.m.
    • Re: SCHAPI: Error -23197 Database locale infor....
      Peter Lempochner -- Tuesday, 20 October 2015, at 2:21 p.m.
      • Re: SCHAPI: Error -23197 Database locale infor....
        Art Kagel -- Tuesday, 20 October 2015, at 3:00 p.m.
      • RE: SCHAPI: Error -23197 Database locale infor....
        Alexandre Marini -- Tuesday, 20 October 2015, at 3:03 p.m.
        • RE: SCHAPI: Error -23197 Database locale infor....
          Paul Watson -- Tuesday, 20 October 2015, at 3:13 p.m.
  • Re: SCHAPI: Error -23197 Database locale informati
    Art Kagel -- Tuesday, 20 October 2015, at 2:57 p.m.
    • Re: SCHAPI: Error -23197 Database locale infor....
      Peter Lempochner -- Tuesday, 20 October 2015, at 6:59 p.m.
      • Re: SCHAPI: Error -23197 Database locale infor....
        John Miller iii -- Wednesday, 21 October 2015, at 2:22 a.m.
        • Re: SCHAPI: Error -23197 Database locale infor....
          Peter Lempochner -- Wednesday, 21 October 2015, at 3:10 a.m.
  • Re: SCHAPI: Error -23197 Database locale informati
    John Miller iii -- Tuesday, 20 October 2015, at 3:05 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.