If you are connected to what was formerly known as an AS/400, when it was sold as an integrated system (for more than 10 years it has been sold as...

• This reply was modified 1 years, 4 months ago by kaj.

Sorry, it's not clear to me what you want to achieve. You write very well, but somehow still fail to describe what you want in a way that I can...

And on the topic of getting and installing data drivers for the IBM i DB2, a good place to start would probably be

https://ibmi-oss-docs.readthedocs.io/en/latest/odbc/installation.html

If this is in fact running on some version of OS/400 (or now IBM i) you could perhaps try to query it in SQL?

https://stackoverflow.com/questions/73732462/sql-query-to-get-db2-version-on-ibm-i

I'm not sure if you're aware of this, but when you catch an error in sp2, you're effectively annulling the error, ie. it will not automatically "bubble up" to the...

Duplicate! 🙁

• This reply was modified 1 years, 4 months ago by kaj.

Like this?

drop table if exists #RawInput;
go
drop table if exists #FinalOutput;
go
create table #RawInput  (
    Whatever varchar(500) not null
    );
create table #FinalOutput...

Consider changing the report from using one embedded monster query into a call to a stored procedure where you can split the original query up into several lean and mean...

• This reply was modified 1 years, 7 months ago by kaj. Reason: typos

1. At a guess I would say the difference stems from the fact that because the temp table isn't actually created and thus has no metadata the compiler can check...

• This reply was modified 1 years, 7 months ago by kaj.

I have had situations where I simply couldn't make a execute using WITH RESULT SETS work.

I solved the issue by changing the sp to specify a dummy table variable with...

Based on ratbak's second query, I think you can simplify it a little more by using a combination of AVG and NULLIF:

WITH subquery AS 
(
SELECT 
 ...

I'm not really familiar with Oracle, but this seems like something universal, so I will give it a try.

SELECT Id,
       SUM(CASE...

Just remove the GO - there's no need for it.

SET @view_code = N'CREATE VIEW [' + 'PGCPS_CUSTOM' + '].[' + @table_name + '_VW] ' + @line_break +

'AS ' + @line_break...

Long shot: Have you changed the batch separator to something different than the default? That would produce the error you describe.

In SSMS check

Tools-> Options -> Query Execution -> General

and

Query... ->...

No, only VB.NET and C#.NET is supported.

https://learn.microsoft.com/en-us/sql/integration-services/control-flow/script-task?view=sql-server-ver16

Options

ScriptLanguage

Select the scripting language for the task, either Microsoft Visual Basic or Microsoft Visual C#.