OnDemand User Group

Support Forums => Windows Client => Topic started by: Helle V. Justesen on January 03, 2022, 12:45:23 PM

Title: change of type of a index field
Post by: Helle V. Justesen 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

Title: Re: change of type of a index field
Post by: Justin Derrick 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.