Uploaded via PowerShell

Query_DB2.ps1

$dbName="SAMPLE"
$server="not.my.localhost"

#Define connection string for the database
$cn = new-object system.data.OleDb.OleDbConnection("server=$($server);Provider=IBMDADB2;DSN=$($dbName);trusted_connection=true;");
#Define data set for first query
$ds = new-object "System.Data.DataSet" "ds"
#Define query to run
$q = "select * from hello_world"
# Define data object given the specific query and connection string
$da = new-object "System.Data.OleDb.OleDbDataAdapter" ($q, $cn)
# Fill the data set - essentially run the query. 
$da.Fill($ds) | Out-Null
# Print the result
foreach ($Rows in $ds.Tables[0].Rows)
        {
        $Rows | Format-Table
        }

# Close the Connection
$cn.close()