Save 
Join IIUG
 for   
 

Informix News
29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read
29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read
28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read
28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read
09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read
08 April 08 - IT-Director.com - Informix seeks developers... Read
18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read
17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read
17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read
16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read
16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read
28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read
27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read
14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read
14 June 07 - eChannelLine - IBM expands scope for IDS... Read
14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read
13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read
12 June 07 - IBM - IDS 11 release announcement (pdf)... Read
12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read
12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read
12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read
12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read
12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read
12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read
12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read
12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read
12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read
12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read
12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - golem.de - Informix 11 vorgestellt... Read
12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read
12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read
12 June 07 - Heise - IBM gibt Informix 11 frei... Read
25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read
18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read
18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read
7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read


RSS Feed: IIUG Forum: Admin Tools

More IIUG RSS Feeds

The admin-tools forum is for discussing the Informix database administration tools. These are primarily the Informix Server Administrator (ISA), and Server Studio from AGS.


URL: http://www.iiug.org/rss/admin-tools.rss

Below is the latest content available from this feed:

Re: DBStudio for Informix FREE
Posted by: jviemont@courts.az.gov (Jeff Viemont) - Thu, 07 Aug 2008 18:05:30 EDT
The following e-mail was sent to you via Admin Tools Forum from Jeff Viemont (jviemont@courts.az.gov) at IP address 67.131.20.93 (67-131-20-93.supreme.sp.state.az.us).



Re: DBStudio for Informix FREE

Does DBStudio work with Informix versions 7 and 10? If so, can you send me a copy???



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

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

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

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

Re: server studio license experied
Posted by: yunyaoqu@gmail.com (FRANK) - Wed, 30 Jul 2008 14:01:01 EDT
This is a civilized world and IP is respected in most of the countries
including China...

CHUAN's misusing English word "BYPASS" here was a terrible
misunderstood! Keep learning English!

But " Only from China" is really disgusting.....

On Wed, Jul 30, 2008 at 11:14 AM, Ian Michael Gumby <im_gumby@hotmail.com>
wrote:

> > To: admin-tools@iiug.org> From: obnoxio@serendipita.com> Subject: Re:
> server
> studio license experied [3192]> Date: Wed, 30 Jul 2008 09:05:57 -0400> >
> CHUAN
> LU said: > > Hi: > > > > One of informix partner's server studio licnese
> experied, the partner has > > no > > budget to buy such kind of tools,do
> anybody know how to bypass this > > problem or > > propose another tools
> that
> could debug informix store procedure ? Do > > informix > > has plan to
> delevop
> a tools free for informix user and partner? > > So IBM is now asking the
> world
> + dog how to subvert the licensing for an > IBM Business Partner's product?
> >
> > Disgusting! I wouldn't be surprised if the BP asked for your head for >
> this. I'm pretty sure you can be sacked for behaving in such an unethical >
> way and you should be. > >
> Oh please, IBM won't do anything over this. I've seen Client Reps do worse
> and
> have nothing happen.
> Litterally a known termination issue and management turned a blind eye.
>
> Its a culture thing. I guess one could say that the customer doesn't have
> the
> money because they're too busy overpaying for IBM? :-P
>
> Sorry I couldn't resist.
>
> Maybe they should learn how to write stored procedures so that they don't
> need
> to be debugged?
> (That's much easier that writing a device driver using cat. )
> But hey! What do I know? I'll cop to writing device drivers using vi and or
> ed, but not cat.
>
> -G
>
> _________________________________________________________________
> Keep your kids safer online with Windows Live Family Safety.
>
>
>
http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_family_safety_072008
>
>
>
>

>
>
>
>




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

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

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

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

RE: server studio license experied
Posted by: im_gumby@hotmail.com (Ian Michael Gumby) - Wed, 30 Jul 2008 11:14:47 EDT
> To: admin-tools@iiug.org> From: obnoxio@serendipita.com> Subject: Re: server
studio license experied [3192]> Date: Wed, 30 Jul 2008 09:05:57 -0400> > CHUAN
LU said: > > Hi: > > > > One of informix partner's server studio licnese
experied, the partner has > > no > > budget to buy such kind of tools,do
anybody know how to bypass this > > problem or > > propose another tools that
could debug informix store procedure ? Do > > informix > > has plan to delevop
a tools free for informix user and partner? > > So IBM is now asking the world
+ dog how to subvert the licensing for an > IBM Business Partner's product? >
> Disgusting! I wouldn't be surprised if the BP asked for your head for >
this. I'm pretty sure you can be sacked for behaving in such an unethical >
way and you should be. > >
Oh please, IBM won't do anything over this. I've seen Client Reps do worse and
have nothing happen.
Litterally a known termination issue and management turned a blind eye.

Its a culture thing. I guess one could say that the customer doesn't have the
money because they're too busy overpaying for IBM? :-P

Sorry I couldn't resist.

Maybe they should learn how to write stored procedures so that they don't need
to be debugged?
(That's much easier that writing a device driver using cat. )
But hey! What do I know? I'll cop to writing device drivers using vi and or
ed, but not cat.

-G

_________________________________________________________________
Keep your kids safer online with Windows Live Family Safety.

http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_family_safety_072008




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

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

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

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

Re: server studio license
Posted by: luchuan@cn.ibm.com (CHUAN LU) - Wed, 30 Jul 2008 09:50:28 EDT
Hi:

My starting point is to let them use this tools well, I propose this tools to
them,so they have some quesiton and asked me for help, my expression is not
very well for this question I feel,I should not use the word 'bypass',very
sorry.I get help from IIUG before and like this website also, so I will told
the partner they need to buy the offical license if they want to continue use
it.




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

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

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

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

Re: server studio license experied
Posted by: obnoxio@serendipita.com (Obnoxio The Clown) - Wed, 30 Jul 2008 09:05:59 EDT
CHUAN LU said:
> Hi:
>
> One of informix partner's server studio licnese experied, the partner has
> no
> budget to buy such kind of tools,do anybody know how to bypass this
> problem or
> propose another tools that could debug informix store procedure ? Do
> informix
> has plan to delevop a tools free for informix user and partner?

So IBM is now asking the world + dog how to subvert the licensing for an
IBM Business Partner's product?

Disgusting! I wouldn't be surprised if the BP asked for your head for
this. I'm pretty sure you can be sacked for behaving in such an unethical
way and you should be.

--
Bye now,
Obnoxio

http://obotheclown.blogspot.com/




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

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

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

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

RE: server studio license experied
Posted by: im_gumby@hotmail.com (Ian Michael Gumby) - Wed, 30 Jul 2008 08:49:27 EDT
Only from China.
No respect for IP. :-(

And asking all of Informix world rather than internal to IBM.

Kinda says it all.

Maybe that's why IBM IM's management are focusing on Asia Pac and ignoring the
other major problems?

> To: admin-tools@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: server studio license experied [3190]
> Date: Wed, 30 Jul 2008 06:51:26 -0400
>
> AGS's Server Studio is the only Informix Stored Procedure debugger
> available. It would be illegal to bypass AGS's licensing requirements.
>
> Art
>
> On Wed, Jul 30, 2008 at 5:43 AM, CHUAN LU <luchuan@cn.ibm.com> wrote:
>
> > Hi:
> >
> > One of informix partner's server studio licnese experied, the partner has
> > no
> > budget to buy such kind of tools,do anybody know how to bypass this
problem
> > or
> > propose another tools that could debug informix store procedure ? Do
> > informix
> > has plan to delevop a tools free for informix user and partner?
> >
> >
> >
> >
>

> >
> >
> >
> >
>
> --
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do those
> opinions reflect those of other individuals affiliated with any entity with
> which I am affiliated nor those of the entities themselves.
>
>
>

>
>
>

_________________________________________________________________
Keep your kids safer online with Windows Live Family Safety.

http://www.windowslive.com/family_safety/overview.html?ocid=TXT_TAGLM_WL_family_safety_072008




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

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

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

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

Re: server studio license experied
Posted by: art.kagel@gmail.com (Art Kagel) - Wed, 30 Jul 2008 06:51:26 EDT
AGS's Server Studio is the only Informix Stored Procedure debugger
available. It would be illegal to bypass AGS's licensing requirements.

Art

On Wed, Jul 30, 2008 at 5:43 AM, CHUAN LU <luchuan@cn.ibm.com> wrote:

> Hi:
>
> One of informix partner's server studio licnese experied, the partner has
> no
> budget to buy such kind of tools,do anybody know how to bypass this problem
> or
> propose another tools that could debug informix store procedure ? Do
> informix
> has plan to delevop a tools free for informix user and partner?
>
>
>
>

>
>
>
>

--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.




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

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

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

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

server studio license experied
Posted by: luchuan@cn.ibm.com (CHUAN LU) - Wed, 30 Jul 2008 05:43:57 EDT
Hi:

One of informix partner's server studio licnese experied, the partner has no
budget to buy such kind of tools,do anybody know how to bypass this problem or
propose another tools that could debug informix store procedure ? Do informix
has plan to delevop a tools free for informix user and partner?




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

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

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

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

Re: OAT missing module pdo_informix in windows
Posted by: lwchan@us.ibm.com (LEO CHAN) - Mon, 28 Jul 2008 07:32:35 EDT
Hello.

Do you have PHP/XAMPP/ZendCore installed on your machine?

If you have those installed, it is possible that they have conflict with OAT.
You have to uninstall those before running the OAT installer.

OAT automated installer bundles with PHP. It is not recommended to have
multiple instances of PHP installed on the machine because it will conflict
with each other.

Leo




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

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

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

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

Re: show view
Posted by: fabasard@bikerider.com (MARK DURSHIMER) - Fri, 25 Jul 2008 12:12:24 EDT
THANK YOU THANK YOU THANK YOU

WE GOT IT :)

I want to say thank you to everyone!




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

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

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

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

Re: show view
Posted by: ptang83@yahoo.com (ptang83@yahoo.com) - Fri, 25 Jul 2008 11:45:31 EDT
Mark,

-ss option is not necessary to display the view schema. "-ss" is for server
specific info such as fragmentation, storage, etc...

--- On Fri, 7/25/08, MARK DURSHIMER <fabasard@bikerider.com> wrote:

> From: MARK DURSHIMER <fabasard@bikerider.com>
> Subject: Re: show view [3183]
> To: admin-tools@iiug.org
> Date: Friday, July 25, 2008, 9:55 AM
> I really appreciate the help. I'm missing something and
> I hope you can lead me
> in the correct direction.
>
> This is the output from the CLI:
>
> # dbschema -d atlanta -s <username removed> -p
> <password removed> -t
> vwloadout2despatch -ss
>
> DBSCHEMA Schema Utility INFORMIX-SQL Version 7.25.UC6
> Copyright (C) Informix Software, Inc., 1984-1997
> Software Serial Number AAD#J382018
> -956 - Client host or user (root@atlanta) is not trusted by
> the server.
> 2 - No such file or directory
>
> It looks like a permission thing. Usually I connect to the
> informix database
> using a program called WinSQL. We select the ODBC
> connection to the database,
> enter the username and password. Then we are able to run
> SQL queries.
>
> Thanks!
>
>
>

>
> Forum Note: Use "Reply" to post a response in
> the discussion forum.




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

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

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

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

Re: show view
Posted by: ptang83@yahoo.com (ptang83@yahoo.com) - Fri, 25 Jul 2008 11:29:16 EDT
Hi Mark
Hi Mark

Here are couple issues in your command.

1. You must be the DBA or have the Connect or Resource privilege for the
database before you can run dbschema on it.

2. Dbschema doesn't take user name or password.

3. It looks like "atlanta" is your host name. You should put database name of
"-d" flag.

Thanks!

--- On Fri, 7/25/08, MARK DURSHIMER <fabasard@bikerider.com> wrote:

> From: MARK DURSHIMER <fabasard@bikerider.com>
> Subject: Re: show view [3183]
> To: admin-tools@iiug.org
> Date: Friday, July 25, 2008, 9:55 AM
> I really appreciate the help. I'm missing something and
> I hope you can lead me
> in the correct direction.
>
> This is the output from the CLI:
>
> # dbschema -d atlanta -s <username removed> -p
> <password removed> -t
> vwloadout2despatch -ss
>
> DBSCHEMA Schema Utility INFORMIX-SQL Version 7.25.UC6
> Copyright (C) Informix Software, Inc., 1984-1997
> Software Serial Number AAD#J382018
> -956 - Client host or user (root@atlanta) is not trusted by
> the server.
> 2 - No such file or directory
>
> It looks like a permission thing. Usually I connect to the
> informix database
> using a program called WinSQL. We select the ODBC
> connection to the database,
> enter the username and password. Then we are able to run
> SQL queries.
>
> Thanks!
>
>
>

>
> Forum Note: Use "Reply" to post a response in
> the discussion forum.




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

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

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

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

Re: show view
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 25 Jul 2008 11:11:08 EDT
It looks like you are trying to run this as user root. If the IDS server is
not local, it is rare for the root user to be 'trusted' on other machines.
Try you own login, the login you are passing to dbschema, or the informix
user login.

Art

On Fri, Jul 25, 2008 at 10:55 AM, MARK DURSHIMER <fabasard@bikerider.com>
wrote:

> I really appreciate the help. I'm missing something and I hope you can lead
> me
> in the correct direction.
>
> This is the output from the CLI:
>
> # dbschema -d atlanta -s <username removed> -p <password removed> -t
> vwloadout2despatch -ss
>
> DBSCHEMA Schema Utility INFORMIX-SQL Version 7.25.UC6
> Copyright (C) Informix Software, Inc., 1984-1997
> Software Serial Number AAD#J382018
> -956 - Client host or user (root@atlanta) is not trusted by the server.
> 2 - No such file or directory
>
> It looks like a permission thing. Usually I connect to the informix
> database
> using a program called WinSQL. We select the ODBC connection to the
> database,
> enter the username and password. Then we are able to run SQL queries.
>
> Thanks!
>
>
>
>

>
>
>
>

--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.




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

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

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

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

Re: show view
Posted by: fabasard@bikerider.com (MARK DURSHIMER) - Fri, 25 Jul 2008 10:55:03 EDT
I really appreciate the help. I'm missing something and I hope you can lead me
in the correct direction.

This is the output from the CLI:

# dbschema -d atlanta -s <username removed> -p <password removed> -t
vwloadout2despatch -ss

DBSCHEMA Schema Utility INFORMIX-SQL Version 7.25.UC6
Copyright (C) Informix Software, Inc., 1984-1997
Software Serial Number AAD#J382018
-956 - Client host or user (root@atlanta) is not trusted by the server.
2 - No such file or directory

It looks like a permission thing. Usually I connect to the informix database
using a program called WinSQL. We select the ODBC connection to the database,
enter the username and password. Then we are able to run SQL queries.

Thanks!




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

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

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

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

Re: show view
Posted by: jnebab@idealcut.com (June Nebab) - Fri, 25 Jul 2008 10:51:25 EDT
Use 'dbschema' to view the sql of a view, no pun intended.

On Fri, Jul 25, 2008 at 10:16 AM, MARK DURSHIMER <fabasard@bikerider.com>
wrote:

> Hi, I would like ot know if there is a way to display the SQL source of a
> view
> once the view has been created. We are running two informix servers with
> WINSQL Lite and I have a view on one of the servers (I did not create the
> view) and would like to replicate a similar view on the other server, but
> need
> to know the syntax of how the view was created. Any help would be greatly
> appreciated. I had hoped that there might be a SHOW VIEW <view name>, or
> something to that effect.
>
>
>
>

>
>
>
>




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

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

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

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

Re: show view
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 25 Jul 2008 10:26:29 EDT
Run:

dbschema -d <databasename> -t <table, view, or synonym name> -ss

That will print out the SQL DDL definition of any table-like object that's
not a system catalog or pseudo table (to see the DDL for those you'll have
to download and compile my dbschema replacement utility, myschema, which is
contained in the package utils2_ak in the IIUG Software Repository or from
the Oninit website at: www.oninit.com/utils - select myschema the press the
VIEW button at the bottom of the README output). Myschema will display DDL
for system catalog and pseudo tables.

Art

On Fri, Jul 25, 2008 at 10:16 AM, MARK DURSHIMER <fabasard@bikerider.com>
wrote:

> Hi, I would like ot know if there is a way to display the SQL source of a
> view
> once the view has been created. We are running two informix servers with
> WINSQL Lite and I have a view on one of the servers (I did not create the
> view) and would like to replicate a similar view on the other server, but
> need
> to know the syntax of how the view was created. Any help would be greatly
> appreciated. I had hoped that there might be a SHOW VIEW <view name>, or
> something to that effect.
>
>
>
>

>
>
>
>

--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.




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

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

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

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

RE: show view
Posted by: jacques.lapeire@siemens.com (Lapeire, Jacques) - Fri, 25 Jul 2008 10:25:06 EDT
Hi,

maybe there is a shorter or better way but you can do it by running the
dbschema with the -ss option
Your output sql-file will contain the view.

Best regards,
Jacques Lapeire

-----Original Message-----
From: admin-tools-bounces@iiug.org [mailto:admin-tools-bounces@iiug.org]
On Behalf Of MARK DURSHIMER
Sent: vrijdag 25 juli 2008 16:16
To: admin-tools@iiug.org
Subject: show view [3179]

Hi, I would like ot know if there is a way to display the SQL source of
a view
once the view has been created. We are running two informix servers with

WINSQL Lite and I have a view on one of the servers (I did not create
the
view) and would like to replicate a similar view on the other server,
but need
to know the syntax of how the view was created. Any help would be
greatly
appreciated. I had hoped that there might be a SHOW VIEW <view name>, or

something to that effect.

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





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

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

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

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

show view
Posted by: fabasard@bikerider.com (MARK DURSHIMER) - Fri, 25 Jul 2008 10:16:21 EDT
Hi, I would like ot know if there is a way to display the SQL source of a view
once the view has been created. We are running two informix servers with
WINSQL Lite and I have a view on one of the servers (I did not create the
view) and would like to replicate a similar view on the other server, but need
to know the syntax of how the view was created. Any help would be greatly
appreciated. I had hoped that there might be a SHOW VIEW <view name>, or
something to that effect.




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

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

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

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

Re: OAT missing module pdo_informix in windows
Posted by: oskhan@i2cinc.com (OMER KHAN) - Fri, 25 Jul 2008 03:18:53 EDT
hello
i amd using OAT automated GUI installer




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

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

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

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

RE: Artur-P011321 Wygonowski est absent(e).
Posted by: Nick.Lello@nielsen.com (Lello, Nick) - Thu, 24 Jul 2008 10:47:02 EDT
Absent in mind as well as body ?

-----Original Message-----
From: admin-tools-bounces@iiug.org [mailto:admin-tools-bounces@iiug.org]
On Behalf Of artur.wygonowski@pl.michelin.com
Sent: 24 July 2008 15:32
To: admin-tools@iiug.org
Subject: Artur-P011321 Wygonowski est absent(e). [3176]

DQpOaWUgYsSZZHppZSBtbmllIHcgcHJhY3kgb2QgIDIwMDgtMDctMTkgaSBuaWUgd3LDs2PE
mSBw
cnplZCAyMDA4LTA4LTExLg0KDQpXIGRuaWFjaCAyMS4wNy0xMC4wOCAgamVzdGVtIG5hIHVy
bG9w
aWUuIE9kcG93aWVtIHBvIHBvd3JvY2llLiBXIHBpbG55Y2gNCnNwcmF3YWNoIHByb3N6xJkg
a29u
dGFrdG93YcSHIHNpxJkgeiBUb21hc3plbSBNb2RyennFhHNraW0gdGVsLiA0OTkwLiBXDQpz
cHJh
d2FjaCBTZWN1cml0eSBCb3gsIERETSBrb250YWt0IE1hY2llaiBKYW5pdWsgdGVsLiA0MjQ0
Lg0K
DQpEZSAyMS4wNyBhIDEwLjA4IEplIHN1aXMgZW4gY29uZ2UuIEplIHLDqXBvbmRyYWkgw6Ag
dm90
cmUgbWVzc2FnZSBkw6hzIG1vbg0KcmV0b3VyLg0KDQpTaW5jZSAyMXRoIG9mIEp1bHkgdGls
bCAx
MHRoIG9mIEF1Z3VzdCBJIGFtIG9uIGhvbGlkYXlzLiBJIHdpbGwgYW5zd2VyIHRvDQpZb3Ug
YWZ0
ZXIgbXkgcmV0dXJuLg==

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





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

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

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

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

Absent in mind as well as body ?

-----Original Message-----
From: admin-tools-bounces@iiug.org [mailto:admin-tools-bounces@iiug.org]
On Behalf Of artur.wygonowski@pl.michelin.com
Sent: 24 July 2008 15:32
To: admin-tools@iiug.org
Subject: Artur-P011321 Wygonowski est absent(e). [3176]

DQpOaWUgYsSZZHppZSBtbmllIHcgcHJhY3kgb2QgIDIwMDgtMDctMTkgaSBuaWUgd3LDs2PE
mSBw
cnplZCAyMDA4LTA4LTExLg0KDQpXIGRuaWFjaCAyMS4wNy0xMC4wOCAgamVzdGVtIG5hIHVy
bG9w
aWUuIE9kcG93aWVtIHBvIHBvd3JvY2llLiBXIHBpbG55Y2gNCnNwcmF3YWNoIHByb3N6xJkg
a29u
dGFrdG93YcSHIHNpxJkgeiBUb21hc3plbSBNb2RyennFhHNraW0gdGVsLiA0OTkwLiBXDQpz
cHJh
d2FjaCBTZWN1cml0eSBCb3gsIERETSBrb250YWt0IE1hY2llaiBKYW5pdWsgdGVsLiA0MjQ0
Lg0K
DQpEZSAyMS4wNyBhIDEwLjA4IEplIHN1aXMgZW4gY29uZ2UuIEplIHLDqXBvbmRyYWkgw6Ag
dm90
cmUgbWVzc2FnZSBkw6hzIG1vbg0KcmV0b3VyLg0KDQpTaW5jZSAyMXRoIG9mIEp1bHkgdGls
bCAx
MHRoIG9mIEF1Z3VzdCBJIGFtIG9uIGhvbGlkYXlzLiBJIHdpbGwgYW5zd2VyIHRvDQpZb3Ug
YWZ0
ZXIgbXkgcmV0dXJuLg==

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





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

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

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

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

 
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