Month: July 2017

Export the DDL of a DB2 database using db2look. Open the CLP. db2look -e -d <database> -z <schema> -t table(1),…,table(n) -o <path_to_file.sql> Use db2look to…

In Oracle this works: create table test(x integer default 0 not null) But this doesn’t: create table test(x integer not null default 0)

ResultSet tables = metaData.getTables(catalog, schema, tableName, null); // extract the tablenames for (String tableName : tablenames) { // ResultSet – each row is an index…

echo file.xml | xmllint –format – References https://stackoverflow.com/questions/16090869/how-to-pretty-print-xml-from-the-command-line