| function Invoke-DB2Query | |
| { | |
| <# | |
| .SYNOPSIS | |
| This function runs a query against a DB2 database. | |
| .DESCRIPTION | |
| This function runs a query against a DB2 database using the account of the user executing the command. | |
| .PARAMETER Server |
| # Variables | |
| $TargetFolderName = "ProviderSolution" | |
| $ProjectFilePath = "C:\temp\SSIS\TestSSISSolution\TestSSISProject\bin\Development\TestSSISProject.ispac" | |
| $ProjectName = "TestSSISProject" | |
| # Get the Integration Services catalog | |
| $ProviderCatalog = Get-Item SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\ | |
| # Create the target folder | |
| New-Object "Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder" ($ProviderCatalog, |
| $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 |
| Get-RsDeploymentConfig -RsProjectFile 'C:\Repos\GitHub\ReportingServicesTools\Tests\CatalogItems\testResources\TestProjects\SQLServerPerformanceDashboardReportingSolution\SQL Server Performance Dashboard\SQL Server Performance Dashboard.rptproj' -ConfigurationToUse Release | |
| FullPath : Release | |
| OverwriteDatasets : False | |
| OverwriteDataSources : False | |
| TargetReportFolder : SQL Server Performance Dashboard | |
| TargetDatasetFolder : /Datasets | |
| TargetDatasourceFolder : /Data Sources | |
| TargetReportPartFolder : Report Parts | |
| TargetServerURL : http://localhost/reportserver |
| irm https://gist.githubusercontent.com/SQLvariant/5cbad3dd52093fbd053ec46769a0fc22/raw/1ecf6c292a6c0b9419af01d7360d373a2adff3cd/Using_ConvertTo-SQLNoteBook.ipynb -OutFile Using_ConvertTo-SQLNoteBook.ipynb |
I like to get my code 'working' and then see if I can shorten the code, make it run faster, or maybe just reduce the number of variables I'm using.
However, sometimes I end up breaking things. At which point, I want to jump back to a version of the code that executed successfully. To do that, I sometimes use the code block below:
Get-History |
SELECT * |
Out-GridView -PassThru |
foreach { $_.CommandLine } | clip
| Invoke-ExecuteNotebook -InputNotebook .\DockerDesktop-with-SQL-PowerShell-90.ipynb -Parameters @{sa_password = 'Test9999'} |