six demon bag

2015-06-07

Using the DB2 Command Line Processer from PowerShell

Even for DB2 10.5 the official documentation says to use the db2cmd command for a Command Line Processor enabled environment on Windows:

On Windows operating systems, db2cmd command opens the CLP-enabled DB2® window, and initializes the DB2 command line environment.

However, being able to use PowerShell instead of db2cmd would be much nicer, since the former is far more versatile in practically every respect (control structures, output processing, file handling, etc.).

And it's actually rather simple, as I found out recently when reading this article. All that's required is setting one environment variable:

PS C:\> db2 'connect to sample'
DB21061E  Command Line Environment is not initialized.
PS C:\> Set-Item -Path env:DB2CLP -Value '**$$**'
PS C:\> db2 'connect to sample'

   Database Connection Information

 Database server        = DB2/NT64 10.5.1
 SQL authorization ID   = USERNAME
 Local database alias   = SAMPLE

PS C:\> _

Put the command in your profile to CLP-enable all your PowerShell prompts:

PS C:\> "Set-Item -Path env:DB2CLP -Value '**$$**'" >> $profile

Posted 01:38 [permalink]

Archives