What are the steps for JRS to display DNG custom attributes with more than 255 characters
In https://jazz.net/forum/questions/244010/jrs-truncates-attribute-values-to-255-characters, the following steps are mentioned:
Manually increase the size of the VAL column in the following table from 255 to a larger value (say 1024).
CREATE TABLE RQRMENT_STRING_EXT (
REQUIREMENT_ID INTEGER DEFAULT -1 NOT NULL,
REQUIREMENT_ATTRDEF_ID INTEGER DEFAULT -1 NOT NULL,
ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL,
VAL VARCHAR(255)
REQUIREMENT_ID INTEGER DEFAULT -1 NOT NULL,
REQUIREMENT_ATTRDEF_ID INTEGER DEFAULT -1 NOT NULL,
ISSOFTDELETED SMALLINT DEFAULT 0 NOT NULL,
VAL VARCHAR(255)
) IN VNF_32K INDEX IN VNF_IDX;
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
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.