I have a ksh script that connects to sqlplus and dumps the query results into a file. The script works file when I run it from the command line, however, when I call it from PHP using system(), exec(), or shell_exec() commands, the script doesn't seem to run the query. It will create the text file... (7 Replies)
hi fellows,
can any body tell me how to pass unix variables to oracle
code is...
#! /bin/ksh
echo ENTER DATE VALUE's
read START_DATE END_DATE
sqlplus xyx/abc@oracle
select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in... (1 Reply)
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
I'm trying to store the response from a nawk command inside of a ksh script. The command is:
text=$(nawk -F: '$1 ~ /${imgArray}/ {print $2}' ${etcDir}/captions.txt)
From what I can tell, the imgArray variable is not being expanding when it is inside the single quote ('). Is there something I... (4 Replies)
I have a script that "runs" a script. For example:
./runscript.ksh pcnmc01.ksh
runscript puts pcnmc01.ksh into the background with log output going to the logfile.
After executing the command, I get this output:
Running script in the background: pcnmc01.ksh
Logfile:... (2 Replies)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
I'm trying to create a ksh script that will ask the user for the port number. $PORT1 is the variable I want to use that will contain whatever numbers the user inputs. The script would edit ports.txt file, search and delete "./serv 110.1.0.1.$PORT1 200;=3" .
So if the user types 50243 then the... (5 Replies)
Hi,
I am new to shell script programming. I have written a ksh script to run the sql File placed in server directory and spool the output in destination directory.
Below Command:
$ORACLE_HOME/bin/sqlplus -s $ora_uid @$sqlfile_loc$testquery.sql > $opfiledirectory
It is generating the output... (6 Replies)
Hi Team,
I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows:
#!/bin/bash
export ORACLE_SID=plgc1
export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1
export... (1 Reply)
Discussion started by: jonnyd
1 Replies
LEARN ABOUT DEBIAN
gdcmviewer
gdcmviewer(1) GDCM gdcmviewer(1)NAME
gdcmviewer - Simple DICOM viewer.
SYNOPSIS
gdcmviewer [options] file-in
DESCRIPTION
The gdcmviewer is a simple tool that show how to use vtkGDCMImageReader. The class that use gdcm to make a layer to VTK. gdcmviewer is
basically only just a wrapper around VTK/GDCM.
This tool is meant for testing integration of GDCM in VTK. You should see it as a demo tool. It does compile with VTK ranging from 4.2 to
5.8, but only with VTK 5.2 (or above) can only play with the widgets (as described below).
PARAMETERS
file-in DICOM input filename
options
options
--force-rescale force rescale (advanced users)
--force-spacing force spacing (advanced users)
-r --recursive Recusively descend directory
general options
-h--help
print this help text and exit
-v--version
print version information and exit
-V--verbose
verbose mode (warning+error).
-W--warning
warning mode, print warning information
-E--error
error mode, print error information
-D--debug
debug mode, print debug information
Typical usageSimple usage
For now gdcmviewer should be started from a command line prompt. The next argument should be the name of the DICOM file you wish to read.
For instance:
$ gdcmviewer -V 012345.002.050.dcm
gdcmviewer will try to read your file, and then print the vtk information associated with this file. Basically what kind of image you are
looking at.
o ScalarType is the DICOM Real World Value type
o Dimensions is the dimension of the image
o Spacing is the spacing of the image
o NumberOfScalarComponents should be 1 for grayscale & PALETTE COLOR and 3 for RGB, YBR data.
Wiki Link
The wiki page, with color pictures can be found at: http://sourceforge.net/apps/mediawiki/gdcm/index.php?title=Gdcmviewer
SEE ALSO gdcmdump(1), gdcm2vtk(1)COPYRIGHT
Copyright (c) 2006-2011 Mathieu Malaterre
Version 2.2.0 Tue Feb 5 2013 gdcmviewer(1)