RSS Feed: IIUG Forum: Development Tools

Development Tools is a forum for discussion of Informix-related development tools and applications.

Re: Re-write INFORMIX-SQL app with FourGen CASE
Posted by: iiug@aubit.com (Mike Aubury) - Mon, 08 Mar 2010 06:55:08 EST
For reference, Aubit4GL runs on windows and has windows GUI clients :-)
We can also take InformixSQL forms and reports and convert them to 4GL so that
even these can run...

:-)

On Monday 08 March 2010 11:47:36 Art Kagel wrote:
> Informix SE does indeed run on Windows, however, although 4GL applications
> can access SE on windows or any other platform, it does not create apps
> that can run on windows (you would have to run the apps on Linux or Unix)
> so the FourGen tools will not help you. However, you can use Querix (
> www.querix.com) or FourJs (www.foujs.com) 4GL clones which are far more
> graphical and do support windows clients.
>
> 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 Sun, Mar 7, 2010 at 11:25 PM, FRANK ROTOLO <frank.pr@msn.com> wrote:
> > OK, so I have this legacy app developed with INFORMIX-SQL 2.10.06E for
> > MS-DOS
> > 5.0 and would like to migrate it to the Windows environment. The app
> > doesn't
> > require a TP monitor like IDS or multi-user capabilities and my client
> > wants
> > Windows, not a UNIX-variant OS, so:
> >
> > 1. Does INFORMIX-SE run under Windows?
> > 2. Can a rapid development tool like Gillani's FourGen CASE be used under
> >
> > Windows to access SE if SE runs under Windows.
> > 3. If #1 and/or #2 is not true, what alternative GUI/char-based Tools and
> >
> > SQL-based engines do you recommend?
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***
> * * * *
>
> >
>
> --00151747bf6ce98cfa048148a022
>
>
> * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ***
> * * * *
>

--
Mike Aubury

http://www.aubit.com/
Aubit Computing Ltd is registered in England and Wales, Number: 3112827
Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [584]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Re-write INFORMIX-SQL app with FourGen CASE
Posted by: art.kagel@gmail.com (Art Kagel) - Mon, 08 Mar 2010 06:47:39 EST
Informix SE does indeed run on Windows, however, although 4GL applications
can access SE on windows or any other platform, it does not create apps that
can run on windows (you would have to run the apps on Linux or Unix) so the
FourGen tools will not help you. However, you can use Querix (
www.querix.com) or FourJs (www.foujs.com) 4GL clones which are far more
graphical and do support windows clients.

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 Sun, Mar 7, 2010 at 11:25 PM, FRANK ROTOLO <frank.pr@msn.com> wrote:

> OK, so I have this legacy app developed with INFORMIX-SQL 2.10.06E for
> MS-DOS
> 5.0 and would like to migrate it to the Windows environment. The app
> doesn't
> require a TP monitor like IDS or multi-user capabilities and my client
> wants
> Windows, not a UNIX-variant OS, so:
>
> 1. Does INFORMIX-SE run under Windows?
> 2. Can a rapid development tool like Gillani's FourGen CASE be used under
>
> Windows to access SE if SE runs under Windows.
> 3. If #1 and/or #2 is not true, what alternative GUI/char-based Tools and
>
> SQL-based engines do you recommend?
>
>
>
>

>
>
>

--00151747bf6ce98cfa048148a022




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [583]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

AUTO: Claus Samuelsen on holiday (returning 22....
Posted by: CSA@dk.ibm.com (Claus Samuelsen) - Mon, 08 Mar 2010 04:01:34 EST
I am out of the office until 22-03-2010.

I will read mail seldom

Note: This is an automated response to your message "Re-write INFORMIX-SQL
app with FourGen CASE [581]" sent on 8/3/10 5:25:55.

This is the only notification you will receive while this person is away.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [582]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re-write INFORMIX-SQL app with FourGen CASE
Posted by: frank.pr@msn.com (FRANK ROTOLO) - Sun, 07 Mar 2010 23:25:59 EST
OK, so I have this legacy app developed with INFORMIX-SQL 2.10.06E for MS-DOS
5.0 and would like to migrate it to the Windows environment. The app doesn't
require a TP monitor like IDS or multi-user capabilities and my client wants
Windows, not a UNIX-variant OS, so:

1. Does INFORMIX-SE run under Windows?
2. Can a rapid development tool like Gillani's FourGen CASE be used under

Windows to access SE if SE runs under Windows.
3. If #1 and/or #2 is not true, what alternative GUI/char-based Tools and

SQL-based engines do you recommend?




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [581]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

AUTO: Claus Samuelsen on holiday (returning 01....
Posted by: CSA@dk.ibm.com (Claus Samuelsen) - Mon, 01 Feb 2010 10:01:55 EST
I am out of the office until 01-02-2010.

I will read mail seldom

Note: This is an automated response to your message "RUN command in 4GL
[578]" sent on 1/2/10 11:46:56.

This is the only notification you will receive while this person is away.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [580]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RUN command in 4GL
Posted by: vidyasri12b@gmail.com (SRI VIDYA) - Mon, 01 Feb 2010 06:21:13 EST
The following e-mail was sent to you via Development Tools Forum from SRI VIDYA (vidyasri12b@gmail.com) at IP address 121.243.35.202 (121.243.35.202.static-chennai.vsnl.net.in).



Re: RUN command in 4GL

Thanks Art. That is what i was exactly looking for.

For example,

m_input = " This is test mail"

Then i need,

m_output = "test mail"


This "test mail" should be in the variable instead of redirecting it into a file and i dont want to use substring for this because the input text is of not constant length



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: []

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: RUN command in 4GL
Posted by: art.kagel@gmail.com (Art Kagel) - Mon, 01 Feb 2010 06:08:11 EST
This is a classic, you have tried to accomplish something by some method
that doesn't work for you and you are asking us how to make this method
work. Instead, PLEASE, just post to us what the inputs are and what the end
result should be and we'll help you accomplish that. The answer may have
NOTHING to do with RUN!

I looks like what you want is to break up a string you have retrieved from
your database and put the results into one or more 4GL variables in your
program. Yes? Give us a specific example.

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 Mon, Feb 1, 2010 at 5:46 AM, SRI VIDYA <vidyasri12b@gmail.com> wrote:

> Hi all,
>
> Can you please help me with the following query?
> I am trying to use RUN command in 4GL.I have an input text in the variable
> m_input and using awk I have managed to separate the things i want. I am
> able
> to send this input variable to awk. I need to get the output of this in a
> variable instead of redirecting it into a file.
>
> The statement which I have tried is below. I need the output in a variable
> instead of redirecting it into a file?
>
> LET l_str= "abc\=awk '{print $2\" \"$3\"|\"$4}'",
>
> m_input clipped," ",
>
> "echo $abc > test.txt"
> RUN l_str
>
> Many thanks in advance
>
>
>
>

>
>
>

--001517475fd4bd3dbc047e87ffed




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [579]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RUN command in 4GL
Posted by: vidyasri12b@gmail.com (SRI VIDYA) - Mon, 01 Feb 2010 05:47:00 EST
Hi all,

Can you please help me with the following query?
I am trying to use RUN command in 4GL.I have an input text in the variable
m_input and using awk I have managed to separate the things i want. I am able
to send this input variable to awk. I need to get the output of this in a
variable instead of redirecting it into a file.

The statement which I have tried is below. I need the output in a variable
instead of redirecting it into a file?

LET l_str= "abc\=awk '{print $2\" \"$3\"|\"$4}'",

m_input clipped," ",

"echo $abc > test.txt"
RUN l_str

Many thanks in advance




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [578]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: rpasupul@gmail.com (Ravi Pasupuleti) - Fri, 15 Jan 2010 13:09:46 EST
Another column 'text_value' should be giving the "Not implemented yet"
error, as it is the lvarchar data type. As you said it does not work unless
we are in the current database .... not sure why the code_834 char(3) gives
there error, but I'll bet these are Informix bugs.
I was told we are not yet on 11.x
Since we are migrating to Informix 11.x, my assumption is that this problem
will resolve itself.

Thanks Art and Keith

Ravi P

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

> Not permissions. What are your server version and the data type of the
> codes column? Certain extended data types, including LVARCHAR, were not
> implemented for external access from another database or server until IDS
> 11.50!
>
> 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 15, 2010 at 11:29 AM, Ravi Pasupuleti <rpasupul@gmail.com
> >wrote:
>
> > 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
> > > >>
> > > >>
> > > >>
> > > >>
> > > >
> > >
> > >
> >
> >
>
>

> > > >>
> > > >>
> > > >>
> > > >
> > > > --
> > > > Ravi P
> > > > bayLogic Technologies
> > > >
> > > > --00163649918b6e9c6e047d358d99
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

> > > >
> > > >
> > > >
> > >
> > > 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
> > >
> > >
> > >
> > >
> >
> >
>
>

> > >
> > >
> > >
> >
> > --
> > Ravi P
> > bayLogic Technologies
> >
> > --001485f63198a1a193047d36817f
> >
> >
> >
> >
>
>

> >
> >
> >
>
> --000e0ce0091e1e1d5b047d379670
>
>
>
>

>
>
>

--
Ravi P
bayLogic Technologies

--001485f19a30fd1b23047d37e752




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [577]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 15 Jan 2010 12:47:03 EST
Not permissions. What are your server version and the data type of the
codes column? Certain extended data types, including LVARCHAR, were not
implemented for external access from another database or server until IDS
11.50!

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 15, 2010 at 11:29 AM, Ravi Pasupuleti <rpasupul@gmail.com>wrote:

> 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.
> > >> >
> > >> >
> > >> >
> > >>
> > >>
> > >
> >
> >
>
>

> > >> >
> > >> >
> > >> >
> > >> 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
> > >>
> > >>
> > >>
> > >>
> > >
> >
> >
>
>

> > >>
> > >>
> > >>
> > >
> > > --
> > > Ravi P
> > > bayLogic Technologies
> > >
> > > --00163649918b6e9c6e047d358d99
> > >
> > >
> > >
> >
> >
>
>

> > >
> > >
> > >
> >
> > 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
> >
> >
> >
> >
>
>

> >
> >
> >
>
> --
> Ravi P
> bayLogic Technologies
>
> --001485f63198a1a193047d36817f
>
>
>
>

>
>
>

--000e0ce0091e1e1d5b047d379670




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [576]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: smiley73@googlemail.com (Keith Simmons) - Fri, 15 Jan 2010 11:45:54 EST
2010/1/15 Ravi Pasupuleti <rpasupul@gmail.com>:
> 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.

>> >> >
>> >> >
>> >> 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
>> >>

>> >
>>
>> 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
>>

>
> --
> Ravi P
> bayLogic Technologies
>

dbaccess clientbenaso
table
info
'tab name'
priviliges

Will show permissions, however, seeing the error I suspect something
else, is codes a real table or is it a view or even a synonym to a
table, possibly in a third database or even a second instance?

I understand why you are defining temporary space 'like' existing
columns, but a more pragmatic approach (especially if you are getting
short of time) might be to define dtp01_0 as (say) CHAR(10) and just
run with that.

Keith




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [575]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: rpasupul@gmail.com (Ravi Pasupuleti) - Fri, 15 Jan 2010 11:36:04 EST
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.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

> > > >
> > > >
> > > >
> > > 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
> > >
> > >
> > >
> > >
> >
> >
>
>

> > >
> > >
> > >
> >
> > --
> > Ravi P
> > bayLogic Technologies
> >
> > --00163649918b6e9c6e047d358d99
> >
> >
> >
> >
>
>

> >
> >
> >
>
> --00151747621868d3cf047d35f848
>
>
>
>

>
>
>

--
Ravi P
bayLogic Technologies

--001485f1dcd22e8897047d36993d




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [574]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: rpasupul@gmail.com (Ravi Pasupuleti) - Fri, 15 Jan 2010 11:29:30 EST
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.
> >> >
> >> >
> >> >
> >>
> >>
> >
>
>

> >> >
> >> >
> >> >
> >> 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
> >>
> >>
> >>
> >>
> >
>
>

> >>
> >>
> >>
> >
> > --
> > Ravi P
> > bayLogic Technologies
> >
> > --00163649918b6e9c6e047d358d99
> >
> >
> >
>
>

> >
> >
> >
>
> 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
>
>
>
>

>
>
>

--
Ravi P
bayLogic Technologies

--001485f63198a1a193047d36817f




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [573]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 15 Jan 2010 10:51:07 EST
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.
> > >
> > >
> > >
> >
> >
>
>

> > >
> > >
> > >
> > 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
> >
> >
> >
> >
>
>

> >
> >
> >
>
> --
> Ravi P
> bayLogic Technologies
>
> --00163649918b6e9c6e047d358d99
>
>
>
>

>
>
>

--00151747621868d3cf047d35f848




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [572]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: smiley73@googlemail.com (Keith Simmons) - Fri, 15 Jan 2010 10:45:51 EST
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.
>> >
>> >
>> >
>>
>>
>

>> >
>> >
>> >
>> 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
>>
>>
>>
>>
>

>>
>>
>>
>
> --
> Ravi P
> bayLogic Technologies
>
> --00163649918b6e9c6e047d358d99
>
>
>

>
>
>

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




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [571]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: rpasupul@gmail.com (Ravi Pasupuleti) - Fri, 15 Jan 2010 10:21:12 EST
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.
> >
> >
> >
>
>

> >
> >
> >
> 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
>
>
>
>

>
>
>

--
Ravi P
bayLogic Technologies

--00163649918b6e9c6e047d358d99




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [570]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Table issue coming up while compilation
Posted by: smiley73@googlemail.com (Keith Simmons) - Fri, 15 Jan 2010 07:58:25 EST
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.
>
>
>

>
>
>
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




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [569]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Table issue coming up while compilation
Posted by: chandra.kala00@gmail.com (K CHANDRA) - Fri, 15 Jan 2010 07:30:37 EST
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.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [568]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: 4GL and Serial Columns
Posted by: smiley73@googlemail.com (Keith Simmons) - Fri, 08 Jan 2010 05:48:00 EST
Apologies to all, closer examination revealed an awk command on the
dev machine was converting the dos file to unix and appending
delimiter and zero. On the live machine the dos2unix command was being
used with no appended characters. Both were behaving correctly
according to what was being given to them, a serial field must have
zero or an integer supplied to it.

Keith

2010/1/8 Jonathan Leffler <jleffler.iiug@gmail.com>:
> On Thu, Jan 7, 2010 at 02:27, Keith Simmons <smiley73@googlemail.com> wrote:
>
>> IDS 9.40.FC6 (I know, we're in the process of upgrading) running on
>> AIX 5.3 and using r4gl 7.32.FC3.
>> On our test box a piece of 4GL code is creating a temp table with
>> several columns the last of which is a serial column. It then executes
>> a 'LOAD FROM .... INSERT INTO 'temp table' to load data from a system
>> file. Thisfile has a match for match set of delimited data to insert
>> except for the final serial field which is not present. Contrary to
>> expectations this load is successful. Migrating the code to our live
>> box (same IDS, O/S and 4GL) the LOAD fails with error 846 - Not enough
>> columns unless the serial column is added. This is the same whether
>> the 4gi is copied or whether the code is recompiled. As far as I can
>> tell the environments are identical. Any one seen this behaviour and
>> can point me towards an environment or onconfig setting that might
>> produce this difference?
>>
>
> There shouldn't be a way for a difference in configuration to make one
> system work and the other fail - doubly not with otherwise identical
> software. I believe that when you look carefully, you'll find there is a
> difference. I'm just not sure which of the two systems is behaving
> correctly off hand.
>
> --
> Jonathan Leffler #include <disclaimer.h>
> Email: jleffler@earthlink.net, jleffler@us.ibm.com
> Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
> "Blessed are we who can laugh at ourselves, for we shall never cease to be
> amused."
> NB: Please do not use this email for correspondence.
> I don't necessarily read it every week, even.
> Samuel
> Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>
> - "I'm willing to admit that I may not always be right, but I am never
> wrong."
>
> --000e0cd1388cb13e3d047ca279b5
>
>
>

>
>
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [567]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: 4GL and Serial Columns
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Fri, 08 Jan 2010 02:53:01 EST
On Thu, Jan 7, 2010 at 02:27, Keith Simmons <smiley73@googlemail.com> wrote:

> IDS 9.40.FC6 (I know, we're in the process of upgrading) running on
> AIX 5.3 and using r4gl 7.32.FC3.
> On our test box a piece of 4GL code is creating a temp table with
> several columns the last of which is a serial column. It then executes
> a 'LOAD FROM .... INSERT INTO 'temp table' to load data from a system
> file. Thisfile has a match for match set of delimited data to insert
> except for the final serial field which is not present. Contrary to
> expectations this load is successful. Migrating the code to our live
> box (same IDS, O/S and 4GL) the LOAD fails with error 846 - Not enough
> columns unless the serial column is added. This is the same whether
> the 4gi is copied or whether the code is recompiled. As far as I can
> tell the environments are identical. Any one seen this behaviour and
> can point me towards an environment or onconfig setting that might
> produce this difference?
>

There shouldn't be a way for a difference in configuration to make one
system work and the other fail - doubly not with otherwise identical
software. I believe that when you look carefully, you'll find there is a
difference. I'm just not sure which of the two systems is behaving
correctly off hand.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
Samuel
Goldwyn<http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>
- "I'm willing to admit that I may not always be right, but I am never
wrong."

--000e0cd1388cb13e3d047ca279b5




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [566]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *