View previous topic :: View next topic
|
Author |
Message |
ramesh_ibm
New User
Joined: 17 Nov 2007 Posts: 16 Location: banglore
|
|
|
|
Code: |
UPDATE
DCNTRL01.TPRM_CONTROL_PARM
SET DATA_FILLER_1 = (BAS SB PB XB RB SB0 SB1 SB2 SB3 SB4
SB5 SB6 SB7 SB8 SB9 SBS SBF PBS PBF RBS
RBF XBS XBF J04 J05 J06 J07 J08 F05 F06
F07 F08 M06 M07 M08 A07 A08 Y08 U09 U10
L10 L11 L12 G11 G12 S12 U08 D03 D04 D05
D06 BSC D07 D08 L01 G01 S01 O01 U12 )
WHERE APPL_PGM_ID = 'PRE9SEAS'
|
This query is returning error like string is too long
some body please let me know the solution
Thanks
Ramesh |
|
Back to top |
|
|
abhishekmdwivedi
New User
Joined: 22 Aug 2006 Posts: 95 Location: india
|
|
|
|
Hi ramesh,
Can you please give us some more info. about the field DATA_FILLER_1. (Data Type , length etc.) |
|
Back to top |
|
|
ramesh_ibm
New User
Joined: 17 Nov 2007 Posts: 16 Location: banglore
|
|
|
|
abhishek
here r the details u have asked for
DATA_FILLER_4 CHAR(250)
I ahve tried wit concatenate symbol but that one is also not successful
Code: |
UPDATE
DCNTRL01.TPRM_CONTROL_PARM
SET DATA_FILLER_1 = 'BAS SB PB XB RB SB0 SB1 SB2 SB3 SB4 '||'
SB5 SB6 SB7 SB8 SB9 SBS SBF PBS PBF RBS '||'
RBF XBS XBF J04 J05 J06 J07 J08 F05 F06 '||'
F07 F08 M06 M07 M08 A07 A08 Y08 U09 U10 '||'
L10 L11 L12 G11 G12 S12 U08 D03 D04 D05 '||'
D06 BSC D07 D08 L01 G01 S01 O01 U12 '
WHERE APPL_PGM_ID = 'PRE9SEAS'
|
|
|
Back to top |
|
|
arivazhagan_k
New User
Joined: 05 Dec 2007 Posts: 57 Location: chennai
|
|
|
|
Your update may overflow the field DATA_FILLER_1 actual length.Can we get your table info ? |
|
Back to top |
|
|
abhishekmdwivedi
New User
Joined: 22 Aug 2006 Posts: 95 Location: india
|
|
|
|
Ramesh,
Quote: |
UPDATE
DCNTRL01.TPRM_CONTROL_PARM
SET DATA_FILLER_1 = 'BAS SB PB XB RB SB0 SB1 SB2 SB3 SB4 '||'
SB5 SB6 SB7 SB8 SB9 SBS SBF PBS PBF RBS '||'
RBF XBS XBF J04 J05 J06 J07 J08 F05 F06 '||'
F07 F08 M06 M07 M08 A07 A08 Y08 U09 U10 '||'
L10 L11 L12 G11 G12 S12 U08 D03 D04 D05 '||'
D06 BSC D07 D08 L01 G01 S01 O01 U12 '
WHERE APPL_PGM_ID = 'PRE9SEAS' |
You can't use || symbol in the set statement. Below is the approach to do this :
DCNTRL01.TPRM_CONTROL_PARM
SET DATA_FILLER_1 = 'BAS SB PB XB RB SB0 SB1 SB2 SB3 SB4' CONCAT
'SB5 SB6 SB7 SB8 SB9 SBS SBF PBS PBF RBS' CONCAT
'RBF XBS XBF J04 J05 J06 J07 J08 F05 F06' CONCAT
'F07 F08 M06 M07 M08 A07 A08 Y08 U09 U10' CONCAT
'L10 L11 L12 G11 G12 S12 U08 D03 D04 D05' CONCAT
'D06 BSC D07 D08 L01 G01 S01 O01 U12 '
WHERE APPL_PGM_ID = 'PRE9SEAS' |
|
Back to top |
|
|
ramesh_ibm
New User
Joined: 17 Nov 2007 Posts: 16 Location: banglore
|
|
|
|
it worked......thanks a lot abhishek |
|
Back to top |
|
|
|