Sponsored Content
Full Discussion: Check the value from Table
Top Forums Shell Programming and Scripting Check the value from Table Post 302916438 by gull04 on Wednesday 10th of September 2014 04:31:45 AM
Old 09-10-2014
Hi,

Then it is likely that you will have to follow these steps.
  1. Ensure that the script has the correct envirinment.
  2. Pass the output from your select statement to a variable or file.
  3. Parse the variable or file and check the value.
  4. If the value is true perform the action.

Regards

Dave
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

2. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

3. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

4. UNIX for Dummies Questions & Answers

To check, a table is used in a job

Hi, I have a list of jobs scheduled in unix. I want to check whether a particular view or table is used in a job. If they are not used, I can make changes to them. Thanks, Raaga (2 Replies)
Discussion started by: Raaga
2 Replies

5. UNIX for Dummies Questions & Answers

Creating a condensed table from a pre-existing table in putty

Hello, I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information. More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Discussion started by: Deedee393
5 Replies

6. Shell Programming and Scripting

Build a table from a list by comparing existing table entries

I am new to this shell scripting.... I have a file which contains list of users. This files get updated when new user comes into the system. I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Discussion started by: dchavan1901
3 Replies

7. Shell Programming and Scripting

Check a field in a table

I have made a table PRD_WORK_LM.test and it contains one field, ctrl_test. This field contains a 0 or a 1. I want to write a unix script that goes like this: IF ctrl_test = 1 THEN ... ELSE exit FI How can I write this in a script? Do I have to do this within bteq? or outside bteq? can... (5 Replies)
Discussion started by: katled
5 Replies

8. Shell Programming and Scripting

Help to check if Oracle table exists

I am trying to write a script which allows a user to select the what manipulation he needs to do on a table. I want to check if the table exists or not. If it exists I will continue the other things or else I exit saying table doesn't exist. How might I achieve this. (1 Reply)
Discussion started by: gmatcat
1 Replies

9. Programming

DB2 Query to check table counts,start end time

Dear team I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids . Currently i am using below query but this displays table name and counts for latest run. select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
0 Replies

10. Web Development

Getting Rid of Annoying Bootstrap Table Borders and Wayward Table Lines

Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer: <script> $(function(){ $('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
TUNA(8) 						  System Administration Utilities						   TUNA(8)

NAME
tuna - program for tuning running processes SYNOPSIS
tuna [OPTIONS] DESCRIPTION
This manual page explains the tuna program. The program can be used to change the attributes of application and kernel threads. The tuna can operate on IRQs by name or number, and tasks or threads by process ID or command-line. CPUs and sets of CPUs can be specified by CPU or socket number. IRQ names and process command-lines can include wildcards. tuna can change scheduling policy, scheduler priority and processor affinity for processes and process threads. tuna can also change the processor affinity for interrupts. When tuna is invoked without any options it starts up in its graphical interface mode. This manual page explains only the command-line options for tuna OPTIONS
tuna has both action options and modifier options. Modifier options must be specified on the command-line before the actions they are intended to modify. Any modifier option applies to following actions on the same command-line until it is over-ridden. Actions -h, --help Print a list of options. tuna will exit after this action, ignoring the remainder of the command-line. -g, --gui Start the GUI. Actions that follow this on the command-line will be processed without waiting for the GUI to complete. -a, --config_file_apply=profilename Apply changes described in profile -l, --config_file_list List preloaded profiles -i, --isolate Move all threads away from CPU-LIST. Requires -c or -S. -I, --include Allow all threads to run on CPU-LIST. Requires -c or -S. -m, --move Move selected entities to CPU-LIST. Requires -c and either -t or -q. -p, --priority=[POLICY:]RTPRIO Set thread scheduler tunables: POLICY and RTPRIO. POLICY is one of OTHER, FIFO, RR, or BATCH. Requires -t. -P, --show_threads Show thread list. -s, --save=FILENAME Save kthreads sched tunables to FILENAME. -v, --version Show version -W, --what_is Provides help about selected entities. Requires -t. -x, --spread Spread selected entities over CPU-LIST. Requires at least one of -t or -q. The specified threads and IRQs are each assigned to one cpu in CPU-LIST. Modifiers -c, --cpus=CPU-LIST CPU-LIST affected by commands. Requires a CPU number or a comma-separated list of CPU numbers. -C, --affect_children Operation will affect children threads. -f, --filter Disable display of selected CPUs in --gui. Requires -c -G, --cgroup Display the processes with the type of cgroups they are in. Requires -P -K, --no_kthreads Operations will not affect kernel threads. -q, --irqs=IRQ-LIST IRQ-LIST affected by commands. Requires an IRQ number or a comma-separated list of IRQ numbers. -S, --sockets=CPU-SOCKET-LIST CPU-SOCKET-LIST affected by commands. Requires a socket number or a comma-separated list of socket numbers. -t, --threads=THREAD-LIST THREAD-LIST affected by commands. Requires a thread number or thread name, or a comma-separated list of thread numbers and/or names. Thread names may contain wildcards. Be sure to quote or escape any wildcard specifications. -U, --no_uthreads Operations will not affect user threads. USAGE EXAMPLES
If for instance the Ethernet NICs have multiple queues for both receive and transmit, each with its own IRQ, the Ethernet IRQs can be asso- ciated with a CPU socket: tuna -S 2 -i -q 'eth*' -x Move everything off the CPUs in socket 2, then spread the IRQs for the Ethernet devices acrross those same CPUs. tuna February 2010 TUNA(8)
All times are GMT -4. The time now is 09:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy