thanx fro your response.
Yes it is a kinda home work.
im trying to write the code for extracting the data from the table into the flatfile.
after that i have to get the count of the table and size of the file.
im successful with extracting the data.but struggling with the next two things
i tried in this way but its not showing the proper o/p.
Code:
rec_cnt = $(wc -l < $FNAME)
echo 'Total num of records in the file is `$rec_cnt`' >>sample.del
size= $( stat -c %s sample.del)
echo 'Size of the file is `$size`' >>sample.del
so i want to know how to write it in different way...
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Hi
Can we create a rectangular table as i have attached in the query .
This is primarily for populating the created table with data gathered .
Hope I made myself clear ...
Pls suggest
Thanks (1 Reply)
My Code is
get_week_date()
{
`sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 0
SET SERVEROUTPUT ON
SET VERIFY OFF
SET TRIMSPOOL ON
(update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt'... (2 Replies)
I have been searching both on Unix.com and Google and have not been able to find the answer to my question. I think it is partly because I can't come up with the right search terms.
Recently, my virtual server switched storage devices and I think the problem may be related to that change.... (2 Replies)
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Below is my code where i tried using table tag to print out put in table but its not working
#!/bin/ksh
#] && . ./.profile 2>/dev/null
if test -f '.profile'; then . ./.profile; fi;
#. .profile
LOG_DIR=/app/rpx/jobs/scripts/just/logs
sendEmail()
{
pzCType="$1";... (5 Replies)
Hi,
I am trying to create a table through shell scripting . I used a command sqlplus -s to connect to sqlplus and user as sysdba. but there is a problem in it. can anyone please solve this .
#!/bin/bash
$(`sqlplus -s / as sysdba <<eof
create table sample (id,int);
insert into sample... (1 Reply)
Hi,
I would like to know how to define the size of the array in c shell scripting. (15 Replies)
Discussion started by: gopishrine
15 Replies
LEARN ABOUT ULTRIX
disktab
disktab(5) File Formats Manual disktab(5)Name
disktab - disk description file
Syntax
#include <disktab.h>
Description
The file is a simple data base that describes disk geometries and disk partition characteristics. The format is patterned after the termi-
nal data base. Entries in consist of a number of fields separated by colons (:). The first entry for each disk gives the names that are
known for the disk, separated by vertical bars (|). The last name given should be a long name fully identifying the disk.
The following list indicates the normal values stored for each disk entry:
Name Type Description
ns num Number of sectors per track
nt num Number of tracks per cylinder
nc num Total number of cylinders on the disk
ba num Block size for partition `a' (bytes)
bd num Block size for partition `d' (bytes)
be num Block size for partition `e' (bytes)
bf num Block size for partition `f' (bytes)
bg num Block size for partition `g' (bytes)
bh num Block size for partition `h' (bytes)
fa num Fragment size for partition `a' (bytes)
fd num Fragment size for partition `d' (bytes)
fe num Fragment size for partition `e' (bytes)
ff num Fragment size for partition `f' (bytes)
fg num Fragment size for partition `g' (bytes)
fh num Fragment size for partition `h' (bytes)
pa num Size of partition `a' in sectors
pb num Size of partition `b' in sectors
pc num Size of partition `c' in sectors
pd num Size of partition `d' in sectors
pe num Size of partition `e' in sectors
pf num Size of partition `f' in sectors
pg num Size of partition `g' in sectors
ph num Size of partition `h' in sectors
se num Sector size in bytes
ty str Type of disk (e.g. removable, winchester)
The entries can be automatically generated with the program.
FilesSee Alsochpt(8), newfs(8)disktab(5)