Hi,
I have an issue. There is a file that has got some values seperated by commas. I have to write a shell script that would extrct these values and insert them into a table. How can this be done
Thanx in advance (3 Replies)
Hi,
I am able to insert the values into a database table from a flat file using SQL loader. Now can I do the same using only shell script.Can this be done without using sql loader and only with shell scripting(ie use of awk). Please put some light on this.
Thanks in advance (3 Replies)
Guys,Please look at a simple shell which validates presence of a customer table in OASIS schema. SQL Query for validation is wrong(Table name in quotes should not have schema name OASIS.). And shell is working correctly (with exit 1) as it will never get count=1 with this query.
But it is... (2 Replies)
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
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)
Hi Friends,
I wrote the below shell script to generate a report on alert messages recieved on a day. But i for processing around 4500 lines (alerts) the script is taking aorund 30 minutes to process.
Please help me to make it faster and improve the performace of the script. i would be very... (10 Replies)
I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts.
Here is my script
#!/bin/csh -f
source .orapass
set user = $USER
set pass = $PASS
cd /opt/data/scripts
echo... (2 Replies)
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
LEARN ABOUT BSD
cmap
CMAP(5) File Formats Manual CMAP(5)NAME
cmap - format of .cmap files (color maps)
DESCRIPTION
Color-map files define the mapping between eight-bit color numbers and red, green and blue intensities used for those numbers. They are
read by Magic as part of system startup, and also by the :load and :save commands in color-map windows. Color-map file names usually have
the form x.y.z.cmapn, where x is a class of technology files, y is a class of displays, z is a class of monitors, and n is a version number
(currently 1). The version number will change in the future if the formap of color-map files ever changes. Normally, x and y correspond to
the corresponding parts of a display styles file. For example, the color map file mos.7bit.std.cmap1 is used today for most nMOS and CMOS
technology files using displays that support at least seven bits of color per pixel and standard-phosphor monitors. It corresponds to the
display styles file mos.7bit.dstyle5.
Color-map files are stored in ASCII form, with each line containing four decimal integers separated by white space. The first three inte-
gers are red, green, and blue intensities, and the fourth field is a color number. For current displays the intensities must be integers
between 0 and 255. The color numbers must increase from line to line, and the last line must have a color number of 255. The red, green,
and blue intensities on the first line are used for all colors from 0 up to and including the color number on that line. For other lines,
the intensities on that line are used for all colors starting one color above the color number on the previous line and continuing up and
through the color number on the current line. For example, consider the color map below:
255 0 0 2
0 0 255 3
255 255 255 256
This color map indicates that colors 0, 1, and 2 are to be red, color 3 is to be blue, and all other colors are to be white.
SEE ALSO magic(1), dstyle(5)4th Berkeley DistributionCMAP(5)