about SQLCODE -104 (error) during select in DB2

Question

I have been trying to adapt a working "INSERT" into a SELECT statement and keep finding a error -104

a)Can someone please help me understand the reason why the "." on "where" clause (below) works when I run with an "insert" but gives me an error when using on a "select" clause? b)How should the "INSERT" criteria be written correctly when using a SELECT?

Many thanks in advance for any assistance on this question

Insert:

 INSERT INTO  SISPD2.SIS_DAILY_RECALC                            
         (CIN_NUM,PGM_DIV_FG,NON_CA_FG,PGM_EXCPT_FG,WTW_FG)   
 (SELECT C.CIN_NUM, C.PGM_DIV_FG, C.NON_CA_FG, C.PGM_EXCPT_FG,
         C.WTW_FG                                             
    FROM  SISPD2.SIS_INDV C                                  
   WHERE C.CIN_NUM NOT IN (SELECT CIN_NUM FROM  SISPD2.SIS_DAILY_RECALC)

------------------------------------------------------------------------

Select :

    SELECT C.CIN_NUM  ||','||                                          
         C.PGM_DIV_FG ||','||                                        
         C.NON_CA_FG  ||','||                                        
         C.PGM_EXCPT_FG ||','||                                     
         C.WTW_FG   ||','||                                        
  WHERE (C.CIN_NUM NOT IN (SELECT A.CIN_NUM                        
                            FROM  SISPD2.SIS_DAILY_RECALC A));

DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL ".". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: , FROM INTO
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE

Be careful when tagging. You should only tag the DBMS relevant to your problem. — Sean Lange, Jun 21 '16 at 18:35
Not familiar with db2, and having a hard time figuring out exactly what you are asking, but I just came across the (rarely supported) `||` concatenation operator the other day; it looks to me like your second query is trying to concatenate the WHERE onto the single result field, which could confuse the query parser. — Uueerdo, Jun 21 '16 at 18:36
You're missing the `FROM` clause -- you must `SELECT` `FROM` something. — mustaccio, Jun 21 '16 at 18:51

score 0 · Answer 1 · answered Jun 21 '16 at 18:45

0

You shouldn't be concatenating a statement together unless you're building a dynamic statement you intend to PREPARE and EXECUTE

 SELECT C.CIN_NUM  
         , C.PGM_DIV_FG
         , C.NON_CA_FG
         , C.PGM_EXCPT_FG
         , C.WTW_FG
  WHERE (C.CIN_NUM NOT IN (SELECT A.CIN_NUM
                            FROM  SISPD2.SIS_DAILY_RECALC A));

answered Jun 21 '16 at 18:45

Charles

21,637
1
20
44

thank you so much Charles , yes, I was trying to build a dynamic statement – Wanda Larangeira Jun 21 '16 at 18:58
I appreciated everyone's valuable comments - thanks to all my problem was solved :) – Wanda Larangeira Jun 21 '16 at 19:00

about SQLCODE -104 (error) during select in DB2

------------------------------------------------------------------------

1 Answers1