Starting working with DB2 on unix:
You have to install dbd2 client software on your unix workstation and reboot it.
You have to source a db2profile file with all necessary environment
You have to catalog properly, for example:
db2 catalog tcpip node xxx remote somer_server server some_port
db2 catalog db some_db at node xxx
db2 connect to some_db
db2 list database directory
db2 catalog db sample at node xxx
db2 connect to sample
db2 "select * from syscat.tables fetch first 5 rows only"
(note the quotes around select - to hide from shell processing)
db2 -tvf myfile.sql - to run many commands from a file. Don't forget to separate SQL statments with ";"
db2 "select char(reviewed_date, ISO) from oe.OE_contact fetch first 10 rows only"
-------------------------------------------------
分享到:
相关推荐
starting out with python 2nd edition --Tony Gaddis
Get starting with vmware
Starting out with C++,英文原版,适合初学者
这是最新版 英文VB教材 starting out with visual basic 2012 2012年出版
Starting out with Visual C# 2012.3Ed
Starting Out with Java From Control Structures through Objects(6th) 英文无水印pdf 第6版 pdf所有页面使用FoxitReader和PDF-XChangeViewer测试都可以打开 本资源转载自网络,如有侵权,请联系上传者或csdn...
英文学习c++的很著名的一本书,很多中文书由此翻译而来,将会对你的学习提供一定的帮助
Starting Out With Python英文高清非扫描版。适合入门的Python英文版教材
In Starting Out with Python(R), Third Edition Tony Gaddis’ evenly-paced, accessible coverage introduces students to the basics of programming and prepares them to transition into more complicated ...
Starting Out with App inventor for android
从零开始程序入门级别的书,非常值得看Starting Out with Programming Logic and Design
Starting.Out.with.C++.from.Control.Structures.to.Objects.8th.Edition
Starting Out with Java_Early Objects, 入门教材,太细致了,也就太繁琐了。刚入门适用
Starting with HTML Help (126KB)
Starting Out with C++ Early Objects 9th Edition.pdf
美国高校Ivy League的Python入门教程,很适合入门学习用
starting out with java from control structures through objects 6th pdf 电子书
by machine learning starting with Excel VBA. The purpose of this document is to help general people to analyze financial markets using machine learning by combining Microsoft Excel and Liblinear ...
Starting Out with Java From Control Structures through Objects 6th Edition