Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: create sql query
Top Forums Shell Programming and Scripting create sql query Post 302535180 by aigles on Thursday 30th of June 2011 03:56:00 AM
Old 06-30-2011
Sorry, i don't use perl so I can't help you anymore.

Jean-Pierre.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

& in SQL query

I have a script that looks for all jobs that contain a particular calendar. Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this? I have tried: select job_name from job where run_calendar='1&15dom' select job_name from job... (3 Replies)
Discussion started by: Lindarella
3 Replies

2. Shell Programming and Scripting

rsh and sql query

Hi ... I am doing a switch user and then rsh and then running a sql query . I am successfull in rsh and logging into the database , but my query doesnt run .. Here's the command : su - linus -c "rsh -l linus psmf ORACLE_SID=SMP;export ORACLE_SID;sqlplus... (1 Reply)
Discussion started by: sars
1 Replies

3. UNIX and Linux Applications

SQL Lite query

Hello Everyone, I am looking to write a script that will run on many machines in a network at the same time. They need to write a result to a common location. I plan to use a SQLlite database as this common writing point. But the concern I have is how SQLlite will react to multiple writes that... (1 Reply)
Discussion started by: garric
1 Replies

4. Shell Programming and Scripting

sql query problem

Hi, I am passing an argument for the script and that argument values should exist in database. bill_period_input="'""$1""'" bill_period=`sqlplus uname/pwd@dbname <<eof! set verify off set heading off set feedback off select bill_period from bill_period_ref where... (4 Replies)
Discussion started by: ss_ss
4 Replies

5. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

6. Shell Programming and Scripting

problem in SQL query

I used the following code code select * from tablename where columnname Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem? Thanks Ananth (2 Replies)
Discussion started by: Ananthdoss
2 Replies

7. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

8. Programming

Getting error in sql query

Hi All , I have tried many times am getting syntax error on 'UNION' can anybody tell me ... INSERT INTO table1 ( Type , num_items , num_letters , total_value ) (select type='1', num_items, num_letters=count(*), total_value=sum(letter_value) from table2 where num_items = 1 (1 Reply)
Discussion started by: Venkatesh1
1 Replies

9. Programming

Help writing SQL query

Hello All, I hope I'm posting this in the right section. I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)
Discussion started by: bbbngowc
8 Replies

10. Solaris

SQL QUERY to Table Output

Hi I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p inner join v$session se on p.addr = se.paddr inner join ( select... (2 Replies)
Discussion started by: tharmendran
2 Replies

LEARN ABOUT DEBIAN

lfc-listusrmap

LFC-LISTUSRMAP(1)					    LFC Administrator Commands						 LFC-LISTUSRMAP(1)

NAME

       lfc-listusrmap - query about a given user or list all existing users in virtual uid table

SYNOPSIS

       lfc-listusrmap [ --uid uid ] [ --user username ]

DESCRIPTION

       lfc-listusrmap queries about a given user or lists all existing users in virtual uid table.

       This function requires ADMIN privilege.

OPTIONS

       --uid uid
	      specifies the Virtual User Id.

       --user username
	      specifies the user name.

EXAMPLES

       lfc-listusrmap --uid 5678
	   5678 /DC=ch/DC=cern/OU=Organic Units/OU=Users/CN=Jean Dupond

       lfc-listusrmap --user "/DC=ch/DC=cern/OU=Organic Units/OU=Users/CN=Jean Dupond"
	   5678 /DC=ch/DC=cern/OU=Organic Units/OU=Users/CN=Jean Dupond

       lfc-listusrmap
	   5678 /DC=ch/DC=cern/OU=Organic Units/OU=Users/CN=Jean Dupond
	   6789 /DC=ch/DC=cern/OU=Organic Units/OU=Users/CN=Luc Martin

EXIT STATUS

       This program returns 0 if the operation was successful or >0 if the operation failed.

SEE ALSO

       Castor_limits(4), lfc_getusrbynam(3), lfc_getusrbyuid(3)

LFC
							   $Date: 2007/12/13 06:15:14 $ 					 LFC-LISTUSRMAP(1)
All times are GMT -4. The time now is 09:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy