Creating an sql statement from a file. Problem with ' Post: 302188777

10 More Discussions You Might Find Interesting

1. HP-UX

SQL statement output to Log file-How?

Hi all, I need to bring the message to log file.Teradat/Hp-Ux script: ----- ### Update Log Table bteq <<- EOC .run file ${SRC_DATA}/logon.txt .run file ${SRC_DATA}/dbstagebteq.txt .set format off .set foldline off all .set sidetitles off ...

2. 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...

3. Shell Programming and Scripting

Creating a .sh script to execute an SQL file

Hello I'm hoping someone may be able to help. I'm absolutely brand new to these shell scripts and have tried to bash bits together from the little learnt but my final script still doesn't work. Sorry if something similar is already posted but couldn't find anything existing close enough to help...

4. Shell Programming and Scripting

Executing sql statement from .sh file

Hi, How to execute sql statements from the .sh file ?? Means, when we run .sh file then the sql statements within it should be get executed one by one from the sqlplus With Regards

5. Shell Programming and Scripting

Problem creating file with awk

Hello, I don't understand why the script below doesn't act the way it should : #!/bin/sh awk 'BEGIN{printf("Entrez la date : "); getline date < "-"} $0 ~ date {f=1;print;next} /^{2}\//{f=0} f' Planning.csv > planning.txt It doesn't create file planning.txt with only the result of...

6. Shell Programming and Scripting

Execute and log each statement/block SQL file

Hi friends, I would like to get some help on the following requirement. I have a SQL file with following things, select 1 from dual; select user from dual; select sysdate from dual; BEGIN PL/SQL Code END; / This file will be saved as sql file. When I run my expected shell script,...

7. Shell Programming and Scripting

problem in creating my own profile file in unix

I am new in shell scripting. currently i am using cygwin. My problem is i created a profile file in my own folder. file name is first.profile in which i gave following values to variable export a=10 now i am executing this profile file by below command ./.first.profile it executed...

8. UNIX for Dummies Questions & Answers

unix script with SQL statement problem

Hello, I have a script to get the information from database, however, it's look like the loop is not work, can someone help? :confused: echo Input file list to check: read filelist for file in 'cat $filelist.txt' do echo "select FILENAME from FILE_TABLE where filename like '${file}'%;" >>...

9. UNIX for Dummies Questions & Answers

Problem in creating CSV file

Hi guys, I am not experienced with Unix, so please dont mind if the question seem to be irrelevant. I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail. -I stored the query o/p in a file. -I...

10. Shell Programming and Scripting

Creating if statement for nfs

What would be correct syntax in a script to check to see if a /export/nfs/home mount point is mounted and if not stop/abort? OS is Solaris 10 using standard VI ksh shell. Here is the script. Please tell me where you see the problem. #!/bin/bash # # This script is run as root to sync AMI PROD...

LEARN ABOUT FREEBSD

pnmdepth

pnmdepth(1)                                                   General Commands Manual                                                  pnmdepth(1)

NAME

       pnmdepth - change the maxval in a portable anymap

SYNOPSIS

       pnmdepth newmaxval [pnmfile]

DESCRIPTION

       Reads a portable anymap as input.  Scales all the pixel values, and writes out the image with the new maxval.  Scaling the colors down to a
       smaller maxval will result in some loss of information.

       Be careful of off-by-one errors when choosing the new maxval.  For instance, if you want the color values to be five bits wide, use a  max-
       val of 31, not 32.

       One  important  use  of pnmdepth is to convert a new format 2-byte-per-sample PNM file to the older 1-byte-per-sample format.  Before April
       2000, essentially all raw (binary) format PNM files had a maxval less than 256 and one byte per sample, and many programs may rely on that.
       If  you  specify  a  newmaxval  less than 256, the resulting file should be readable by any program that worked with PNM files before April
       2000.

SEE ALSO

       pnm(5), ppmquant(1), ppmdither(1)

AUTHOR

       Copyright (C) 1989, 1991 by Jef Poskanzer.

                                                                   08 April 2000                                                       pnmdepth(1)

10 More Discussions You Might Find Interesting

1. HP-UX

SQL statement output to Log file-How?

Discussion started by: vsubbu1000

2. Shell Programming and Scripting

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

Discussion started by: praka

3. Shell Programming and Scripting

Creating a .sh script to execute an SQL file

Discussion started by: Dan27

4. Shell Programming and Scripting

Executing sql statement from .sh file

Discussion started by: milink