09-07-2010
i must switch the user for this action.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
I created a script to read a csv file with four columns. The script also saved values of each col in a arry.
In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file.
select Num from tableName
where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Discussion started by: Sherry_Run
1 Replies
3. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
4. Shell Programming and Scripting
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies
5. Shell Programming and Scripting
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies
6. Shell Programming and Scripting
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
7. Red Hat
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies
8. Shell Programming and Scripting
Hello Experts,
This sounds crazy, but one of my requirements is that if ID in 5th column in my input file (: separated) is not present in the oracle database table (say t_id) then this record should be skipped. I am using awk for all other requirements. So I was thinking if this requirement... (4 Replies)
Discussion started by: juzz4fun
4 Replies
9. UNIX for Dummies Questions & Answers
Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies
10. Shell Programming and Scripting
Hi ,
I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body.
p_id src_system amount
1 A 100
2 B 200
3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies
LEARN ABOUT DEBIAN
xkbsasetscreen
XkbSASetScreen(3) XKB FUNCTIONS XkbSASetScreen(3)
NAME
XkbSASetScreen - Sets the screenXXX field of act from s
SYNOPSIS
void XkbSASetScreen (XkbSwitchScreenAction act, int s);
ARGUMENTS
- act action in which to set screenXXX
- s value to set in screenXXX
DESCRIPTION
Actions associated with the XkbSwitchScreen action structure change the active screen on a multiscreen display.
The type field of the XkbSwitchScreenAction structure should always be XkbSA_SwitchScreen.
The flags field is composed of the bitwise inclusive OR of the masks shown in Table 1.
Table 1 Switch Screen Action Flags
-------------------------------------------------------------------
Flag Meaning
-------------------------------------------------------------------
XkbSA_SwitchAbsolute If set, the screenXXX field represents
the index of the new screen. Otherwise,
it represents an offset from the current
screen to the new screen.
XkbSA_SwitchApplication If not set, the action should switch to
another screen on the same server. Oth-
erwise, it should switch to another X
server or application that shares the
same physical display.
The screenXXX field is a signed character value that represents either the relative or absolute screen index, depending on the state of the
XkbSA_SwitchAbsolute bit in the flags field. Xkb provides the following macros to convert between the integer and signed character value
for screen numbers in XkbSwitchScreenAction structures.
STRUCTURES
typedef struct _XkbSwitchScreenAction {
unsigned char type; /* XkbSA_SwitchScreen */
unsigned char flags; /* controls screen switching */
char screenXXX; /* screen number or delta */
} XkbSwitchScreenAction;
NOTES
This action is optional. Servers are free to ignore the action or any of its flags if they do not support the requested behavior. If the
action is ignored, it behaves like XkbSA_NoAction. Otherwise, key press and key release events do not generate an event.
X Version 11 libX11 1.5.0 XkbSASetScreen(3)