• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Set current sqlid

 
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm using WAS5.1 & DB2.
I want to set the current SQL id so that I don't have to prefix all my table names with the Table creator.
I'm thinking I could set up the Id as an environment variable and use this in a 'SET CURRENT SQLID' statement that I execute immediately prior to each applicaiton SQL statement, but..
Is there a better way to do this?
Can I set something in a config file to get WAS to use a particular SQLID for my app?

Thanks in advance,
Louise
 
reply
    Bookmark Topic Watch Topic
  • New Topic