10 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
Hi,
I have the following reports that get generated every 1 hour and this is my requirement:
1. 5 reports get generated every hour with the names "Report.Dddmmyy.Thhmiss.CTLR"
"Report.Dddmmyy.Thhmiss.ACCD"
"Report.Dddmmyy.Thhmiss.BCCD"
"Report.Dddmmyy.Thhmiss.CCCD"... (1 Reply)
Discussion started by: Jesshelle David
1 Replies
2. UNIX for Advanced & Expert Users
Hi,
I have the following reports that get generated every 1 hour and this is my requirement:
1. 5 reports get generated every hour with the names "Report.Dddmmyy.Thhmiss.CTLR"
"Report.Dddmmyy.Thhmiss.ACCD"
"Report.Dddmmyy.Thhmiss.BCCD"
"Report.Dddmmyy.Thhmiss.CCCD"... (1 Reply)
Discussion started by: Jesshelle David
1 Replies
3. Shell Programming and Scripting
Hi All,
I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row).
I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I... (3 Replies)
Discussion started by: hkrishnan91
3 Replies
4. Shell Programming and Scripting
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies
5. Shell Programming and Scripting
Hello Experts,
Need some direction on creating shell script for following environment:
We have about 20 people in the team working as Oracle DBA's (sysdba's and appdba's). Total Servers which is a mix of Unix and Linux are 200. We do not have Root user access on any of the servers and... (3 Replies)
Discussion started by: sha2402
3 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I am trying to generate a weekly HTML report using LINUX Scripting. This will have record counts of some files. (like below)
touch path/filename.html
echo "Weekly Summary Report for Business Date : $P_BUS_DT">path/filename.html
export A1=`cat path/filename1.txt |wc -l`
echo "A1... (6 Replies)
Discussion started by: dsfreddie
6 Replies
7. Shell Programming and Scripting
Hi,
We have developed Some BO reports in Webi and our requirements is as follows
1)ETL File will be generated and sent to BO server through autosys and once BO server receives that ETL file then BO reports are scehduled on Event based and triggered automatically.(If any failure in report... (0 Replies)
Discussion started by: Sashanth_S
0 Replies
8. UNIX and Linux Applications
Hi,
We are planning for a report generation program in Linux.For that we are planning to use Oracle reports 6i on linux.
Could anybody please confirm if the Oracle 6i reports are compatible on Linux (0 Replies)
Discussion started by: Pavan Pusuluri
0 Replies
9. Shell Programming and Scripting
i have sql script (ex:a.sql) that generates 10 csv files
ex: a.csv
b.csv
c.csv .........
but donot want 10 separate csv files
i want a single csv files with 10 different tab that contains all data
is it possible from unix
:( (2 Replies)
Discussion started by: alokjyotibal
2 Replies
10. UNIX for Dummies Questions & Answers
I have the following snippet to concatenate about a hundred csv-files:
for file in *csv; do cat $file >> newfile; done
This line works, but before I was experimenting with the following line, which is more intuitive and is a tad more robust:
for file in *.csv; do cat $file >> newfile; done
Can... (2 Replies)
Discussion started by: figaro
2 Replies