How to run multiple Queries in a ksh Script? Post: 302920656

Sponsored Content

Top Forums Shell Programming and Scripting How to run multiple Queries in a ksh Script? Post 302920656 by DGPickett on Friday 10th of October 2014 04:27:27 PM

10-10-2014

Registered User

The trick to SQL is thinking in sets and joins, not procedurally. This is a big leap for many procedural coders. I have seen too many loops that should be joins. For instance:

Code:

This could just be a table & column in the following join:
 
declare @swexpire int
select @swexpire=value from master.dbo.sysconfigures
    where name = 'systemwide password expiration
 
This is just a constant:
 
@xerox_emp = "N"
 
This is unused:
 
declare @LoginExpInt int
 
This should just be a calculated column in the target list:
 
ALTER TABLE tempdb.dbo.SYBASE_EXPIRED_LOGINS add NumDaysToExp INT DEFAULT (0);
GO 
Update tempdb.dbo.SYBASE_EXPIRED_LOGINS
Set  NumDaysToExp = Case when PasswordExpInt !=0 Then  DATEDIFF(DAY, getdate(), PasswordExpDate) Else 0 end
 
becomes the new end of the target list:
 
   , Case when PasswordExpInt !=0 Then DATEDIFF(DAY, getdate(), PasswordExpDate) Else 0 end AS NumDaysToExp 
 
Now the first query can just be a single select in a derived table.

DGPickett

View Public Profile for DGPickett

Find all posts by DGPickett

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Run ksh script from cgi

Hi, I'm developing a system which requires me to run a ksh script from within a cgi script. What sort of syntax will I need to do this, I'm sure it's simple but can't find out how anywhere! Thanks.

2. Shell Programming and Scripting

Multiple MySql queries in shell script?

Hi guys, i know how to run a single query using mysql embedded in a shell script as follows: `mysql -umyuser -pmypass --host myhost database<<SQL ${query}; quit SQL` However, how would i be able to run several queries within the same connection? The reason for this is i am creating...

3. Shell Programming and Scripting

KSH script to run other ksh scripts and output it to a file and/or email

Hi I am new to this Scripting process and would like to know How can i write a ksh script that will call other ksh scripts and write the output to a file and/or email. For example ------- Script ABC ------- a.ksh b.ksh c.ksh I need to call all three scripts execute them and...

4. Shell Programming and Scripting

run script through crontab using ksh

hi i have a script called test.sh. the content is ls >> crontest.txt. if i run manually it's giving output.but if i scheduled in crontab it's not giving output. crontab entry: 02 * * * * /sms5/SMSHOME/eds_sh/test.sh >> /sms5/SMSHOME/eds_sh/testfile/logfile 2>&1 I am using ksh.is there...

5. Shell Programming and Scripting

How to store results of multiple sql queries in shell variables in ksh?

Hi, I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else. Thanks in advance.. Cheers

6. Shell Programming and Scripting

Run script in a backgroun - ksh

i ran the below in ksh... nohup <script> & it is runnign in background. now how do i see if the above command is success... i also need to bring the command to foreground and view the run details. pls advise how to do that...

7. Shell Programming and Scripting

How to run multiple .py in ksh?

Hi programmers, say I have 4 files : file1.py,file2.py,file3.py,file4.py How do I, on a korn shell, create one file, run_all, that is one file that sequentially calls file1-file4, but only so if they complete w/o errors? Something like: #!/usr/bin/ksh file1.py /*......????*/ ...

8. Linux

How to store count of multiple queries in variables in a shell script?

how to store the count of queries in variables inside a filein shell script my output : filename ------- variable1=result from 1st query variable2=result from 2nd query . . . .

9. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required.

10. Shell Programming and Scripting

run sql queries from UNIX shell script.

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX? :confused:

LEARN ABOUT OPENSOLARIS

let

let(1)								   User Commands							    let(1)

NAME

       let - shell built-in function to evaluate one or more arithmetic expressions

SYNOPSIS

   ksh
       let arg...

   ksh93
       let [expr...]

DESCRIPTION

   ksh
       Each arg is a separate arithmetic expression to be evaluated.

   ksh93
       let  evaluates  each expr in the current shell environment as an arithmetic expression using ANSI C syntax. Variables names are shell vari-
       ables and they are recursively evaluated as arithmetic expressions to get numerical values. let has been made obsolete by the ((...))  syn-
       tax of ksh93(1) which does not require quoting of the operators to pass them as command arguments.

EXIT STATUS

   ksh
       ksh returns the following exit values:

       0    The value of the last expression is non-zero.

       1    The value of the last expression is zero.

   ksh93
       ksh93 returns the following exit values:

       0     The last expr evaluates to a non-zero value.

       >0    The last expr evaluates to 0 or an error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       ksh(1), ksh93(1), set(1), typeset(1), attributes(5)

SunOS 5.11							    2 Nov 2007								    let(1)