Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Finding The Complete SQL statement Using PDFGREP Or Grep
Top Forums UNIX for Beginners Questions & Answers Finding The Complete SQL statement Using PDFGREP Or Grep Post 303043664 by vgersh99 on Monday 3rd of February 2020 09:55:48 AM
Old 02-03-2020
Code:
gawk -v IGNORECASE=1 '....'

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Rerun sql statement

Hi, Script that I wrote only run sql query once then exit. But my requirement, I want the query can be execute a couple of time without exiting the script. How could I do it? Thanks. (1 Reply)
Discussion started by: killboy
1 Replies

2. Shell Programming and Scripting

Executing sql statement from .sh file

Hi, How to execute sql statements from the .sh file ?? Means, when we run .sh file then the sql statements within it should be get executed one by one from the sqlplus With Regards (3 Replies)
Discussion started by: milink
3 Replies

3. UNIX for Dummies Questions & Answers

Can grep command return word instead of complete line

Hi Is there any way GREP command can return word and not complete line. My file has following data: Hello Everyone I am NitinrajSrivastava Hi Friends Welcome VrajSrivastava I am using grep 'raj' which is returning me complete line.However I want only the word having keyword 'raj'. Required... (11 Replies)
Discussion started by: dashing201
11 Replies

4. Shell Programming and Scripting

Read SQL statement in Script

Hi Guys.. need some urgent help... I am stuck in something badly I need to write a script which would read a sql statement (which might be a join/inner join/select/sub select etc. ) I need to read that sql statement ... and in the output I want all the table names and columns (doesn't... (4 Replies)
Discussion started by: freakygs
4 Replies

5. Shell Programming and Scripting

Script to batch pdfjoin based on pdfgrep output

I have a situation in which I'm given a bunch of pdf files which are all single pages with employee ID's on an independent line. I need to collate all of the pages by employee ID. Piecemeal, I can find a particular employee ID by just using pdfgrep. I could also do something like this: find .... (3 Replies)
Discussion started by: nopposan
3 Replies

6. Shell Programming and Scripting

issues with sql inside if statement

Hi, I have problem with the following code. My IF block is not executed. And I see "syntax error near unexpected token `)'" error for line "EOF" in the stats_function(). but when I comment the IF block I don't see this error. Kindly help me with this issue. clean_function() {... (10 Replies)
Discussion started by: babom
10 Replies

7. Shell Programming and Scripting

UNIX variable to SQL statement

The following is my script : #!/bin/bash echo "please give app_instance_id" read app_instance_id echo "id is $app_instance_id" export app_id=app_instance_id sqlplus -s nnviewer/lookup@//nasolora008.enterprisenet.org:1521/LOAD3 @test.sql<<EOF SPOOL /home/tibco/MCH/Data/qa/raak/name.xls... (4 Replies)
Discussion started by: raakeshr
4 Replies

8. Shell Programming and Scripting

Need help for finding and killing sql process

hi, iam completely new to scripting. this may sound naive but i have spend lot of time figuring this out. i want to make a script to find number of sql processes running. If the number of processes are more then 200, then pick out process IDs along with query it is executing, which are running... (0 Replies)
Discussion started by: Prateek Suhag
0 Replies

9. Shell Programming and Scripting

Grep command is not search the complete pattern

I am facing a problem while using the grep command in shell script. Actually I have one file (PCF_STARHUB_20130625_1) which contain below records. SH_5.55916.00.00.100029_20130601_0001_NUC.csv.gz|438|3556691115 SH_5.55916.00.00.100029_20130601_0001_Summary.csv.gz|275|3919504621 ... (2 Replies)
Discussion started by: sumit.vedi1988
2 Replies

10. UNIX for Beginners Questions & Answers

Using df -g command with awk to get SQL statement

Hi Gurus... good day; currently I trying to run the df -g command with awk to get to convert in SQL statement, but I have some errors; df -g | awk '{print "This is the FileSystem: " $NF, " This is LV: "$1, "This is SIZE: "$2, "This is FREE: " $3, "This is the USED% "$4}' This on AIX... (3 Replies)
Discussion started by: wcastibl
3 Replies

LEARN ABOUT DEBIAN

ansi_cattr

term::ansi::code::attr(3tcl)					 Terminal control				      term::ansi::code::attr(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       term::ansi::code::attr - ANSI attribute sequences

SYNOPSIS

       package require Tcl  8.4

       package require term::ansi::code  ?0.1?

       package require term::ansi::code::attr  ?0.1?

       ::term::ansi::code::attr::names

       ::term::ansi::code::attr::import ?ns? ?arg...?

       ::term::ansi::code::attr::fgblack

       ::term::ansi::code::attr::fgred

       ::term::ansi::code::attr::fggreen

       ::term::ansi::code::attr::fgyellow

       ::term::ansi::code::attr::fgblue

       ::term::ansi::code::attr::fgmagenta

       ::term::ansi::code::attr::fgcyan

       ::term::ansi::code::attr::fgwhite

       ::term::ansi::code::attr::fgdefault

       ::term::ansi::code::attr::bgblack

       ::term::ansi::code::attr::bgred

       ::term::ansi::code::attr::bggreen

       ::term::ansi::code::attr::bgyellow

       ::term::ansi::code::attr::bgblue

       ::term::ansi::code::attr::bgmagenta

       ::term::ansi::code::attr::bgcyan

       ::term::ansi::code::attr::bgwhite

       ::term::ansi::code::attr::bgdefault

       ::term::ansi::code::attr::bold

       ::term::ansi::code::attr::dim

       ::term::ansi::code::attr::italic

       ::term::ansi::code::attr::underline

       ::term::ansi::code::attr::blink

       ::term::ansi::code::attr::revers

       ::term::ansi::code::attr::hidden

       ::term::ansi::code::attr::strike

       ::term::ansi::code::attr::nobold

       ::term::ansi::code::attr::noitalic

       ::term::ansi::code::attr::nounderline

       ::term::ansi::code::attr::noblink

       ::term::ansi::code::attr::norevers

       ::term::ansi::code::attr::nohidden

       ::term::ansi::code::attr::nostrike

       ::term::ansi::code::attr::reset

_________________________________________________________________

DESCRIPTION

       This package provides symbolic names for the ANSI attribute control codes. For each control code a single command is provided which returns
       this code as its result. None of the commands of this package write  to	a  channel;  that  is  handled	by  higher  level  packages,  like
       term::ansi::send.

API

   INTROSPECTION
       ::term::ansi::code::attr::names
	      This command is for introspection. It returns as its result a list containing the names of all attribute commands.

       ::term::ansi::code::attr::import ?ns? ?arg...?
	      This  command imports some or all attribute commands into the namespace ns. This is by default the namespace attr. Note that this is
	      relative namespace name, placing the imported command into a child of the current namespace. By default all commands  are  imported,
	      this can howver be restricted by listing the names of the wanted commands after the namespace argument.

   ATTRIBUTES
       ::term::ansi::code::attr::fgblack
	      Set text color to Black.

       ::term::ansi::code::attr::fgred
	      Set text color to Red.

       ::term::ansi::code::attr::fggreen
	      Set text color to Green.

       ::term::ansi::code::attr::fgyellow
	      Set text color to Yellow.

       ::term::ansi::code::attr::fgblue
	      Set text color to Blue.

       ::term::ansi::code::attr::fgmagenta
	      Set text color to Magenta.

       ::term::ansi::code::attr::fgcyan
	      Set text color to Cyan.

       ::term::ansi::code::attr::fgwhite
	      Set text color to White.

       ::term::ansi::code::attr::fgdefault
	      Set default text color (Black).

       ::term::ansi::code::attr::bgblack
	      Set background to Black.

       ::term::ansi::code::attr::bgred
	      Set background to Red.

       ::term::ansi::code::attr::bggreen
	      Set background to Green.

       ::term::ansi::code::attr::bgyellow
	      Set background to Yellow.

       ::term::ansi::code::attr::bgblue
	      Set background to Blue.

       ::term::ansi::code::attr::bgmagenta
	      Set background to Magenta.

       ::term::ansi::code::attr::bgcyan
	      Set background to Cyan.

       ::term::ansi::code::attr::bgwhite
	      Set background to White.

       ::term::ansi::code::attr::bgdefault
	      Set default background (Transparent).

       ::term::ansi::code::attr::bold
	      Bold on.

       ::term::ansi::code::attr::dim
	      Dim on.

       ::term::ansi::code::attr::italic
	      Italics on.

       ::term::ansi::code::attr::underline
	      Underscore on.

       ::term::ansi::code::attr::blink
	      Blink on.

       ::term::ansi::code::attr::revers
	      Reverse on.

       ::term::ansi::code::attr::hidden
	      Hidden on.

       ::term::ansi::code::attr::strike
	      Strike-through on.

       ::term::ansi::code::attr::nobold
	      Bold off.

       ::term::ansi::code::attr::noitalic
	      Italics off.

       ::term::ansi::code::attr::nounderline
	      Underscore off.

       ::term::ansi::code::attr::noblink
	      Blink off.

       ::term::ansi::code::attr::norevers
	      Reverse off.

       ::term::ansi::code::attr::nohidden
	      Hidden off.

       ::term::ansi::code::attr::nostrike
	      Strike-through off.

       ::term::ansi::code::attr::reset
	      Reset all attributes to their default values.

BUGS, IDEAS, FEEDBACK
       This  document, and the package it describes, will undoubtedly contain bugs and other problems.	Please report such in the category term of
       the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you  may  have  for
       either package and/or documentation.

KEYWORDS

       ansi, attribute control, color control, control, terminal

CATEGORY

       Terminal control

COPYRIGHT

       Copyright (c) 2006 Andreas Kupries <andreas_kupries@users.sourceforge.net>

term									0.1					      term::ansi::code::attr(3tcl)
All times are GMT -4. The time now is 10:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy