Author Topic: change of type of a index field  (Read 1135 times)

Helle V. Justesen

  • Jr. Member
  • **
  • Posts: 26
    • View Profile
change of type of a index field
« on: January 03, 2022, 12:45:23 PM »
hi

I have the ondemand server on Z/OS and use the windows client to access data. We run version 10.5.0.

In one of the application groups one of the index fields is defined as integer - but now that field is having a value that is to big for an integer - it is over 220000000000 - so the arsload ends with an ARS1125E error.

I made a test where I made a new APG where the field is Big int - and then I have added a new field to the folder, so the folder now have 2 columns with almost the same name - and one is used for the documents from the APG with the integer and one is for the APG with the Big integer - but has anyone another suggestion to solve the issue?

I tried to attach a screen shot of the folder - but i couldn't get it to work ...
Br
Helle Justesen
« Last Edit: January 03, 2022, 03:10:57 PM by Helle V. Justesen »

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: change of type of a index field
« Reply #1 on: January 12, 2022, 07:02:19 PM »
Yeah, this isn't an easily solvable issue.  You'd normally copy the app group, change the field type to BigInt, then add the new App Group to the folder definition - but I don't think you can map a 'bigint' AppGroup field to an 'integer' folder field.

This might be a good Enhancement request.  I've also seem this problem when trying to combine AppGroups that are copies, where one of the date fields is a standard 'date' field, and the other is a 'date/time' field.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR