| Below is the latest content available from this feed: 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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * | | | Subscribe to this feed | | You can subscribe to this RSS feed in a number of ways, including the following: Drag the orange RSS button into your News Reader Drag the URL of the RSS feed into your News Reader Cut and paste the URL of the RSS feed into your News Reader>v | |