Connecting database


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Connecting database
# 1  
Old 09-26-2010
Connecting database

Hi all,
In my concern they gave a task to me do cran job like
To write a shell script for

To connect a database
it should execute a query
it should save the output of the query
after getting the output it should send a mail to you inbox for every one hour

I can able to connect to database by wiriting the query plz help me in rest of the activity


Thanks in advance

Regards
Thelak
# 2  
Old 09-26-2010
Please post the complete script you wrote so far.


Posted from my Samsung Galaxy S mobile.
# 3  
Old 09-26-2010
codes

Code:
sqlplus custom/custom123@abncntem

the above stuff will work to connect to the database

Code:
select count(*) GUP from gup
/
select count(*) SOD from sod
/
select count(*) GUPSIS from gupsis@csis
/
select count(*) SODSIS from sodsis@csis

the above shown stuffs will have to be in a sql file this should have to run after it connects to the database

ie(in the script file i should have to call this sql file)
# 4  
Old 09-26-2010
You need to write more that than.... or at least write the pseudo code so people understand what you are doing.

Thanks.

---------- Post updated at 06:17 ---------- Previous update was at 06:17 ----------

You need to write more that than.... or at least write the pseudo code so people understand what you are doing.

Thanks.
# 5  
Old 09-26-2010
Code:
#!/usr/bin/ksh
sqlplus custom/custom123@abncntem << EndOfFile
select count(*) GUP from gup ;
{blah blah blah}
quit
EndOfFile > output.txt

mailx -s "File" abc@abc.com < output.txt

# 6  
Old 09-30-2010
HI

Code:
!/usr/bin/ksh
sqlplus insivs/Siva#shan11@fincncor << EndofFile
#sqlplus custom/custom123@fincncor << EndOfFile
spool count.txt
select count(*) GUP from gup
/
select count(*) SOD from sod
/
select count(*) GUPSIS from gupsis@csis
/
select count(*) SODSIS from sodsis@csis
/
spool off
quit
#mailx -s "file" thelak.kumar@###.com < count.txt[/COLOR]

Every thing is working fine but am not receiving the mail,i tried in so many ways,any help
be appericiated
Its possible to to send mail with attachment?
I have to add this check in CRON JOB too please help
Thanks

Last edited by Scott; 09-30-2010 at 02:15 PM.. Reason: Please use code tags
# 7  
Old 09-30-2010
Quote:
Originally Posted by thelakbe
HI

!/usr/bin/ksh
sqlplus insivs/Siva#shan11@fincncor << EndofFile
#sqlplus custom/custom123@fincncor << EndOfFile
spool count.txt
select count(*) GUP from gup
/
select count(*) SOD from sod
/
select count(*) GUPSIS from gupsis@csis
/
select count(*) SODSIS from sodsis@csis
/
spool off
quit
#mailx -s "file" thelak.kumar@###.com < count.txt[/COLOR]

Every thing is working fine but am not receiving the mail,i tried in so many ways,any help
be appericiated
Its possible to to send mail with attachment?
I have to add this check in CRON JOB too please help
Thanks
First Check `mailx` service is enable on your server or not ?
If enable, U want database Query output in mail or Attachments in mail, confirm?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Connecting to Oracle database

Hi guys, long time no typing :D I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box. Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies

2. Shell Programming and Scripting

script for connecting database in loops

Hi experts. I have different database and schema and their passwords in one file. In Unix : I want to create the script that connect the sqlplus and execute the select query one by one schema with different database. Ex: password File Format databse schemaname password DB1 name1 ... (1 Reply)
Discussion started by: abhigrkist
1 Replies

3. Shell Programming and Scripting

Connecting to oracle database

Hai i want to connect to oracle database from user input and create a view. ${ECHO} "Debut Creating View" ${ECHO} "Please Enter the User Name:" read user_name ${ECHO} "Please Enter the Connection String:" read con_string ${ECHO} "Please Enter the Password:" read pwd... (3 Replies)
Discussion started by: shenthil76
3 Replies

4. Shell Programming and Scripting

connecting to different database in sqr

Hi, My requirement is to generate a single text output which fetches data from two different databases. I have two different sqrs to generate text file1(data from db1) and file2(data from db2). can I execute both the sqrs from a single shell script? If yes, pls let me know how to connect to db2... (1 Reply)
Discussion started by: vimalr
1 Replies

5. Shell Programming and Scripting

Connecting to Database

Hi, I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not? Can anyone help me in this regard? Appreciate your help and concern. Thanks, Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies

6. Windows & DOS: Issues & Discussions

Client is not connecting to the Database

Hi, Am running my client in Windows and the database (IBM DB2) is in AIX machine. if I open my client its not connecting to the database at first time and failing in a particular SQL Query. But if I close the client and open again then its connecting and the query is also working fine. Don't... (0 Replies)
Discussion started by: mvictorvijayan
0 Replies

7. UNIX for Advanced & Expert Users

Connecting to DB2 database on Mainframe and Querying DB

I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Discussion started by: developncode
2 Replies

8. Shell Programming and Scripting

Connecting to Oracle Database

if; sql="select username from dba_users where username = '$FromUser';" check_FromUser=`ExecSql "$sql"` I want to connect to Oracle database & check the users in the database, store the value in check_FromUser. First how to connect to Oracle database from the shell script ? Appreciate your... (4 Replies)
Discussion started by: dreams5617
4 Replies

9. Shell Programming and Scripting

error connecting database from perl

Hi, While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows : Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
Discussion started by: DILEEP410
4 Replies

10. UNIX for Advanced & Expert Users

Connecting to a database via UNIX

hello - Is it possible to connect to a database at the command line to an Oracle instance whilst logged in on the unix box i.e. not using a script Cheers (Running Solaris) Also if anyone has any info on how a Citirix ICA client might be helpful here that would be appreciated Cheers (1 Reply)
Discussion started by: penfold
1 Replies
Login or Register to Ask a Question