WinSQL allows you to run SQL queries passed from a command line.
You can either run saved SQL queries in a plain text file or run export
routines saved as a WinSQL export template.
The following example shows how to run SQL scripts saved in a text file using WinSQL.
The following example runs queries stored in
c:\scripts\myScripts.sql file using "YourDNS" as the data source,
"YourUserID" as the user id, and "YourPwd" as your password. The "-a"
option tells WinSQL to exit once the queries are completed. The
"-oc:\output.txt" argument tells WinSQL to write any error messages to
Posted by mpjain on 4/20/11 11:49 AM
CREATE TABLE USKCPL.PAYALLSAL
DCIDEA CHAR(6) NOT NULL,
DCIDEN SMALLINT NOT NULL,
NAME CHAR(25) NOT NULL,
DAYS DECIMAL(8,2) ,
DCMCA INT ,
BAS INT ,
HRA INT ,
CONV INT ,
MED INT ,
WAS INT ,
DRV INT ,
FUEL INT ,
ENT INT ,
TOTE INT ,
ADV INT ,
EPF INT ,
ESI INT ,
ITAX INT ,
LOAN INT ,
PF INT ,
PTAX INT ,
TOTD INT ,
NET INT )
INSERT INTO USKCPL.PAYALLSAL (PAYDATE,DCIDEA,DCIDEN,name,DAYS,dcmca,BAS,HRA,CONV,MED,WAS,DRV,FUEL,ENT,TOTE,ADV,EPF,ESI,ITAX,LOAN,PF,PTAX,TOTD,NET)
DELETE FROM USKCPL.PAYSALARY
Requirements is above three steps : run continuesly, Step-I is Create Step-II is insert Step-III is Delete., what is continue run exec command in above scripts....Pl.advswe....MPJAIN
Do you have a helpful tip related to this document that you'd like to share
with other users? Please add it below. Your name and tip will appear at the
end of the document text.