11-10-2003
Difference between SET and SETENV
I never undestood exactly what's the difference between the SET and SETENV commands.
One sets variables visible to all users and the other (SETENV) only to the specific user environment ?
Thanks in advance,
BraZil - thE heLL iS HEre
!!!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Well first of all I am a real Unix newbie. I am taking a course on it in University. I kind of understand set and setenv but, I think it si something that I should really understand. So I thought that I would try a forum out and see how good you guys really are.
The question:
Execute the... (1 Reply)
Discussion started by: w6u6f
1 Replies
2. Shell Programming and Scripting
Hi
Is someone know about "setenv"? where can i find out this one?
Regards
Myoe (2 Replies)
Discussion started by: myoeminn
2 Replies
3. Shell Programming and Scripting
Hello,
I just want to know ow I can set permanent pathes or whatever using setenv command. I'm using c shell .
regards,
me (1 Reply)
Discussion started by: geoquest
1 Replies
4. UNIX for Dummies Questions & Answers
Hi,
can anybody tell me what is the difference between set and export in unix.
-Ashish (1 Reply)
Discussion started by: shriashishpatil
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
Is there any difference between setting an environment variable by EXPORT and by setenv? (3 Replies)
Discussion started by: dexkid
3 Replies
6. Shell Programming and Scripting
I am having the following environment setup script.
$cat dbenv.sh
#! /bin/csh
#
set history=32
stty sane
setenv ORACLE_HOME=/dboracle/orabase/product/10.1.0.3
set ORACLE_BASE=/dboracle/orabase
set... (2 Replies)
Discussion started by: rahulrathod
2 Replies
7. UNIX for Dummies Questions & Answers
I thought that set and setenv was easy enough to understand until I started experimenting.
I noticed the same problem in a previous thread, so I will use it as an example.
set command gave the following output:
argv ()
cwd /homes/e/ee325328/assignment.2
home /homes/e/ee325328
path ( a... (2 Replies)
Discussion started by: benwj
2 Replies
8. UNIX for Advanced & Expert Users
helllo every body ..
hope you are having good time programming in unix .
here is a little problem faced me :
setenv("myvar","bla bla",1);
system("myvar=$(grep....));
printf("%s\n", getenv("myvar"));
will print :
bla bla ..
how can i get the value of grep into my program ? ... (7 Replies)
Discussion started by: max_475
7 Replies
9. UNIX for Dummies Questions & Answers
I'm having a problem regarding the encoding of my files in Linux and AIX.
I have a file which can be viewed both in Linux and AIX (via NetApp mount). When I checked the encoding, they have difference.
In Linux, the file is encoded as ISO-8859 text. (checked by using "file" command).... (1 Reply)
Discussion started by: Jin_
1 Replies
10. HP-UX
Hi Experts,
Need your help in understanding the commands to setup the environment variables in hp-ux.
Beleive need to use either set,setenv or export.
I am confused between above three options, when to use which option?
On command line, I have tried both set and setenv but couldn't... (7 Replies)
Discussion started by: userexperience
7 Replies
LEARN ABOUT MOJAVE
set_constraints
SET
CONSTRAINTS(7) SQL Commands SET CONSTRAINTS(7)
NAME
SET CONSTRAINTS - set constraint checking modes for the current transaction
SYNOPSIS
SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }
DESCRIPTION
SET CONSTRAINTS sets the behavior of constraint checking within the current transaction. IMMEDIATE constraints are checked at the end of
each statement. DEFERRED constraints are not checked until transaction commit. Each constraint has its own IMMEDIATE or DEFERRED mode.
Upon creation, a constraint is given one of three characteristics: DEFERRABLE INITIALLY DEFERRED, DEFERRABLE INITIALLY IMMEDIATE, or NOT
DEFERRABLE. The third class is always IMMEDIATE and is not affected by the SET CONSTRAINTS command. The first two classes start every
transaction in the indicated mode, but their behavior can be changed within a transaction by SET CONSTRAINTS.
SET CONSTRAINTS with a list of constraint names changes the mode of just those constraints (which must all be deferrable). The current
schema search path is used to find the first matching name if no schema name is specified. SET CONSTRAINTS ALL changes the mode of all
deferrable constraints.
When SET CONSTRAINTS changes the mode of a constraint from DEFERRED to IMMEDIATE, the new mode takes effect retroactively: any outstanding
data modifications that would have been checked at the end of the transaction are instead checked during the execution of the SET CON-
STRAINTS command. If any such constraint is violated, the SET CONSTRAINTS fails (and does not change the constraint mode). Thus, SET CON-
STRAINTS can be used to force checking of constraints to occur at a specific point in a transaction.
Currently, only foreign key constraints are affected by this setting. Check and unique constraints are always effectively not deferrable.
Triggers that are declared as ``constraint triggers'' are also affected.
NOTES
This command only alters the behavior of constraints within the current transaction. Thus, if you execute this command outside of a trans-
action block (BEGIN/COMMIT pair), it will not appear to have any effect.
COMPATIBILITY
This command complies with the behavior defined in the SQL standard, except for the limitation that, in PostgreSQL, it only applies to for-
eign-key constraints.
SQL - Language Statements 2010-05-14 SET CONSTRAINTS(7)