Question and Answer What the utilities available in nz/bin? Driver: libnzodbc.so , Utilities : nzconvert, nzds, nzevent, nzhw, nzload, nzodbcsql, nzpassword, nzreclaim, nzrev, nzsession, nzsql, nzstate, nzstats, nzsystem Where is the Configuration file available? Config file odbc.ini is available in nz/lib and it contains the Database Source properties and Connection parameters. What is NZSQL utility? This utility can be run from any machine on which it is installed i.e. it does not have be from netezza box itself. This utility can be used to run any sql statement like select or insert statement on the netezza database. In the below usage you see data extracted from the table into a output file and in the second mzsql command the data is also gzipped. nzsql -host <netezz_db_servername> -d <database> -u <username> -pw <password> -c -c "select * from tablename" -o /root/home/outputfilename.txt; What is NZLOAD utility? This utility can be us
Data Load Using External Table External Table command can be used either on the Linux host or can be executed remotely through different clients like Squirrel, Aginity work bench etc. The only difference in the command when using remote client will be addition of REMOTESOURCE in Using section. For loading data from a file name Data.txt which is in D:\ and data is in comma delimited format as below For creating new table Employee in the Database(Test) below is the query. Here I am using ODBC driver for connecting to netezza engine we can also use JDBC and OleDB as options to connect. Also we should keep in mind that netezza does not support cross database access for DDL and DML, so out database should be selected properly in the Drop box as below. The below code should be run to create the Employee Table from the file D:\Data.txt Same data if we need to load through the Linux host then we can connect to the host through putty . Load the file to the host using filezi