Development Tools Forum

Re: Table issue coming up while compilation

Posted By: Ravi Pasupuleti
Date: Friday, 15 January 2010, at 11:36 a.m.

In Response To: Re: Table issue coming up while compilation (Art Kagel)

Owners are the same. It is 'informix'.

On Fri, Jan 15, 2010 at 9:21 PM, Art Kagel <art.kagel@gmail.com> wrote:

> Is your database logging mode mode ANSI? If so you may have to qualify the
> table name with the owner. It may be that the emp_hlth_ben table is owned
> by the database owner but the clientbenaso table is owned by someone else.
> So try:
>
> clientbenaso:"tableowner".codes.code_834
>
> 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 15, 2010 at 10:21 AM, Ravi Pasupuleti <rpasupul@gmail.com
> >wrote:
>
> > Yes....the pcp_no column does not throw an error.
> > the output of 'dbschema -d clientbenaso -t codes' shows the two columns
> > char_value and code_834. Yet the compiler is flagging that column
> code_834
> > is not present.
> > and 'dbschema -d clientbenaso -t emp_hlth_ben' does show the column
> pcp_no
> > and it is not an issue.
> >
> > For a change when the first statement in the sample code is changed to
> > 'Database clientbenaso", that is pointing to the database there the
> 'codes'
> > table is, there is no compiler error. But we want to use the statement '
> > database client' as we want to access the 'client' database too.
> >
> > Thank you,
> > Ravi P
> >
> > On Fri, Jan 15, 2010 at 6:28 PM, Keith Simmons <smiley73@googlemail.com
> > >wrote:
> >
> > > 2010/1/15 K CHANDRA <chandra.kala00@gmail.com>:
> > > > There is a table clientbenaso:codes it does have the columns
> char_value
> > > and
> > > > code_834. But the compiler is not recognizing the columns and
> flagging
> > > them
> > > as
> > > > not present. To explain the problem I wrote a small piece of code.
> > > >
> > > > database client
> > > > main
> > > > define
> > > >
> > > > pcp_no like clientbenaso:emp_hlth_ben.pcp_no,
> > > >
> > > > dtp01_0 like clientbenaso:codes.code_834,
> > > >
> > > > dtp01_1 like clientbenaso:codes.code_834
> > > > end main
> > > >
> > > > The compiler is flagging that code_834 is not a column in the
> database.
> > > >
> > > > Thank you,
> > > > Chandra Kala.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> *******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > > Chandra
> > >
> > > I assume the pcp_no column does not throw an error.
> > > What does the output of 'dbschema -d clientbenaso -t codes'
> > > and 'dbschema -d clientbenaso -t emp_hlth_ben' show?
> > >
> > > Keith
> > >
> > >
> > >
> > >
> >
> >
>
> *******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --
> > Ravi P
> > bayLogic Technologies
> >
> > --00163649918b6e9c6e047d358d99
> >
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --00151747621868d3cf047d35f848
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Ravi P
bayLogic Technologies

--001485f1dcd22e8897047d36993d

Messages In This Thread

• Table issue coming up while compilation
  K CHANDRA -- Friday, 15 January 2010, at 7:30 a.m.
  • Re: Table issue coming up while compilation
    Keith Simmons -- Friday, 15 January 2010, at 7:58 a.m.
    • Re: Table issue coming up while compilation
      Ravi Pasupuleti -- Friday, 15 January 2010, at 10:21 a.m.
      • Re: Table issue coming up while compilation
        Keith Simmons -- Friday, 15 January 2010, at 10:45 a.m.
        • Re: Table issue coming up while compilation
          Ravi Pasupuleti -- Friday, 15 January 2010, at 11:29 a.m.
          • Re: Table issue coming up while compilation
            Keith Simmons -- Friday, 15 January 2010, at 11:45 a.m.
          • Re: Table issue coming up while compilation
            Art Kagel -- Friday, 15 January 2010, at 12:47 p.m.
            • Re: Table issue coming up while compilation
              Ravi Pasupuleti -- Friday, 15 January 2010, at 1:09 p.m.
      • Re: Table issue coming up while compilation
        Art Kagel -- Friday, 15 January 2010, at 10:51 a.m.
        • Re: Table issue coming up while compilation
          Ravi Pasupuleti -- Friday, 15 January 2010, at 11:36 a.m.

Development Tools Forum is maintained by Administrator with WebBBS 5.12.