Recent questions tagged DB2

0 votes

1.5k views

1 answer

db2 - SQL Developer "disconnected from the rest of the join graph"

I have the following SQL: select <misc things> from pluspbillline left outer join workorder on workorder.siteid= ... What does this mean? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

541 views

1 answer

db2 - Passing comma separated value as an IN parameter in stored procedure

I am new to DB2 queries. Here, I am passing a comma separated value as an IN parameter in a Stored Procedure. ... way to do it without UDF. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

446 views

1 answer

db2 - Valid date verification in SQL

I have a column that holds LossDate in the format of (yyyymmdd). I need to verify that if the month ends in ... because 200806 ends in 30 days. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

371 views

1 answer

db2 equivalent of tsql temp table

How would I do the following TSQL query in DB2? I'm having problems creating a temp table based on the results ... include: ":". SQLSTATE=42601" See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

422 views

1 answer

db2 - SQL Statement with multiple SETs and WHEREs

I am wondering if this is a valid query: UPDATE table SET ID = 111111259 WHERE ID = 2555 AND SET ID = ... ID = 111111264 WHERE ID = 2017 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

524 views

1 answer

db2 - An unexpected token "CREATE TRIGGER

CREATE TRIGGER TRG_EFMREFNO BEFORE INSERT ON FEEDBACK_CASE_TB FOR EACH ROW BEGIN SELECT SEQ_EFMREFNO.NEXTVAL INTO:NEW. ... for that errors See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags