|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
passing parameters from a shell script to sqlplus
Post 66369 by andyl on Sunday 13th of March 2005 07:41:09 PM
03-13-2005
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Discussion started by: Jtrinh
1 Replies
2. Programming
I am having a shell script which has to be called from a C program. I have to pass two parameters to this script. HOw can I do that?
eg:
int main()
{
char st1;
char str2;
// call a shell script
call_sh(str1,str2) where call_sh is the name of the shell script.
then i need to get the return... (5 Replies)
Discussion started by: Rajeshsu
5 Replies
3. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
4. Shell Programming and Scripting
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
Discussion started by: kripssmart
3 Replies
5. Shell Programming and Scripting
I am using grep to capture date from a file .
Since i need to use the shell script for different dates ,is it possible to pass the date parameter to the shell script
the Script is as below
grep -E "08 Aug 2008|2008-08-08"* somefile.txt>test.txt
The above script file greps the... (1 Reply)
Discussion started by: sud.tech
1 Replies
6. Shell Programming and Scripting
i have this basic piece of code that i am trying to debug to accept input parameter to be able to display a directory listing of files.
cd /u02/app/eatv/dev/out
CURDIR=`pwd`
echo directory listing of $CURDIR
echo
if ; then
ls -latr
else
ls -latr $1
fi
basically if the script... (9 Replies)
Discussion started by: wtolentino
9 Replies
7. Shell Programming and Scripting
Hello,
I have this shell script that runs awk code by passing in parameters however now it doesn't work anymore with the parameters and I don't know why.
It removes duplicates from an input file based on a part of the last field and a key column. It removes the record with the older datetime... (0 Replies)
Discussion started by: script_op2a
0 Replies
8. Shell Programming and Scripting
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
Discussion started by: WhoDatWhoDer
3 Replies
9. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
10. Shell Programming and Scripting
Hi All,
I'm new to Linux and scripting, apologies in advance for 'stupid' questions.
Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work.
here is my code.
#!/bin/sh
TERM=vt100
export TERM... (4 Replies)
Discussion started by: Mahomed
4 Replies
LEARN ABOUT CENTOS
brlapi_keycodes.h
brlapi_keycodes.h(3) BrlAPI brlapi_keycodes.h(3) NAME
brlapi_keycodes.h - SYNOPSIS
#include 'brlapi_constants.h' Macros #define BRLAPI_PRIxKEYCODE PRIx64 #define BRLAPI_PRIuKEYCODE PRIu64 #define BRLAPI_KEY_MAX UINT64_C(0XFFFFFFFFFFFFFFFF) #define BRLAPI_KEY_FLAGS_MASK UINT64_C(0XFFFFFFFF00000000) #define BRLAPI_KEY_FLAGS_SHIFT 32 #define BRLAPI_KEY_FLG(v) ((brlapi_keyCode_t)(v) << BRLAPI_KEY_FLAGS_SHIFT) #define BRLAPI_KEY_FLG_MOD1 BRLAPI_KEY_FLG(0x00000008) #define BRLAPI_KEY_FLG_MOD2 BRLAPI_KEY_FLG(0x00000010) #define BRLAPI_KEY_FLG_MOD3 BRLAPI_KEY_FLG(0x00000020) #define BRLAPI_KEY_FLG_MOD4 BRLAPI_KEY_FLG(0x00000040) #define BRLAPI_KEY_FLG_MOD5 BRLAPI_KEY_FLG(0x00000080) #define BRLAPI_KEY_TYPE_MASK UINT64_C(0X00000000E0000000) #define BRLAPI_KEY_TYPE_SHIFT 29 #define BRLAPI_KEY_TYPE_CMD UINT64_C(0X0000000020000000) #define BRLAPI_KEY_TYPE_SYM UINT64_C(0X0000000000000000) #define BRLAPI_KEY_CODE_MASK UINT64_C(0X000000001FFFFFFF) #define BRLAPI_KEY_CODE_SHIFT 0 #define BRLAPI_KEY_CMD_BLK_MASK UINT64_C(0X1FFF0000) #define BRLAPI_KEY_CMD_BLK_SHIFT 16 #define BRLAPI_KEY_CMD_ARG_MASK UINT64_C(0X0000FFFF) #define BRLAPI_KEY_CMD_ARG_SHIFT 0 #define BRLAPI_KEY_CMD(v) ((v) << BRLAPI_KEY_CMD_BLK_SHIFT) #define BRLAPI_KEY_SYM_BACKSPACE UINT64_C(0X0000FF08) #define BRLAPI_KEY_SYM_TAB UINT64_C(0X0000FF09) #define BRLAPI_KEY_SYM_LINEFEED UINT64_C(0X0000FF0D) #define BRLAPI_KEY_SYM_ESCAPE UINT64_C(0X0000FF1B) #define BRLAPI_KEY_SYM_HOME UINT64_C(0X0000FF50) #define BRLAPI_KEY_SYM_LEFT UINT64_C(0X0000FF51) #define BRLAPI_KEY_SYM_UP UINT64_C(0X0000FF52) #define BRLAPI_KEY_SYM_RIGHT UINT64_C(0X0000FF53) #define BRLAPI_KEY_SYM_DOWN UINT64_C(0X0000FF54) #define BRLAPI_KEY_SYM_PAGE_UP UINT64_C(0X0000FF55) #define BRLAPI_KEY_SYM_PAGE_DOWN UINT64_C(0X0000FF56) #define BRLAPI_KEY_SYM_END UINT64_C(0X0000FF57) #define BRLAPI_KEY_SYM_INSERT UINT64_C(0X0000FF63) #define BRLAPI_KEY_SYM_FUNCTION UINT64_C(0X0000FFBE) #define BRLAPI_KEY_SYM_DELETE UINT64_C(0X0000FFFF) #define BRLAPI_KEY_SYM_UNICODE UINT64_C(0X01000000) Typedefs typedef uint64_t brlapi_keyCode_t Author Generated automatically by Doxygen for BrlAPI from the source code. Version 1.0 Mon Apr 1 2013 brlapi_keycodes.h(3)