Sponsored Content
Top Forums Shell Programming and Scripting Passing multiple column values to UNIX variable Post 302852319 by rafa_fed2 on Wednesday 11th of September 2013 08:47:30 AM
Old 09-11-2013
Passing multiple column values to UNIX variable

Code:
sqlplus -s $USER_ID@$SID/$PWD<<EOF>sql_1.txt  
set feedback off  
set heading off  
select  114032 as c_1 from dual ;  
EOF  
for i in `cat sql_1.txt`  
do  
sh script_1.sh  $i

Currently i am passing one column value to the single unix variable.
How can i pass the values from 2 columns
Code:
sqlplus -s $USER_ID@$SID/$PWD<<EOF>sql_1.txt  
set feedback off  
set heading off  
select  114032 as c_1 ,sysdate c_2  from dual ;  
EOF  
sh script_1.sh $col_1_value  $col_2_value

I am on SUNOS

Last edited by vbe; 09-11-2013 at 10:05 AM.. Reason: not all in code tags please, makes no sense ...
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Passing values from SQR to UNIX

UNIX script running a SQR program.... no problem passing values to SQR program... trying to pass values back to UNIX.... I'm currently creating a file from the SQR program and then using the Unix READ command to read the file and retrieve the value.... Is there an easier way to pass the... (2 Replies)
Discussion started by: seeuinoz
2 Replies

2. UNIX for Dummies Questions & Answers

scripting: multiple values from file passing to command

one of my colleagues has this question. he has a command, C_CMD which accepts 4 variables, $1 $2 $3 $4 he wants to load up a file with multiple rows, one row per set of variables and then iteratively execute the command based on the content of the file. example: at the command line you'd... (5 Replies)
Discussion started by: LisaS
5 Replies

3. Shell Programming and Scripting

passing variable values to awk command

Hi, I have a situation where I have to specify a different value to an awk command, I beleive i have the gist of this done, however I am not able to get this correct. Here is what I have so far echo $id 065859555 This value occurs in a "pipe" delimited file in postition 8. Hence I would... (1 Reply)
Discussion started by: jerardfjay
1 Replies

4. Programming

Passing multiple values from a function in C

I know multiple values can be returned from a function in C like this: char **read_file ( char * , unsigned long int * );//this is the function prototypeunsigned long int number_of_words = 0;//variable defined in main() and initialized to 0words_from_dictionary = read_file ( "dictionary.dit" ,... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies

5. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ... (1 Reply)
Discussion started by: Diya123
1 Replies

6. UNIX for Dummies Questions & Answers

Passing of variable values to remote server

Hi, My script will take 3 i/p's from user. Now i need to pass these 3 values to remote server. Please find my code. while do echo " To which server you want to connect ? " echo " 1. server1 \n" echo " 2. server2 \n" read opt_server if then echo "enter the... (2 Replies)
Discussion started by: sree143reddy
2 Replies

7. Shell Programming and Scripting

Passing multiple variable to awk

Hi , can I pass more then one variable to awk using -v option? (4 Replies)
Discussion started by: Anupam_Halder
4 Replies

8. Shell Programming and Scripting

[SOLVED] UNIX FOR loop to read a variable with multiple values

Hi, I have a variable which stores file names as a result of find command. I need to delete all these files one by one, i.e. by a loop. Can anyone tell me how can it be done? The variable f2d has the file names like these abc.txt bcd.txt fff.txt gef.txt Now I have used a loop as... (12 Replies)
Discussion started by: jhilmil
12 Replies

9. Shell Programming and Scripting

Passing values from awk to shell variable

I am writing a script where I need awk to test if two columns are the same and shell to do something if they are or are not. Here is the code I'm working with: @ test = 0 ... test = `awk '{if($1!=$2) print 1; else print 0}' time_test.tmp` #time_test.tmp holds two values separated by a space... (3 Replies)
Discussion started by: Malavin
3 Replies

10. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
avc_context_to_sid(3)					     SELinux API documentation					     avc_context_to_sid(3)

NAME
avc_context_to_sid, avc_sid_to_context, avc_get_initial_sid - obtain and manipulate SELinux security ID's. SYNOPSIS
#include <selinux/selinux.h> #include <selinux/avc.h> int avc_context_to_sid(security_context_t ctx, security_id_t *sid); int avc_sid_to_context(security_id_t sid, security_context_t *ctx); int avc_get_initial_sid(const char *name, security_id_t *sid); DESCRIPTION
Security ID's (SID's) are opaque representations of security contexts, managed by the userspace AVC. avc_context_to_sid returns a SID for the given context in the memory referenced by sid. avc_sid_to_context returns a copy of the context represented by sid in the memory referenced by ctx. The user must free the copy with freecon(3). avc_get_initial_sid returns a SID for the kernel initial security identifier specified by name. RETURN VALUE
avc_context_to_sid and avc_sid_to_context return zero on success. On error, -1 is returned and errno is set appropriately. ERRORS
ENOMEM An attempt to allocate memory failed. NOTES
As of libselinux version 2.0.86, SID's are no longer reference counted. A SID will be valid from the time it is first obtained until the next call to avc_destroy(3). The sidget and sidput functions, formerly used to adjust the reference count, are no-ops and are deprecated. AUTHOR
Eamon Walsh <ewalsh@tycho.nsa.gov> SEE ALSO
avc_init(3), avc_has_perm(3), avc_cache_stats(3), avc_add_callback(3), getcon(3), freecon(3) selinux(8) 27 May 2004 avc_context_to_sid(3)
All times are GMT -4. The time now is 05:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy