creating reports using shell schell script

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting creating reports using shell schell script
# 1  
Old 01-25-2008
creating reports using shell schell script

please advise..very urgent.

purpose of my script is that it should generate a report by running a sql script which is stored in a directory and pull the information from DB.script shld be in such a way that I just need to pass a parameter and it shld generate the report and store it in a directory in a particular format like date and time.

any inputs?

Appreciate any suggestions!!

Last edited by complicated; 01-25-2008 at 11:19 PM..
# 2  
Old 01-25-2008
You must read up on syntax rules for the script language that You want to use. Your example looks like a mix of different languages and platforms to me. Have You tried to use a script for Windows written in VB (or something) and adapt it to unix/linux? Not much in this script will work...

First of all, what platform/OS are You on?
What script language or shell are You using?

If it really is ksh, please read up on it. Start from the basics, such as writing a "Hello World" program. I promise You, its worth it, because You have to start somewhere.

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Creating IN list in PLSQL script dynamically by using shell script

Hi all, I have a PLSQL script which has a IN list where it takes some ids as input. For example SELECT * FROM EMPLOYEE WHERE EMPLOYEE_ID IN (comma separated list ) I want to run this quest inside a shell script but I would like to prepare the IN list dynamically where the employee ids... (1 Reply)
Discussion started by: LoneRanger
1 Replies

2. Shell Programming and Scripting

script to get user id reports korn shell

Dear Friends, Can Any one provide me script to generate list of username with the gecos field. (cat /etc/passwd | cut -d: -f1,5) Please note i have to run this command from nim server and i have password less ssh access.(ssh hostname command) and i want a file to be generated on nim... (1 Reply)
Discussion started by: vinodchauhan123
1 Replies

3. Shell Programming and Scripting

Calling a servlet from schell script

Hi All, I have deployed a servlet on my server and the u r l is http:// localhost:9080/ ExampleApp / TestJackServlet This works fine when i launch this URL from the browser I am looking for shell script to hit the servlet or hit the URL without launching the browser session. I... (3 Replies)
Discussion started by: jack3698
3 Replies

4. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

5. Shell Programming and Scripting

Capture Schell script error

I work on AIX 5.x. I have a script which does lot of processing & calls multiple child scripts. How do I capture the error of the parent script if it fails? Thanks Sumeet (3 Replies)
Discussion started by: sumeet
3 Replies

6. Shell Programming and Scripting

Need help(sh script)--schell scripting

Hello everybody. Result of my script is coming out to be as mentioned in the below format. Output:: Modified records are as follows = = @abc.core.admin.jonas_user@ = value221 @abccsd.core.admin.pltf_name@ = valuee991 = = ####################################### I need to get... (3 Replies)
Discussion started by: shahidbakshi
3 Replies

7. Shell Programming and Scripting

need assistance ----SH schell script

Hello All, I need to develop a script(SH]) to generate a comparison file between two files old and new file.The script takes in parameter the old file path and the new file path. And the script generates a file containing the comparison between the two files with this details: - Keys... (2 Replies)
Discussion started by: shahidbakshi
2 Replies

8. Shell Programming and Scripting

Creating my first Shell Script

I have an assignment in my programming class to write a shell script that will use command line parameters, display the # of parameters, display all parameters on the command line and display the parameters $0-$9. I understand some of the code (I will be using 'n' to represent the count through... (1 Reply)
Discussion started by: plmahan
1 Replies

9. Shell Programming and Scripting

help on creating shell script

Can some one smart here help I need to create a shell script that does this below using vi editor. decrypts a file (specified as an argument to the script) containing text which was encrypted using the ROT-13 algorithm. The decrypted text should be written to a new file leaving the input file... (1 Reply)
Discussion started by: master_6ez
1 Replies
Login or Register to Ask a Question

Featured Tech Videos