Questions tagged [environment-variables]
The environment-variables tag has no usage guidance.
14
questions
4
votes
1answer
13k views
How do I map SSIS 2012 Package Variables to Parameters?
I have created multiple packages that use variables to assign Connection Manager Expressions such as Connection String. However in the new SQL 2012 Project Deployment Model I don't seem to be able to ...
3
votes
1answer
3k views
MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1
I've set ft_min_word_len = 1 to my.cnf file, also SHOW VARIABLES LIKE 'ft_min_word%' displays ft_min_word_len as 1. Then I've reloaded all database tables and it still doesn't search for one character ...
3
votes
1answer
412 views
How can I use an environment variable in a Postgres function?
Let's say I have a windows user environment variable SOME_STRING.
Is it possible to use its value in a PL/pgSQL function?
If not, do I need to use an untrusted language (like PL/pythonu) or can I ...
2
votes
1answer
25k views
How to change SESSION_CACHED_CURSORS for all sessions
how Can I do to change SESSION_CACHED_CURSORS for all sessions?
I found on google and oracle website:
Alter Session... but I need to changed it for all the session and not only for one of them.
How ...
2
votes
1answer
2k views
SQLCMD mode: environment variable syntax?
I assume the best way to set my SSMS (SQL Server 2005) output file path during runtime of T-SQL, is to use SQLCMD mode.
How do I use environment variables (e.g. %systemroot%) in the code? The ...
1
vote
2answers
137 views
Best Practice to Store an Admin Configured Variable [closed]
Some background:
Users submit a form that has a category.
If (category has manager) {
send manager email
}
else {
send 'default' manager an email
}
For the sake of argument, manager_category ...
1
vote
0answers
196 views
Converting and/or enforcing an Ascii Character Set in Informix database from 819 or ISO Latin 1
Overview: In Informix is it possible to enforce ASCII for a database or instance.
Details: I am trying to enforce ASCII in an instance of informix for a while. This is to help have a smooth ...
1
vote
0answers
160 views
Partition of tables with constraint exclusion doesn´t optimize queries
Over an existing table in PostgreSQL (version 9.0.2) I created nine others which inherited the former with check constraints. I turned on the constratint_exclusion variable and runned some queries, ...
0
votes
1answer
4k views
sql_safe_updates set to ON by default
This is fresh mysql install from Debian apt.
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.5.47, for debian-linux-gnu (x86_64) using readline 6.3
..
Server version: 5.5.47-0+deb8u1-...
0
votes
1answer
20 views
Skip_log_bin and innodb_flush_log_at_trx_commit
If I have skip_log_bin =1 is there any reason for not having innodb_flush_log_at_trx_commit = 0?
If I have understand correctly, innodb_flush_log_at_trx_commit, reads data from log file and stores ...
0
votes
1answer
5k views
NLS_LANG AL32UTF8/UTF8 for Oracle database
I recently installed a new Oracle database on Ubuntu using this tutorial.
I got an error
oracle@ubuntu:/home/bruno$ echo $NLS_LANG
/u01/app/oracle/product/11.2.0/xe/bin/nls_lang.sh
oracle@ubuntu:/...
0
votes
1answer
61 views
Percona-server-5.6.41 and sql_mode
When setting
sql_mode=""
in /etc/mysql/my.cnf server leaves this variable in it default value:
mysql> show variables like 'sql_mode';
+-------------------+--------------------------------------...
0
votes
1answer
48 views
MySQL time_zone = SYSTEM not getting correct date on CURRENT_TIME
Via SSH I print the current date of my server, which is correct based on my location:
When I run SHOW GLOBAL VARIABLES on MySQL, I have time_zone = SYSTEM - which makes me think MySQL will be using ...
0
votes
1answer
52 views
Another question about *_buffer_size
Mysql-5.6.30 running on Debian, uses InnoDB, DB size about 100Gb. Dual Xeon 5645 with 48Gb RAM, 4 HDD 15K in RAID 10 (/var) and system on RAID1
There're many "heavy" ORDER BY/GROUP BY, JOIN/sort ...
