<< January 2015 | Home | March 2015 >>

Nice way to export from DB2 command line

Stumbled on this very nice easy way to export to a delimited file from the DB2 Command Line Prompt (CLI) today.

db2 "EXPORT TO <filename> OF DEL MODIFIED BY NOCHARDEL <select statement>"
i.e.
db2 "EXPORT TO result.csv OF DEL MODIFIED BY NOCHARDEL select * from empinst.employee"

Tags : , , ,

Hiding widget on my own profile

Was looking through widgets-config.xml for IBM Connections v.5 to diagnose a customer issue and stumbled on the below widgetDef attribute. Now I haven't tried it yet but it looks like you can use it to hide a certain widget on your own profile e.g. only show when viewing other peoples profile. Could be useful.

hideWidgetForMyProfile="true"