建站
咨詢
售后
建站咨詢
新聞中心
DB2執(zhí)行SQL語句如何才不會報(bào)錯呢？這是很多人都提到過的問題，下面就就教您DB2執(zhí)行SQL語句并導(dǎo)出表記錄的實(shí)現(xiàn)方法，供您參考。
為企業(yè)提供成都做網(wǎng)站、網(wǎng)站建設(shè)、網(wǎng)站優(yōu)化、成都營銷網(wǎng)站建設(shè)、競價(jià)托管、品牌運(yùn)營等營銷獲客服務(wù)。創(chuàng)新互聯(lián)公司擁有網(wǎng)絡(luò)營銷運(yùn)營團(tuán)隊(duì)，以豐富的互聯(lián)網(wǎng)營銷經(jīng)驗(yàn)助力企業(yè)精準(zhǔn)獲客，真正落地解決中小企業(yè)營銷獲客難題，做到“讓獲客更簡單”。自創(chuàng)立至今，成功用技術(shù)實(shí)力解決了企業(yè)“網(wǎng)站建設(shè)、網(wǎng)絡(luò)品牌塑造、網(wǎng)絡(luò)營銷”三大難題，同時(shí)降低了營銷成本，提高了有效客戶轉(zhuǎn)化率，獲得了眾多企業(yè)客戶的高度認(rèn)可！
很多人在console寫DB2 SQL語句的時(shí)候習(xí)慣性的按enter換行,結(jié)果語句就直接執(zhí)行報(bào)錯.這是因?yàn)镈B2默認(rèn)的分隔符是空格,
如果要換行寫語句,就必須在每行語句結(jié)尾加\,\表示換行.
還有一個(gè)寫法就是連接DB2后,輸入命令db2 -t, 這樣就不需每行語句結(jié)尾都加\.只需按enter換行,語句寫完后輸入分號(;) 提交語句運(yùn)行.
推薦使用下面的方式在DB2執(zhí)行SQL語句并導(dǎo)出表記錄.
- JXBI_js1:/db2home/mart796>touch crw.txt
- JXBI_js1:/db2home/mart796>db2 CONNECT TO jxmart USER ***** USING ******
- Database Connection Information
- Database server = DB2/AIX64 8.2.5
- SQL authorization ID = MART796
- Local database alias = JXMART
- ###db -t 命令指示語句允許換行,以分號;作結(jié)束符###
- JXBI_js1:/db2home/mart796>db2 -t
- (c) Copyright IBM Corporation 1993,2002
- Command Line Processor for DB2 SDK 8.2.5
- You can issue database manager commands and SQL statements from the command
- prompt. For example:
- db2 => connect to sample
- db2 => bind sample.bnd
- For general help, type: ?.
- For command help, type: ? command, where command can be
- the first few keywords of a database manager command. For example:
- ? CATALOG DATABASE for help on the CATALOG DATABASE command
- ? CATALOG for help on all of the CATALOG commands.
- To exit db2 interactive mode, type QUIT at the command prompt. Outside
- interactive mode, all commands must be prefixed with 'db2'.
- To list the current command option settings, type LIST COMMAND OPTIONS.
- For more detailed help, refer to the Online Reference Manual.
- db2 => EXPORT TO "/db2home/mart796/crw.txt" OF DEL MODIFIED BY coldel0x09
- db2 (cont.) => SELECT RN_USER_ID,
- db2 (cont.) => HIS_USER_ID,
- db2 (cont.) => RN_USER_NUMBER,
- db2 (cont.) => HIS_USER_NUMBER,
- db2 (cont.) => RN_BASE_COUNTY_CODE,
- db2 (cont.) => RN_BASE_PLAN_ID,
- db2 (cont.) => RN_CREATE_DATE
- db2 (cont.) => FROM JA.MARTD_DMRN_USER_MS
- db2 (cont.) => WHERE RN_DATE = '2008-07-01'
- db2 (cont.) => ;
- SQL3104N The Export utility is beginning to export data to file
- "/db2home/mart796/crw.txt".
- SQL3105N The Export utility has finished exporting "554848" rows.
- Number of rows exported: 554848
- db2 => quit;
- DB20000I The QUIT command completed successfully.
到此,總共導(dǎo)出584848條記錄.接下來的便是把記錄get 下來,導(dǎo)入到本地的ORACLE數(shù)據(jù)庫.比較簡單.
【編輯推薦】
DB2 CREATE SERVER語句的用法
常用的DB2管理命令
深入探討DB2表連接原理
幾種常用的DB2循環(huán)用法
DB2創(chuàng)建數(shù)據(jù)庫的實(shí)現(xiàn)
分享文章：DB2執(zhí)行SQL語句并導(dǎo)出表記錄的實(shí)現(xiàn)方法
分享URL：http://fisionsoft.com.cn/article/coojpgd.html
