Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell script and sql
Top Forums Shell Programming and Scripting Shell script and sql Post 97856 by sendhil on Friday 3rd of February 2006 04:09:44 AM
Old 02-03-2006
Shell script and sql
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
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SQL in shell script

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)
Discussion started by: sendhil
3 Replies

2. Shell Programming and Scripting

Shell Script - SQL

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)
Discussion started by: bhush782003
2 Replies

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

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)
Discussion started by: rajagavini
5 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

How to grep sql error in shell script and exit the script?

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)
Discussion started by: allinshell99
2 Replies

6. Shell Programming and Scripting

LIKE in SQL shell script

sqlplus -s <<__END__ ${USER}/${PASS}@${DB} WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK WHENEVER OSERROR EXIT FAILURE ROLLBACK SET ECHO ON SET TIMING ON SET SERVEROUTPUT ON SIZE 1000000 select count(*) from table where start LIKE '10-JUN-10'; EXIT __END__ result=$? echo $resultThis gives... (9 Replies)
Discussion started by: sandy1028
9 Replies

7. Shell Programming and Scripting

pass null value to sql script from korn shell script

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)
Discussion started by: megha2525
11 Replies

8. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

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)
Discussion started by: Kapom
2 Replies

9. UNIX for Dummies Questions & Answers

Help with SQL Shell script

Hi, I need to excute two .sql scripts sequentially within file.sh sqlplus user/pass@db1 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy1.sql THEN sqlplus user/pass@db2 @/opt/Infor/Outbound_Marketing/7.2.2/custom/iadeploy3.sql Thanks, Soph (4 Replies)
Discussion started by: soph1997
4 Replies

10. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

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 DEBIAN

image_to_j2k

IMAGE_TO_J2K(1) 						  OPENJPEG TOOLS						   IMAGE_TO_J2K(1)

NAME

       image_to_j2k - convert a PNM, PGM, PPM, PGX or BMP into a J2K or JP2 file

SYNOPSIS

DESCRIPTION

       image_to_j2k converts an image into a JPEG 2000-encoded image

OPTIONS

       -ImgDir sourcedir
	   Directory of PGM, PPM, PNM, PGX or BMP files to convert

       -OutFor extension
	   J2K or JP2 output file format

       -i source
	   PNM, PGM or PPM file to convert

       -o destination
	   J2K or JP2 file to output to

       -h  Display help information

       -cinema2k fps
	   Digital Cinema 2K profile compliant codestream for 2K resolution. 24 or 48 fps.

       -cinema4k [fps]
	   Digital Cinema 4K profile compliant codestream for 4K resolution. fps default is 24

       -r ratios
	   compression factor for successive layers, comma seperated

       -q psnr
	   psnr for successive layers, comma seperated

       -n rescount
	   number of resolutions

       -b blocksize
	   width and height of code block, comma-seperated

       -c precintsize
	   width and height of precinct, comma-seperated

       -t tilesize
	   width and height of tile, comma-seperated

       -p progression
	   progression order, one of LRCP, RLCP, RPCL, PCRL, CPRL

       -s subsampling
	   subsampling factor in X and Y, comma-seperated. Values larger than 2 can produce errors

       -POC orders
	   progression order change

       -SOP
	   write SOP marker before each packet

       -EPH
	   write EPH marker after each header packet

       -M modeflags
	   Sum of the values of the modes, as follows:

	   1. BYPASS (LAZY)
	   2. RESET
	   4. RESTART (TERMALL)
	   8. VSC
	   16. ERTERM (SEGTERM)
	   32. SEGMARK (SEGSYM)
       -x indexfile
	   create an index file

       -ROI:quantize
	   quantization indices upshifted for component c between 0 and 2 inclusive with an upshift of U between 0 and 37 inclusive

       -d imageoffset
	   X and Y offset of the origin of the image, comma-seperated

       -T tileoffset
	   X and Y offset of the origin of the tiles, comma-seperated

       -I  use the irreversible DWT 9-7

EXAMPLE

       ratios: 20,10,1	Quality 1: compress 20x; Quality 2: compress 10x; Quality 3: lossless compression

       psnr: 30,40,50

       quantize: c=0,U=25

       orders: T1=0,0,1,5,3,CPRL  Title 1: Resolution 0 start, component 0 start, layer 1 end, resolution 5 end, component 3 end, CPRL progression

AUTHOR

       Written by Paul Hampson <Paul.Hampson@Pobox.com> based on the output of image_to_j2k -h as part of the Debian packaging of OpenJPEG

COPYRIGHT

       Copyright 2007 Paul Hampson

SEE ALSO

       j2k_to_image(1), <http://www.openjpeg.org/index.php?menu=doc#encoder>

1.3+dfsg							    2014-04-22							   IMAGE_TO_J2K(1)
All times are GMT -4. The time now is 02:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy