How to export Sybase database table records
1 Execute the Start Sybase database command
Code:
Dbeng7 GKDB
2 Executing the Connect Sybase database command
Code:
Dbisql-c "uid=dba111;pwd=222sql;eng=gk333db"-Q oilvouch.sql
3 Execute SQL script file Oilvouch.sql export file Oilvouch.txt
Code
Select Top Ten * from Oilvouch;
Output To/root/oilvouch.txt format ASCII;
Commit
---------------------------------------------
The shell is as follows:
Dbeng7 GKDB
Dbisql-c "uid=dba111;pwd=222sql;eng=gk333db"-Q oilvouch.sql
==============================================
The SQL changes are as follows:
Select Top Ten Ttc,cardno,machineoilno,oilno,takedate,oilgunno,
Openo,liter,price,amount,balance,pumpno,paymode,payunit,accountdate,tracode,
Getttime,teamvouchno,transflag,billstatus from Oilvouch ORDER BY takedate Desc
===============================================
Final System implementation:
1 Oildata_vouch.sql
Select top * from Oilvouch order by takedate Desc;
Output To/root/oilvouch.txt format ASCII;
Commit
2 Oildata_export
Dbisql-c "UID=DBA;PWD=SQL;ENG=GKDB"-Q oildata_vouch.sql
MV Oilvouch.txt/opt/vouchoil.txt
3 oildata_py
#! /user/bin/env python
#coding =utf-8
Import Time,os,sched,shutil
Schedule=sched.scheduler (Time.time,time.sleep)
def perform_command (cmd,inc):
Schedule.enter (Inc,0,perform_command, (Cmd,inc))
Os.system (CMD)
def timming_exe (cmd,inc=60):
Schedule.enter (Inc,0,perform_command, (Cmd,inc))
Schedule.run ()
Print ("EXE run.. Shell after ten senconds ")
#result =os.popen ("Dbeng7 gkdb")
Result=os.popen ("Dbeng7/smc20/database/gkdb.db")
Print (Result)
Timming_exe ("./oildata_export", 10)
#shutil. Copy ("Oilvouch.txt", "/opt/oilvouch.txt")
How does Python export Sybase database table records under Linux