to find whether update query is successfull or not using Ksh Script Post: 302274165

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing result of query to a varibale in ksh script

Hi, I have a scenario where in i have to extarct max of one column and pass it to a variable. i have tried to export the result as .dat file and read from that file.But my database is mainframe and it is not permitting me to export in .dat file.I have tried using .ixf file but reading from...

2. Shell Programming and Scripting

Script not successfull in cron

Hi, I have a script to FTP the files to other unit. Manually this script is running fine & files are getting transferred. But running the same script using crontab does not transfer files, although the cron log shows that the file was executed. PLz suggest

3. Shell Programming and Scripting

Tables to query to find users for database from shell script

I am coding shell script. I need to connect to different databases like DB2, Oracle and Sybase. I would then need to query tables where it has all the groups, users for that database. I would also need who has what kind of permissions. EG: I know for DB2 some TABAUTH table needs to be...

4. Shell Programming and Scripting

Exit for loop in a shell script if a condition is successfull

Hi All, I am stuch in a script where a for loop is running to execute some commands for some values. Now my problem is i have to have an if condition that if the first iteration is successful then it has to exit the for loop otherwise it has to continue normally. my code is this: for...

5. Shell Programming and Scripting

trying to run this script from unix but the script is not successfull

Hi I am trying to run the below unix script in informatica comamnd task the script is in placed in the path (this script checks if the files are present in other server ) ------------------------------------------------------------------...

6. Shell Programming and Scripting

calling another script if it's contains SUCCESSFULL how?

Hi all, i'm a newbie here, I'm just wondering how can i call my second script if it's contain successfull. script1.sh how can i call my 2nd script if he contain SUCCESSFULL script2.sh SUCCESSFULL please advise, Thanks,

7. Shell Programming and Scripting

How to write a update query in perl script?

can any one suggest me on how to write a update query in perl script for Oracle database and also tell me abt how we can write a code for sending mails with report as attachment to appropriate persons?

8. Shell Programming and Scripting

Shell Script (ksh) - SQLPlus query filter using a string variable

Using ksh, I am using SQLPlus to execute a query with a filter using a string variable. REPO_DB=DEV1 FOLDER_NM='U_nmalencia' FOLDER_CHECK=$(sqlplus -s /nolog <<EOF CONNECT user/pswd_select@${REPO_DB} set echo off heading off feedback off select subj_name from subject where...

9. UNIX for Dummies Questions & Answers

Extract only the data from ksh script running netezza query

Hi I searched this forum before posting the question, but couldnt find it, the issue i'm facing is, i'm trying to select a column from a netezza table from a korn shell script, but the query runs var=$(nzodbcsql -q "select MAX(millcount) from table1";) echo $var it returns the value like...

LEARN ABOUT DEBIAN

printfail

MESSAGES(3)						  libbash messages Library Manual					       MESSAGES(3)

NAME

     messages -- libbash library that implements a set of functions to print standard status messages

SYNOPSIS

     printOK	 [indent]
     printFAIL	 [indent]
     printNA	 [indent]
     printATTN	 [indent]
     printWAIT	 [indent]

DESCRIPTION

   General
     messages is a collection of functions to print standard status messages - those [ OK ] and [FAIL] messages you see during Linux boot process.

     The function list:
	   printOK	    Prints a standard [ OK ] message (green)
	   printFAIL	    Prints a standard [FAIL] message (red)
	   printNA	    Prints a standard [ N/A] message (yellow)
	   printATTN	    Prints a standard [ATTN] message (yellow)
	   printWAIT	    Prints a standard [WAIT] message (yellow)

     Detailed interface description follows.

   indent
     Column to move to before printing.

     Default indent is calculated as TTY_WIDTH-10. If current tty width can not be determined (for example, in case of serial console), it
     defaults to 80, so default indent is 80-10=10

FUNCTIONS DESCRIPTIONS

   printOK [indent]
     Prints a standard [ OK ] message (green)

   printFAIL [indent]
     Prints a standard [FAIL] message (red)

   printNA [indent]
     Prints a standard [ N/A] message (yellow)

   printATTN [indent]
     Prints a standard [ATTN] message (yellow)

   printWAIT [indent]
     Prints a standard [WAIT] message (yellow)

EXAMPLES

     Run a program named MyProg, and report it's success or failure:

	      echo -n 'Running MyProg...'
	      printWAIT
	      if MyProg ; then
		      printOK
	      else
		      printFAIL
	      fi

AUTHORS

     Hai Zaar <haizaar@haizaar.com>
     Gil Ran <gil@ran4.net>

SEE ALSO

     ldbash(1), libbash(1)

Linux								       Epoch								     Linux