Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Finding The Complete SQL statement Using PDFGREP Or Grep Post 303043623 by Scrutinizer on Sunday 2nd of February 2020 11:03:41 AM
Old 02-02-2020
Can you specify what does not work? The message presented is just a warning caused by the unnecessary backslash before the semicolon, but it should not change the outcome.
 

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
Jifty::Result(3pm)					User Contributed Perl Documentation					Jifty::Result(3pm)

NAME
Jifty::Result - Outcome of running a Jifty::Action DESCRIPTION
"Jifty::Result" encapsulates the outcome of running a Jifty::Action. Results are also stored on the framework's Jifty::Response object. new Construct a new action result. This is done automatically when the action is created, and can be accessed via the "result" in Jifty::Action. failure [BOOL] Gets or sets if the action succeeded or failed. success [BOOL] Gets or sets if the action succeeded or failed -- this is an alternate interface from "failure" but has the same effect. action_class [MESSAGE] Returns the class for the action that this result came from. message [MESSAGE] Gets or sets the action's response message. This is an informational textual description of the outcome of the action. error [ERROR] Gets or sets the action's error response. This is an informational textual description of what went wrong with the action, overall. This also automatically sets the result to be a "failure". field_error FIELD [ERROR] [OPTIONS] Gets or sets the error string for a specific field on the action. This also automatically sets the result to be a failure. "OPTIONS" is an optional set of key-value pairs; the only currently supported option is "force", which sets the "ajax_force_validate" for this field. field_errors Returns a hash which maps argument name to error. field_warning FIELD [WARNING] [OPTIONS] Gets or sets the warning string for a specific field on the action. "OPTIONS" is an optional set of key-value pairs; the only currently supported option is "force", which sets the "ajax_force_validate" for this field. field_warnings Returns a hash which maps argument name to warning. ajax_force_validate FIELD [VALUE] Gets or sets the flag which determines if warnings and errors are set using ajax validation, even if the field is empty. By default, validation warnings and errors are not shown for empty fields, as yelling to users about mandatory fields they've not gotten to yet is poor form. You can use this method to force ajax errors to show even on empty fields. field_canonicalization_note FIELD [NOTE] Gets or sets a canonicalization note for a specific field on the action. field_canonicalization_notes Returns a hash which maps argument name to canonicalization notes. content [KEY [, VALUE]] Gets or sets the content "KEY". This is used when actions need to return values. If not "KEY" is passed, it returns an anonymous hash of all of the "KEY" and "VALUE" pairs. as_hash This returns the results as a hash to be given directly to the end user (usually via REST or webservices). The difference between "$result->as_hash" and %$result is that the latter will expand everything as deeply as possible. The former won't inflate "refers_to" columns, among other things. perl v5.14.2 2010-09-25 Jifty::Result(3pm)
All times are GMT -4. The time now is 03:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy