All the competent people have left my work place and I'm stuck with
administering Informix 940uc3. In my attempt to gain understanding I
installed SQuirreL and have it working. However, my limited knowledge
forces me to create an Alias for each database_name for each
INFORMIXSERVER, of which I have 4. Then each INFORMIXSERVER has 10's
of database_name's so I end up with 60 some alias' before it is all
done.

Is there a way for me to set up a single Alias for each
INFORMIXSERVER and then issue an sql command that will select the
database_name that I need to administer?

prichard@blm.gov wrote:
> All the competent people have left my work place and I'm stuck with
> administering Informix 940uc3. In my attempt to gain understanding I
> installed SQuirreL and have it working. However, my limited knowledge
> forces me to create an Alias for each database_name for each
> INFORMIXSERVER, of which I have 4. Then each INFORMIXSERVER has 10's
> of database_name's so I end up with 60 some alias' before it is all
> done.
>
> Is there a way for me to set up a single Alias for each
> INFORMIXSERVER and then issue an sql command that will select the
> database_name that I need to administer?

Why use an alias? Why not just "connect to db@instance_name"?

Madison Pruet wrote:
> prichard@blm.gov wrote:
>> All the competent people have left my work place and I'm stuck with
>> administering Informix 940uc3. In my attempt to gain understanding I
>> installed SQuirreL and have it working. However, my limited knowledge
>> forces me to create an Alias for each database_name for each
>> INFORMIXSERVER, of which I have 4. Then each INFORMIXSERVER has 10's
>> of database_name's so I end up with 60 some alias' before it is all
>> done.
>>
>> Is there a way for me to set up a single Alias for each
>> INFORMIXSERVER and then issue an sql command that will select the
>> database_name that I need to administer?
>
> Why use an alias? Why not just "connect to db@instance_name"?
>

I believe an "alias" in the Squirrel context means a connection definition...
From what I recall you can "jump" from database into another database because
they'll be showed in the left tree view... But I may be wrong... I don't see
Squirrel for a long time...

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

Thank you for the suggestion. I'm not sure how to create a saved
connection without using an Alias. I'll have to investigate that.

On the SQL tab in SQuirreL I entered your suggested command

"connect to copytrans@almrs_mtsp_soc"

but I get a syntax error, even in dbaccess I get the syntax error.

I know that copytrans is another database_name and that almrs_mtsp_soc
is the INFORMIXSERVER.

I'm missing something basic. Sorry to be such a beginner. I've hit
IBM's web site with the manual and am trying to improve my syntax
knowledge.

Thank you for answering so quickly.

I tried "jumping" using the Catalog pull down, but I get the error:

Error loading object type UDT Type. Error: java.sql.SQLException:
Another routine (mode_decode) with same signature already exists in
database.. See SQuirreL Logs for stackttrace.

I looked at the SQuirreL log and can't decipher a cause.

On Dec 14, 5:58 pm, "prich...@blm.gov" <prich...@blm.gov> wrote:
> Thank you for answering so quickly.
>
> I tried "jumping" using the Catalog pull down, but I get the error:
>
> Error loading object type UDT Type. Error: java.sql.SQLException:
> Another routine (mode_decode) with same signature already exists in
> database.. See SQuirreL Logs for stackttrace.
>
> I looked at the SQuirreL log and can't decipher a cause.

Let me suggest that IDS 9.4 comes with a license for basic level of
AGS's Server Studio. That will allow you to administer much of the
database level work you want to do and since it is purpose built for
Informix it will show you all of your servers and all of the databases
in each for you to pick though in the navigator window. Server Studio
also provides an SQL editor/browser, a Stored Procedure debugger,
database schema (DDL) development and diagramming, and many other
features.

You probably have Server Studio v5 installed already, but you can
download Server Studio v6.1 (the latest) from AGS's web site and use
the existing license file. You can also, if you decide you need to,
license additional functionality and even the AGS Sentinel monitoring
product which works with Server Studio to provide monitoring and
alerts for your servers. Instead of using a generic product, check it
out.

Art S. Kagel

A SQuirreL snapshot release with this fixed has been made available today
at:
https://sourceforge.net/project/show...ease_id=565264

Please post future SQuirreL issues to the Users mailing list at:
https://sourceforge.net/projects/squirrel-sql

Regards,
Doug Lawry

<prichard@blm.gov> wrote:
>
> Thank you for answering so quickly.
>
> I tried "jumping" using the Catalog pull down, but I get the error:
>
> Error loading object type UDT Type. Error: java.sql.SQLException:
> Another routine (mode_decode) with same signature already exists in
> database.. See SQuirreL Logs for stackttrace.
>
> I looked at the SQuirreL log and can't decipher a cause.