Sponsored Content
Top Forums Shell Programming and Scripting How to get a numeric value from Oracle to UNIX variable without spaces? Post 302780831 by franzpizzo on Friday 15th of March 2013 07:03:57 AM
Old 03-15-2013
Hi
try this: mind the spaces: "read|space|BD_RC_CNT|space|<|space|<( etc..."
Code:
read BD_RC_CNT < <(sqlplus -s ${WMD_DM_CONNECT} <<EOF
set heading off
set pagesize 0
Select count(*) 
from wmd_bad_data 
where proc_id = ${PROC_ID} 
and file_id = ${FILE_ID} 
and file_dt = to_date(${DATADATE},'yyyymmdd');
exit
EOF)

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Strip leading and trailing spaces only in a shell variable with embedded spaces

I am trying to strip all leading and trailing spaces of a shell variable using either awk or sed or any other utility, however unscuccessful and need your help. echo $SH_VAR | command_line Syntax. The SH_VAR contains embedded spaces which needs to be preserved. I need only for the leading and... (6 Replies)
Discussion started by: jerardfjay
6 Replies

2. Shell Programming and Scripting

Replace spaces with 0's having numeric values.

What could be the regular expression with gsub function in awk to replace all numerics having spaces before to be replaced with 0s? (1 Reply)
Discussion started by: videsh77
1 Replies

3. UNIX for Dummies Questions & Answers

How to pass unix variable to oracle

hi , how to pass unix variable to oracle code is ............. #! /bin/ksh echo enter date vale read date1 sqlplus x/y@oracle select * from emp where statrt_date= $date1 is this is correct way... (1 Reply)
Discussion started by: chiru
1 Replies

4. Shell Programming and Scripting

delete spaces in the variable in unix script?

Hi All, I need your help.I want to know how to delete the spaces in a variable in unix scripting.Please give solution to this probelm... thanks ! :confused: (14 Replies)
Discussion started by: MARY76
14 Replies

5. Shell Programming and Scripting

to check variable if its non numeric

if test $b -ne then echo "\n\n\n\tPassword reset has been done successfully" else echo "\n\n\n\tAn error occurred" fi i want to check whether $b is non-numeric so how to do that? (3 Replies)
Discussion started by: sachin.gangadha
3 Replies

6. Shell Programming and Scripting

To get value from oracle & assign it in UNIX variable

Hi Team, I need to get data from oracle table & need to assign that value to unix variable. I have serched the same in other threads. I found the following code. I have tried code to get the value from oracle. but it is not working. The error shows invalid identifier "NAM" & then list all... (5 Replies)
Discussion started by: Amit.Sagpariya
5 Replies

7. Shell Programming and Scripting

Passing unix variable to oracle parameters

Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value. calling() { sqlplus -s $1/$2@$3 <<EOF begin exec call_sql($4); end; exit EOF } calling user pwd inst value1... (17 Replies)
Discussion started by: Jairaj
17 Replies

8. Shell Programming and Scripting

trim spaces in unix for variable

HI Guys I have written a script using awk to split a file based on some identifier and renaming the file based on two values from specific length. ts a fixed width file. When I am trying to fetch the values a = substr($0,11,10) b = substr($0,21,5); i am getting spaces in a and b values .... (6 Replies)
Discussion started by: manish8484
6 Replies

9. Shell Programming and Scripting

How to get Oracle variable in UNIX?

Hello All, I need to export various variables in UNIX. But the values of those variables will come from Oracle. Say i have Oracle query: Select file_id, file_desc, file_freq_cd, load_table_nm, load_stored_procd_nm, load_proc_typ_nm, err_rec_cnt_thrsld_nbr, file_expc_rec_cnt From Table1... (7 Replies)
Discussion started by: Arun Mishra
7 Replies

10. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
Globus Callback Spaces(3)					   globus common					 Globus Callback Spaces(3)

NAME
Globus Callback Spaces - Macros #define GLOBUS_CALLBACK_GLOBAL_SPACE Enumerations enum globus_callback_space_behavior_t { GLOBUS_CALLBACK_SPACE_BEHAVIOR_SINGLE, GLOBUS_CALLBACK_SPACE_BEHAVIOR_SERIALIZED, GLOBUS_CALLBACK_SPACE_BEHAVIOR_THREADED } Functions globus_result_t globus_callback_space_init (globus_callback_space_t *space, globus_callback_space_attr_t attr) globus_result_t globus_callback_space_reference (globus_callback_space_t space) globus_result_t globus_callback_space_destroy (globus_callback_space_t space) globus_result_t globus_callback_space_attr_init (globus_callback_space_attr_t *attr) globus_result_t globus_callback_space_attr_destroy (globus_callback_space_attr_t attr) globus_result_t globus_callback_space_attr_set_behavior (globus_callback_space_attr_t attr, globus_callback_space_behavior_t behavior) globus_result_t globus_callback_space_attr_get_behavior (globus_callback_space_attr_t attr, globus_callback_space_behavior_t *behavior) globus_result_t globus_callback_space_get (globus_callback_space_t *space) int globus_callback_space_get_depth (globus_callback_space_t space) globus_bool_t globus_callback_space_is_single (globus_callback_space_t space) Detailed Description Macro Definition Documentation #define GLOBUS_CALLBACK_GLOBAL_SPACE Global callback space. The 'global' space handle. This is the default space handle implied if no spaces are explicitly created. Enumeration Type Documentation enum globus_callback_space_behavior_t Callback space behaviors describe how a space behaves. In a non-threaded build all spaces exhibit a behavior == _BEHAVIOR_SINGLE. Setting a specific behavior in this case is ignored. In a threaded build, _BEHAVIOR_SINGLE retains all the rules and behaviors of a non-threaded build while _BEHAVIOR_THREADED makes the space act as the global space. Setting a space's behavior to _BEHAVIOR_SINGLE guarantees that the poll protection will always be there and all callbacks are serialized and only kicked out when polled for. In a threaded build, it is still necessary to poll for callbacks in a _BEHAVIOR_SINGLE space. (globus_cond_wait() will take care of this for you also) Setting a space's behavior to _BEHAVIOR_SERIALIZED guarantees that the poll protection will always be there and all callbacks are serialized. In a threaded build, it is NOT necessary to poll for callbacks in a _BEHAVIOR_SERIALIZED space. Callbacks in this space will be delivered as soon as possible, but only one outstanding (and unblocked) callback will be allowed at any time. Setting a space's behavior to _BEHAVIOR_THREADED allows the user to have the poll protection provided by spaces when built non-threaded, yet, be fully threaded when built threaded (where poll protection is not needed) Enumerator: GLOBUS_CALLBACK_SPACE_BEHAVIOR_SINGLE The default behavior. Indicates that you always want poll protection and single threaded behavior (callbacks need to be explicitly polled for GLOBUS_CALLBACK_SPACE_BEHAVIOR_SERIALIZED Indicates that you want poll protection and all callbacks to be serialized (but they do not need to be polled for in a threaded build) GLOBUS_CALLBACK_SPACE_BEHAVIOR_THREADED Indicates that you only want poll protection. Function Documentation globus_result_t globus_callback_space_init (globus_callback_space_t *space, globus_callback_space_attr_tattr) Initialize a user space. This creates a user space. Parameters: space storage for the initialized space handle. This must be destroyed with globus_callback_space_destroy() attr a space attr descibing desired behaviors. If GLOBUS_NULL, the default behavior of GLOBUS_CALLBACK_SPACE_BEHAVIOR_SINGLE is assumed. This attr is copied into the space, so it is acceptable to destroy the attr as soon as it is no longer needed Returns: o GLOBUS_CALLBACK_ERROR_INVALID_ARGUMENT on NULL space o GLOBUS_CALLBACK_ERROR_MEMORY_ALLOC o GLOBUS_SUCCESS See Also: globus_condattr_setspace() globus_result_t globus_callback_space_reference (globus_callback_space_tspace) Take a reference to a space. A library which has been 'given' a space to provide callbacks on would use this to take a reference on the user's space. This prevents mayhem should a user destroy a space before the library is done with it. This reference should be destroyed with globus_callback_space_destroy() (think dup()) Parameters: space space to reference Returns: o GLOBUS_CALLBACK_ERROR_INVALID_SPACE o GLOBUS_SUCCESS globus_result_t globus_callback_space_destroy (globus_callback_space_tspace) Destroy a reference to a user space. This will destroy a reference to a previously initialized space. Space will not actually be destroyed until all callbacks registered with this space have been run and unregistered (if the user has a handle to that callback) AND all references (from globus_callback_space_reference()) have been destroyed. Parameters: space space to destroy, previously initialized by globus_callback_space_init() or referenced with globus_callback_space_reference() Returns: o GLOBUS_CALLBACK_ERROR_INVALID_SPACE o GLOBUS_SUCCESS See Also: globus_callback_space_init() globus_callback_space_reference() globus_result_t globus_callback_space_attr_init (globus_callback_space_attr_t *attr) Initialize a space attr. Currently, the only attr to set is the behavior. The default behavior associated with this attr is GLOBUS_CALLBACK_SPACE_BEHAVIOR_SINGLE Parameters: attr storage for the intialized attr. Must be destroyed with globus_callback_space_attr_destroy() Returns: o GLOBUS_CALLBACK_ERROR_INVALID_ARGUMENT on NULL attr o GLOBUS_CALLBACK_ERROR_MEMORY_ALLOC o GLOBUS_SUCCESS globus_result_t globus_callback_space_attr_destroy (globus_callback_space_attr_tattr) Destroy a space attr. Parameters: attr attr to destroy, previously initialized with globus_callback_space_attr_init() Returns: o GLOBUS_CALLBACK_ERROR_INVALID_ARGUMENT on NULL attr o GLOBUS_SUCCESS See Also: globus_callback_space_attr_init() globus_result_t globus_callback_space_attr_set_behavior (globus_callback_space_attr_tattr, globus_callback_space_behavior_tbehavior) Set the behavior of a space. Parameters: attr attr to associate behavior with behavior desired behavior Returns: o GLOBUS_CALLBACK_ERROR_INVALID_ARGUMENT o GLOBUS_SUCCESS See Also: globus_callback_space_behavior_t globus_result_t globus_callback_space_attr_get_behavior (globus_callback_space_attr_tattr, globus_callback_space_behavior_t *behavior) Get the behavior associated with an attr. Note: for a non-threaded build, this will always pass back a behavior == GLOBUS_CALLBACK_SPACE_BEHAVIOR_SINGLE. Parameters: attr attr on which to query behavior behavior storage for the behavior Returns: o GLOBUS_CALLBACK_ERROR_INVALID_ARGUMENT o GLOBUS_SUCCESS globus_result_t globus_callback_space_get (globus_callback_space_t *space) Retrieve the space of a currently running callback. Parameters: space storage for the handle to the space currently running Returns: o GLOBUS_CALLBACK_ERROR_INVALID_ARGUMENT on NULL space o GLOBUS_CALLBACK_ERROR_NO_ACTIVE_CALLBACK o GLOBUS_SUCCESS int globus_callback_space_get_depth (globus_callback_space_tspace) Retrieve the current nesting level of a space. Parameters: space The space to query. Returns: o the current nesting level o -1 on invalid space globus_bool_t globus_callback_space_is_single (globus_callback_space_tspace) See if the specified space is a single threaded behavior space. Parameters: space the space to query Returns: o GLOBUS_TRUE if space's behavior is _BEHAVIOR_SINGLE o GLOBUS_FALSE otherwise Author Generated automatically by Doxygen for globus common from the source code. Version 14.7 Tue Nov 27 2012 Globus Callback Spaces(3)
All times are GMT -4. The time now is 08:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy