Cmdlets for IBM Cloud SQL Query

Build 20.0.7654

RecentJobs

Query information regarding recent executed jobs. At most, information about the 30 latest jobs will be returned.

Table Specific Information

Select

The driver uses the IBM Cloud SQL Query API to process search criteria that refer to JobId columns.

  • JobId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM RecentJobs WHERE JobId = '86402b0c-4665-4936-b0ff-e5051f5f5a49'

Columns

Name Type Description
JobId String The id of the job.
Statement String The statement sent to the API for the job.
Status String The status of the job.

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