var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Connecting to a particular schema using ODBC.
Is it possible to configure a DSN Connection to connect to a particular Schema.
DB2 is the database and i want to connect to a particular schema.
You don't connect to a schema; you connect to a database.
Please explain in detail what are you trying to achieve.
I've a database called as "SAMPLE" which is in Schema "Test".
I've created a DSN for this database using a login "db2admin".
Whenever I try to connect to this database, the schema is defaulted is "db2admin". To overcome this, the schema name has to be mentioned in the code which is accessing the database.
To avoid this hardcoding of schema name in the code, I'm looking for something like a parameter in DSN where in i can mention a default schema name.
I've tried using the CLISCHEMA option but it does not work.
Both the client and the database reside on windows env.
It is a good development practice to specify schema names in your SQL.
Originally Posted by yadu
If you insist on doing wrong things you can either issue SET CURRENT SCHEMA statement or specify "CurrentSchema=whatever" in db2cli.ini
I added the schema name in db2cli.ini file.
The results were a bit odd.
Though I did not get any errors, the resulting query did not return any of the data from the table.
Can you tell me what could be the reason for this?
PS: The table is having valid data which satisfies the query condition.