1. Shell Programming and Scripting

Hi Unix Gurus, I am new to unix and perl/shell script. Can anybody guide me how i can get records from a database table in an array. My requirement is : From Unix script i have to read a column of a databse table and put those reocrds in an array. Once i have a array list i have to... (2 Replies)

2. UNIX and Linux Applications

Hi, Hi we have application running on Unix Server(solaris10), which establishes connection(sessions) with DATABASE(oracle 10g) which is on another server and firewal is there in between. After some time i am usually getting connection time out(oarcle error 3114/3113) in some of my... (0 Replies)

3. Web Development

so when i issue a command like the below: # mysql --pager=/usr/bin/less -u cactiman -p -e 'select * from data_input' cacti Enter password: ... (2 Replies)

4. Shell Programming and Scripting

i want to retrieve value in each column of each row in sql plus and save them into array variable and echo the value in array variable (2 Replies)

5. Shell Programming and Scripting

Guys, I need help. I need to create a script to delete records in mysql database where record is 2 days old. Thanks. (1 Reply)

6. Shell Programming and Scripting

How do i find the record which has been edit the last 10 minutes? from a.txt which has last field is epoch time updated. 10/17/2012 1:47 PM||||||In Use|chicken||1350005487 10/17/2012 2:53 PM||||||Available|chicken||13500000 10/17/2012 3:20 PM||||||In Use|cat||1351000000 10/17/2012 3:22... (2 Replies)

7. Shell Programming and Scripting

I have a table in an Informix DB into which I want to insert multiple records at a time. Data for one of the column should be unique & other column data may be the same for all the records I insert Typical Insert Statement I use to insert one row : insert into employee(empid, country, state)... (5 Replies)

8. Shell Programming and Scripting

Hello All Members, I am new to this forum and to the shell scripting. I want to write a shell script to do the following: Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the... (18 Replies)

9. Shell Programming and Scripting

Hi Team, Is there a way to grep time taken to save records. Its like there is one webpage where when I click save button taking so much time to save result. Therefore, I want to grep that time taken to save that record from file.log Thanks in advance. (1 Reply)

10. Shell Programming and Scripting

Gents, I have an csv file which contends value GPS time for each record and x, y coordinates.. The purpose is to identify which vps does not match with the law parameters in the relation time and offset. In the graphic attached you can see example of 3 vps which are showed in red color and... (12 Replies)