Oninit cdi / Archive
Talk to an expert →

SQuirreL and Informix

Posted in 2007

Topics: Installation, Setup & Upgrades

prichard@blm.gov — — source: Usenet: comp.databases.informix

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?

↪ replying to prichard@blm.gov
Madison Pruet — — source: Usenet: comp.databases.informix

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

↪ replying to Madison Pruet
Fernando Nunes — — source: Usenet: comp.databases.informix

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

↪ replying to Madison Pruet
prichard@blm.gov — — source: Usenet: comp.databases.informix

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.

↪ replying to Fernando Nunes
prichard@blm.gov — — source: Usenet: comp.databases.informix

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.