It's all about the answers!

Ask a question

What are the steps for JRS to display DNG custom attributes with more than 255 characters

Tiffany Pei (139122) | asked Sep 18 '17, 1:48 a.m.

Manually increase the size of the VAL column in the following table from 255 to a larger value (say 1024).

                VAL VARCHAR(255) 

I am using DB2, what are the exact steps that I need to do for the reports to show more than 255 characters for custom attributes?

Accepted answer

permanent link
Howard Hsiao (5.5k17) | answered Sep 18 '17, 1:50 a.m.
edited Sep 18 '17, 1:50 a.m.

1) Connect to DW database
db2 connect to dw

2) Increase the length of VAL column to 1024
db2 alter table RICALM.RQRMENT_STRING_EXT alter column VAL set data type VARCHAR(1024)

3) Check that the length of VAL column has been increased to 1024
db2 describe table RICALM.RQRMENT_STRING_EXT

4) Run Requirement Management job in DCC with Full Load
4.1) login to /dcc 
4.2) Change Rational DOORS Next Generation to "Full Load" 
4.3) Run the Requirement Management job

Note: Since all truncated data needs to be repopulated, a Full load for Requirement Management PDS Data Collection job must be run.
Note: The Delta Load configuration for Rational DOORS Next Generation will be changed back to "Delta Load since previous run" automatically after the schedule job completes.

Tiffany Pei selected this answer as the correct answer

Your answer

Register or to post your answer.