04-08-2014
Remove the prompt and use &1 instead of &client_id.
This User Gave Thanks to radoulov For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I have a csh script that creates an environment variable. I want to pass the environment variable(CURR_TABLE_DATE) to an Informix sql script. Here is the csh:
#!/bin/csh -f
setenv INFORMIXSERVER market3_tcp
setenv CURR_TABLE_DATE 20090714
set DATABASE = gm_cdr
set SQL_DIR =... (0 Replies)
Discussion started by: jwoj
0 Replies
2. Shell Programming and Scripting
Please help. I got these error. I'm try to pass variable extract from data-file.txt to sql file(select.sql).
cat: cannot open select
cat: cannot open *
cat: cannot open from
cat: cannot open user
cat: cannot open where
cat: cannot open name=$list;
#!/bin/bash
list=`sed q... (3 Replies)
Discussion started by: killboy
3 Replies
3. Shell Programming and Scripting
Hi Guys,
I like to pass a variable to a sql file in a unix script..
I tried a below code..
var=200903
db2 -vf test.sql 200903
test.sql is as below.
select * from db2.users where quarter = $1;
Please tell me where i go wrong..
Thanks in advance,
Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies
4. Shell Programming and Scripting
hi all,
i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code.
sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE
whenever sqlerror exit
set serveroutput on size 1000000
declare
l_rc ... (0 Replies)
Discussion started by: ryukishin_17
0 Replies
5. Shell Programming and Scripting
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
Discussion started by: dazdseg
3 Replies
6. Red Hat
Hi all,
Hereby wish to have your advise for below:
Main concept is
I intend to get current directory of my script file.
This script file will be copied to /etc/init.d.
A string in this copy will be replaced with current directory value.
Below is original script file:
... (6 Replies)
Discussion started by: cielle
6 Replies
7. UNIX for Dummies Questions & Answers
Hi all ,
I want to pass contents from a file say f1 as arguments to a sql query which has In statement using a script
example
select * from table_1 where login in ( `cat f1`) ;
will this work or is there any other way to do it. (1 Reply)
Discussion started by: zozoo
1 Replies
8. Shell Programming and Scripting
Hi all,
How to pass the command line argument to a sql file
Script:
#!/bin/ksh
if ] ; then
test.sql
fi
My Sql Informix DB:
echo "select * from table where col1 = 2234
and col2 = '$3'"|dbaccess ddname
But im getting `:' unexpected error (5 Replies)
Discussion started by: Roozo
5 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
10. Shell Programming and Scripting
Hi All,
In this path /home/all_files
we have follwing files and direcotries
proc_edf_sot.sql
proc_ssc_sot.sql
func_dfg_sot.sql
sot
unic
cmr
sdc
under sot directory we have other directories
sql
pas
ref
under sql directory we have
sql_sot
sql_mat (6 Replies)
Discussion started by: ROCK_PLSQL
6 Replies
LEARN ABOUT HPUX
xhpprompt
XHPPrompt(3X) XHPPrompt(3X)
NAME
XHPPrompt - Send a prompt to an extended input device.
SYNOPSIS
#include <X11/XHPlib.h>
int XHPPrompt (display, deviceid, prompt)
Display *display;
XID deviceid;
unsigned int prompt;
ARGUMENTS
display Specifies the connection to the X server.
deviceid Specifies the ID of the desired device.
Prompt Specifies the Prompt to be sent. Valid values are: GENERAL_PROMPT, PROMPT_1, PROMPT_2, PROMPT_3, PROMPT_4, PROMPT_5, PROMPT_6,
PROMPT_7.
DESCRIPTION
This request is part of an HP-proprietary extension to X. Its functionality has been superseded by the standard X input device extension
XChangeFeedbackControl request. You should use XChangeFeedbackControl instead of XHPPrompt if possible.
This request sends a prompt to an input device.
A prompt is an audio or visual indication that the program controlling the input device is ready for input. The program may indicate that
status by turning on a prompt on the appropriate input device.
Not all input devices support prompts and acknowledges. Any device that does support a particular prompt will also support the
corresponding acknowledge.
To determine whether an input device supports a particular prompt and acknowledge, the io_byte field of the XHPDeviceList structure should
be examined. The format of this structure is described in the documentation for the XHPListInputDevices request.
RETURN VALUE
none
DIAGNOSTICS
BadDevice An invalid device ID was specified.
BadValue An invalid prompt was specified.
FILES
/usr/include/X11/XHPlib.h
ORIGIN
Hewlett-Packard Company
SEE ALSO
XHPListInputDevices(3x)
XHPAcknowledge(3x)
X Version 11 Release 5 XHPPrompt(3X)