Visit Our UNIX and Linux User Community


change the contraints type of fields in database


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting change the contraints type of fields in database
# 1  
Old 07-26-2007
change the contraints type of fields in database

how to disable the contraint type of a field (which is present in diffrent tables ) in database using a single unix script file.
# 2  
Old 07-26-2007
Could you elaborate on your request with an example
# 3  
Old 07-26-2007
re:: disabling contraint type of field in table

suppose a field name is hrid_1 , and this field is present in 20 tables and the constraint type is NOTNULL, and we want to disable all the hrid_1 field contraint using unix script file.
# 4  
Old 07-26-2007
Quote:
Originally Posted by lorcan
Could you elaborate on your request with an example
suppose a field name is hrid_1 , and this field is present in 20 tables and the constraint type is NOTNULL, and we want to disable all the hrid_1 field contraint using unix script file.
# 5  
Old 07-26-2007
It depends on which data base you are connecting, what are the table names..........

a sample script to have an idead about how you can do that is.

create a file with the name tables in the below mentioned format.

table1
table2
table3

for tablename in $(cat tables)
do
database connecting statemets << EOF
alter table statements
EOF


done

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Change of fields order inline

Hi everyone, What is the best solution to check every line in the xml file and change order of found field along with its value without touching value. Pattern will be given i.e. one line can look like this one: <widget position="value,value" size="value,value" name="value"... (5 Replies)
Discussion started by: TiedCone
5 Replies

2. Red Hat

Can I change the partition type with fdisk without disrupting data?

Hello, I have been going through our environment and I see we have a few servers with LVM's setup and the file system type is still set to "83" within fdisk. If I change this to "8e", will it hurt the data or cause any loss? I need to know for sure before I make the change. (1 Reply)
Discussion started by: s ladd
1 Replies

3. Shell Programming and Scripting

how to split the row(array) in to fields and store in to oracle database in unix

Hi, the csv file with the delimeter #. A#B#C#D#E#F#G#H 1#2#3#4#5#6#7#8 Z#x#c#V 7#2#8#9 N. I want to read the file line by line and store in rowarray. then the rowarray content should be spilt or made to fields using the delimeter #. i am not sure can we store the fields in to... (3 Replies)
Discussion started by: barani75
3 Replies

4. Shell Programming and Scripting

Handling multiple fields of a database file for toupper() function in awk

hello everyone.... script is: To convert the contents of a database file into uppercase my code is: printf "%s\n" , $2 | awk '{print toupper($2)}' emp.lst i m able to do only for one field.....didn't get any sources for handling multiple fields. please suggest me for multiple... (1 Reply)
Discussion started by: Priyanka Bhati
1 Replies

5. OS X (Apple)

Programatically change which opens a file type

Hi there, If we have 2 apps on our customers machines that can both open files of a certain file extension, is there any way via shell commands to set which application should be the default? Essentially, I'm hoping to replicate Get Info > Open With > Change All, but using a script. Thanks... (0 Replies)
Discussion started by: davewg
0 Replies

6. Shell Programming and Scripting

Script that can access any type of(Teradata,Oracle) database

Hi, I need to create a script that can execute database independent queries. Database can be of any type whether tearadata,Mysql,oracle,DB2. Does anyone have any idea how to implement this. (3 Replies)
Discussion started by: monika
3 Replies

7. Shell Programming and Scripting

DBI - Change database

Hello ! I am working on a small Perl script that should connect to the MySQL server, will select all the databases one by one and do some queryes on each. I started working on it but I just saw that on the DBI manual page there's no method for changing the working database. Am I missing... (2 Replies)
Discussion started by: Sergiu-IT
2 Replies

8. UNIX for Dummies Questions & Answers

change order of fields in header record

Hello, after 9 months of archiving 1000 files, now, i need to change the order of fields in the header record. some very large, space padded files. HEADERCAS05212008D0210DOMEST01(spacepadded to record length 210) must now be 05212008HEADERCASD0210DOMEST01(spacepadded to record length 210) ... (1 Reply)
Discussion started by: JohnMario
1 Replies

9. Shell Programming and Scripting

change file type to hidden using chmod command

I want to make a hidden file with chmod command. Example: I have a file name inputfile.txt -rw-r--r-- 1 xxxxxx xxxxxx 1388 Sep 12 05:41 inputfile.txt I want to hide that file using chmod command. Please tell me if it is possible or there is some other way to do this. Thanks... (2 Replies)
Discussion started by: rinku
2 Replies

Featured Tech Videos