Stored Procedures
Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.
CData JDBC Driver for Azure Data Lake Storage Stored Procedures
Name | Description |
CopyFile | Copy a file from a source to a destination. |
CreateFile | Create a file. Path is required for a successful operation. |
CreateFolder | Create a folder. Path is required for a successful operation. |
DeleteObject | Delete a file or a folder. Path is required for a successful operation. |
DownloadFile | Download a file. Path and DownloadPath are required for a successful operation. |
GetOAuthAccessToken | Gets the OAuth access token from SharePoint. |
GetOAuthAuthorizationURL | Gets the SharePoint authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to SharePoint. |
RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with SharePoint. |
RenameObject | Rename a file or a directory. Path and RenameTo are required for a successful operation. |
UploadFile | Upload a File. Path and FilePath are required for a successful operation. |