Development Tools Forum

Re: Table issue coming up while compilation

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

In Response To: Re: Table issue coming up while compilation (Keith Simmons)

Connected to 'client' with dbaccess and did
select * from clientbenaso:codes
Got '999: Not implemented yet' as response
and also did
select * from clientbenaso:emp_hlth_ben and got the result set fine. So as
you said Keith, a permissions issue !! How do I check the difference in
permissions ?

Ravi P

On Fri, Jan 15, 2010 at 9:15 PM, Keith Simmons <smiley73@googlemail.com>wrote:

> 2010/1/15 Ravi Pasupuleti <rpasupul@gmail.com>:
> > 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.
> >
> >
>
> Permissions?? Are the permissions on the two tables identical?
> If you are connected to 'client' using dbaccess can you 'select * from
> clientbenaso:codes' and see all columns?
>
> Keith
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Ravi P
bayLogic Technologies

--001485f63198a1a193047d36817f

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.