Maximo Open Forum

I am using an insert statement to select records from the TICKET table from one db2 instance , and to insert to a TICKET table in another instance.

Therefore I have a statement like 

insert into TICKET (ticketid, description,status) from ticket.instance1 select ticketid,description,status from ticket.instance2.

I will have an error that character is too long for the ticketid field. I then increased the length from 10 to 15  on the target, to match the character length of the source. However, I am still getting the error. The length of the ticketid i am inserting is within the required length of the field.

Any help please

Hi Kane, 

Your syntax should be written like this if i am not wrong. The First From is not needed I believe.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3,
FROM table1
WHERE condition;

Ticket table has many views. Check the changes are correctly cascaded to other Views like SR and Incident.

I am using an insert statement to select records from the TICKET table from one db2 instance , and to insert to a TICKET table in another instance.

Therefore I have a statement like 

insert into TICKET (ticketid, description,status) from ticket.instance1 select ticketid,description,status from ticket.instance2.

I will have an error that character is too long for the ticketid field. I then increased the length from 10 to 15  on the target, to match the character length of the source. However, I am still getting the error. The length of the ticketid i am inserting is within the required length of the field.

Any help please

Hello Subhransu, Thanks so much for your reply. Greatly appreciated. The changes are not correctly cascaded to other tables. one of the fields length to change is on the work order table. I am trying to increase the length of the workorder wonum field  to 15. Saving the changes gives the error on the screenshot below. I could change other attributes, but not in workorder table.

Hi Kane, 

Your syntax should be written like this if i am not wrong. The First From is not needed I believe.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3,
FROM table1
WHERE condition;

Ticket table has many views. Check the changes are correctly cascaded to other Views like SR and Incident.

I am using an insert statement to select records from the TICKET table from one db2 instance , and to insert to a TICKET table in another instance.

Therefore I have a statement like 

insert into TICKET (ticketid, description,status) from ticket.instance1 select ticketid,description,status from ticket.instance2.

I will have an error that character is too long for the ticketid field. I then increased the length from 10 to 15  on the target, to match the character length of the source. However, I am still getting the error. The length of the ticketid i am inserting is within the required length of the field.

Any help please