Sponsored Content
Full Discussion: SQL output to UNIX variable
Top Forums Shell Programming and Scripting SQL output to UNIX variable Post 302888227 by nani1984 on Thursday 13th of February 2014 09:43:10 AM
Old 02-13-2014
SQL output to UNIX variable

I have a sql statement , i need to assign to a variable in Unix

Code:
sel count(*) AS num_files from TABLE_A;

i need to use "num_files" in unix statements. let me know how to assign unix variable to above num_files

Last edited by Scott; 02-13-2014 at 10:50 AM.. Reason: Code tags, please
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sql query variable not exactly unix

I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help. I can run sql queries in scripts against my informix db using: dbaccess mydb myquery.sql >> sql.output I need to write my script to select based on todays date. Its very... (5 Replies)
Discussion started by: MizzGail
5 Replies

2. Shell Programming and Scripting

how to assign sql output data to shell script variable

Hi Guys ! I am new to unix and want to find out how we can make sql statement data to shell script variable? Any help/suggestion is greatly appreciated -Chandra (1 Reply)
Discussion started by: kattics
1 Replies

3. Shell Programming and Scripting

How to store the sql query's output in a variable

Hi, My requirement is : We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this. Can you please share a code snippet which... (4 Replies)
Discussion started by: venkatesh_sasi
4 Replies

4. Shell Programming and Scripting

sql output into a variable

i have to do a check in my UNIX script to see whats saved in the database. depending on whats there will fork data to certain functions. However i do not know how to capture SQL output into a UNIX variable. Below is what i have tried, but i get an error: Error 3706 Failure 3706 Syntax error:... (3 Replies)
Discussion started by: purplebirky
3 Replies

5. Shell Programming and Scripting

Assigning value of SQL output to a variable in shell scripting

I am trying to assgn the output of the select statement to a variable, like this "VARIABLE_NAME=$ db2 "select COLUMN_NAME_1 from TABLE_NAME where COLUMN_NAME_2='VALUE_TO_CHECK'"; " but the value that is getting into VARIABLE_NAME is "COLUMN_NAME_1 ----------------- VALUE 1... (3 Replies)
Discussion started by: sgmini
3 Replies

6. Shell Programming and Scripting

sql output to shell variable

Hi I tried searching but I used to see , this has been answered may times. But I could not find. I am looking a SQLPLUS output to be assigned to shell variable. This is what I coded. ##/bin/ksh sqlplus dmishr/mishra#09@ps004d.world <<ENDOFSQL spool abc.log SET ECHO OFF NEWP... (4 Replies)
Discussion started by: dgmm
4 Replies

7. Shell Programming and Scripting

I want to get the Unix variable value in the sql stmt

Hi All I have a requirement where in I am stuck. There is a shell script that is being developed by me. It consist of the sql stmt also. I need to export a variable called HOMEPAGE with a value say www.abc.com. and then use this $HOMEPAGE variable in the sql stmt. My ultimate aim is to fetch all... (1 Reply)
Discussion started by: amitsinha
1 Replies

8. Shell Programming and Scripting

Redirect output from SQL to unix variable

Hi, I have a requirement to store oracle sqlplus output to some unix variable, count the records and then print the output on the screen. Can you please point me to any sample program for reference purpose. Thanks a lot for your time. (0 Replies)
Discussion started by: bhupinder08
0 Replies

9. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

10. Shell Programming and Scripting

How to Assign the Output of an SQL Query to a Variable?

Hi iam new to shell scripting how to declare variables as redshift query and I have to compare two counts by using if condition . ex:count=select count(*) from prd; select count(*) from prd; select count(*) from tag; can any one help me . Please use CODE tags when displaying... (1 Reply)
Discussion started by: sam526
1 Replies
MrmOpenHierarchyPerDisplay(library call)								  MrmOpenHierarchyPerDisplay(library call)

NAME
MrmOpenHierarchyPerDisplay -- Allocates a hierarchy ID and opens all the UID files in the hierarchy SYNOPSIS
#include <Mrm/MrmPublic.h> Cardinal MrmOpenHierarchyPerDisplay( Display *display, MrmCount num_files, String file_names_list[], MrmOsOpenParamPtr *ancillary_structures_list, MrmHierarchy *hierarchy_id); DESCRIPTION
MrmOpenHierarchyPerDisplay allows you to specify the list of UID files that MRM searches in subsequent fetch operations. All subsequent fetch operations return the first occurrence of the named item encountered while traversing the UID hierarchy from the first list element (UID file specification) to the last list element. This function also allocates a hierarchy ID and opens all the UID files in the hierar- chy. It initializes the optimized search lists in the hierarchy. If MrmOpenHierarchyPerDisplay encounters any errors during its execu- tion, any files that were opened are closed. The application must call XtAppInitialize before calling MrmOpenHierarchyPerDisplay. display Specifies the connection to the X server and the value to pass to XtResolvePathname. For more information on the Display struc- ture, see the Xlib function XOpenDisplay. num_files Specifies the number of files in the name list. file_names_list Specifies an array of character strings that identify the UID files. ancillary_structures_list A list of operating-system-dependent ancillary structures corresponding to items such as filenames, clobber flags, and so forth. This argument should be NULL for most operations. If you need to reference this structure, see the definition of MrmOsOpen- ParamPtr in the MrmPublic.h header file for more information. hierarchy_id Returns the search hierarchy ID. The search hierarchy ID identifies the list of UID files that MRM searches (in order) when per- forming subsequent fetch calls. Each UID file string in file_names_list can specify either a full pathname or a filename. If a UID file string has a leading / (slash), it specifies a full pathname, and MRM opens the file as specified. Otherwise, the UID file string specifies a filename. In this case MRM looks for the file along a search path specified by the UIDPATH environment variable or by a default search path, which varies depending on whether or not the XAPPLRESDIR environment variable is set. The UIDPATH environment variable specifies a search path and naming conventions associated with UID files. It can contain the substitution field %U, where the UID file string from the file_names_list argument to MrmOpenHierarchyPerDisplay is substituted for %U. It can also contain the substitution fields accepted by XtResolvePathname. The substitution field %T is always mapped to uid. The entire path is searched first with %S mapped to .uid. If no file is found, it is searched again with %S mapped to NULL. For example, the following UID- PATH value and MrmOpenHierarchyPerDisplay call cause MRM to open two separate UID files: UIDPATH=/uidlib/%L/%U.uid:/uidlib/%U/%L static char *uid_files[] = {"/usr/users/me/test.uid", "test2"}; MrmHierarchy *Hierarchy_id; MrmOpenHierarchyPerDisplay((MrmCount)2,uid_files, NULL, Hierarchy_id) MRM opens the first file, /usr/users/me/test.uid, as specified in the file_names_list argument to MrmOpenHierarchyPerDisplay, because the UID file string in the file_names_list argument specifies a full pathname. MRM looks for the second file, test2, first as /uidlib/%L/test2.uid and second as /uidlib/test2/%L, where the display's language string is substituted for %L. After MrmOpenHierarchyPerDisplay opens the UID hierarchy, you should not delete or modify the UID files until you close the UID hierarchy by calling MrmCloseHierarchy. If UIDPATH is not set, but the environment variable XAPPLRESDIR is set, MRM searches the following pathnames: o %U%S o $XAPPLRESDIR/%L/uid/%N/%U%S o $XAPPLRESDIR/%l/uid/%N/%U%S o $XAPPLRESDIR/uid/%N/%U%S o $XAPPLRESDIR/%L/uid/%U%S o $XAPPLRESDIR/%l/uid/%U%S o $XAPPLRESDIR/uid/%U%S o $HOME/uid/%U%S o $HOME/%U%S o /usr/lib/X11/%L/uid/%N/%U%S o /usr/lib/X11/%l/uid/%N/%U%S o /usr/lib/X11/uid/%N/%U%S o /usr/lib/X11/%L/uid/%U%S o /usr/lib/X11/%l/uid/%U%S o /usr/lib/X11/uid/%U%S o /usr/include/X11/uid/%U%S If neither UIDPATH nor XAPPLRESDIR is set, MRM searches the following pathnames: o %U%S o $HOME/%L/uid/%N/%U%S o $HOME/%l/uid/%N/%U%S o $HOME/uid/%N/%U%S o $HOME/%L/uid/%U%S o $HOME/%l/uid/%U%S o $HOME/uid/%U%S o $HOME/%U%S o /usr/lib/X11/%L/uid/%N/%U%S o /usr/lib/X11/%l/uid/%N/%U%S o /usr/lib/X11/uid/%N/%U%S o /usr/lib/X11/%L/uid/%U%S o /usr/lib/X11/%l/uid/%U%S o /usr/lib/X11/uid/%U%S o /usr/include/X11/uid/%U%S These paths are defaults that vendors may change. For example, a vendor may use different directories for /usr/lib/X11 and /usr/include/X11. The following substitutions are used in these paths: %U The UID file string, from the file_names_list argument. %N The class name of the application. %L The display's language string. This string is influenced by XtSetLanguageProc. The default string is determined by calling set- locale(LC_ALL, NULL). %l The language component of the display's language string. %S The suffix to the filename. The entire path is first searched with a suffix of .uid. If no file is found, it is searched again with a NULL suffix. RETURN
This function returns one of the following status return constants: MrmSUCCESS The function executed successfully. MrmNOT_FOUND File not found. MrmFAILURE The function failed. RELATED
MrmCloseHierarchy(3). MrmOpenHierarchyPerDisplay(library call)
All times are GMT -4. The time now is 10:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy