Convert a vertical query result to horizontal

Convert a vertical query result to horizontal SID STUDENT VALUE 5 FNAME Bruce 5 LNAME Wayne 5 AGE 31 5 EMAIL bwayne@brunceneterprise.com

  Result: FIRST_NAME LAST_NAME AGE EMAIL Brunce …

Read More

How to add a new Linux user with db2 access

How to add a new Linux user with db2 access

If you need to grant the JBOND user certain privileges, the privilege assignment can …

Read More

DB2 Export and Import Data

Here are the steps on how to export and import data from and to database in the delimited (.del) format. 1. Export:

2. Import

Note: if a table …

Read More