Cmdlets for IBM Cloud SQL Query

Build 20.0.7654

Select-IBMCloudSQLQuery Cmdlet

Parameters   Output Objects  

Searches IBM Cloud SQL Query data.

Syntax

Select-IBMCloudSQLQuery [parameters]

Remarks

The Select-IBMCloudSQLQuery cmdlet allows you to use a syntax similar to SQL SELECT statements to search IBM Cloud SQL Query data.

$conn = Connect-IBMCloudSQLQuery -ApiKey "MyAPIKey" -InstanceCRN "myInstanceCRN" -Region "myRegion" -Schema "mySchema" -OAuthClientId "myOAuthClientId" -OAuthClientSecret "myOAuthClientSecret"
Select-IBMCloudSQLQuery -Connection $conn -Table "Jobs" -Columns @("Id","Status") -Where "UserId='gentit@cdata.com'"

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654