{"id":52785,"date":"2021-10-27T09:14:23","date_gmt":"2021-10-27T07:14:23","guid":{"rendered":"https:\/\/www.arcadsoftware.com\/?p=52785"},"modified":"2021-11-17T10:54:33","modified_gmt":"2021-11-17T08:54:33","slug":"expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think","status":"publish","type":"post","link":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/","title":{"rendered":"Expanding Fields Is A Bigger Pain In The Neck Than You Think"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-bottom:45px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-justify-content-center fusion-flex-content-wrap\" style=\"max-width:1248px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_2_3 2_3 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:66.666666666667%;--awb-margin-top-large:0px;--awb-spacing-right-large:2.88%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:2.88%;--awb-width-medium:66.666666666667%;--awb-spacing-right-medium:2.88%;--awb-spacing-left-medium:2.88%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-text fusion-text-1\"><p>Since the coronavirus pandemic hit, many companies are doing much more business than they ever have done in their history, so this is driving field size expansion. But even generally speaking what was fine for a field size for revenues at a lot of IBM i shops three or four decades ago may not be big enough for the amount of business that the company is doing today. Or maybe they want to move to three-digit decimals for finer-grained currency exchange calculations. Or in other cases, companies want to expand the keys on their files \u2013 such as the number of customer accounts or the numbering scheme on invoices. That customer count code is a particularly tricky one, since it probably appears in 90 percent of your screens and display files and is used throughout your database files.<\/p>\n<\/div><div style=\"text-align:center;\"><a class=\"fusion-button button-flat fusion-button-default-size button-default fusion-button-default button-1 fusion-button-default-span fusion-button-default-type\" target=\"_blank\" rel=\"noopener noreferrer\" href=\"https:\/\/www.itjungle.com\/2021\/10\/20\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/\"><span class=\"fusion-button-text awb-button__text awb-button__text--default\">Read this Article<\/span><\/a><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Remember the Y2K problem, when companies had two-digit dates for years in their applications and the millennial turn was coming and they suddenly needed a four-digit date so all the math would work out right comparing the present, future, and past? <\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-52785","post","type-post","status-publish","format-standard","hentry","category-arcad-press-articles"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Expanding Fields Is A Bigger Pain In The Neck Than You Think | Press<\/title>\n<meta name=\"description\" content=\"Because field expansion is such a big problem, and can take anywhere from nine months to more than a year for many IBM i shops to handle, ARCAD has created a service based on its own tooling that automates the mapping of field distribution.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Expanding Fields Is A Bigger Pain In The Neck Than You Think | Press\" \/>\n<meta property=\"og:description\" content=\"Because field expansion is such a big problem, and can take anywhere from nine months to more than a year for many IBM i shops to handle, ARCAD has created a service based on its own tooling that automates the mapping of field distribution.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/\" \/>\n<meta property=\"og:site_name\" content=\"ARCAD\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pages\/Arcad-Software\/116086138469235\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-27T07:14:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-17T08:54:33+00:00\" \/>\n<meta name=\"author\" content=\"Myriam Goutte\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Myriam Goutte\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/\"},\"author\":{\"name\":\"Myriam Goutte\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#\\\/schema\\\/person\\\/56072f2a9491143460e3cadf23b9d730\"},\"headline\":\"Expanding Fields Is A Bigger Pain In The Neck Than You Think\",\"datePublished\":\"2021-10-27T07:14:23+00:00\",\"dateModified\":\"2021-11-17T08:54:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/\"},\"wordCount\":474,\"publisher\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#organization\"},\"articleSection\":[\"Press Articles\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/\",\"name\":\"Expanding Fields Is A Bigger Pain In The Neck Than You Think | Press\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#website\"},\"datePublished\":\"2021-10-27T07:14:23+00:00\",\"dateModified\":\"2021-11-17T08:54:33+00:00\",\"description\":\"Because field expansion is such a big problem, and can take anywhere from nine months to more than a year for many IBM i shops to handle, ARCAD has created a service based on its own tooling that automates the mapping of field distribution.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/news-events\\\/arcad-press-articles\\\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"ARCAD\",\"item\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expanding Fields Is A Bigger Pain In The Neck Than You Think\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#website\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/\",\"name\":\"ARCAD\",\"description\":\"Experts DevOps &amp; Modernisation sur IBM i (alias AS\\\/400 ou AS400)\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#organization\",\"name\":\"ARCAD Software\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/arcad-group-logo-text-144.png\",\"contentUrl\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/arcad-group-logo-text-144.png\",\"width\":144,\"height\":200,\"caption\":\"ARCAD Software\"},\"image\":{\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/pages\\\/Arcad-Software\\\/116086138469235\",\"https:\\\/\\\/x.com\\\/arcad_software\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/arcad-software\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/ARCADSoftwareInc\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/#\\\/schema\\\/person\\\/56072f2a9491143460e3cadf23b9d730\",\"name\":\"Myriam Goutte\",\"url\":\"https:\\\/\\\/www.arcadsoftware.com\\\/arcad\\\/author\\\/myriam-goutte\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Expanding Fields Is A Bigger Pain In The Neck Than You Think | Press","description":"Because field expansion is such a big problem, and can take anywhere from nine months to more than a year for many IBM i shops to handle, ARCAD has created a service based on its own tooling that automates the mapping of field distribution.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/","og_locale":"en_US","og_type":"article","og_title":"Expanding Fields Is A Bigger Pain In The Neck Than You Think | Press","og_description":"Because field expansion is such a big problem, and can take anywhere from nine months to more than a year for many IBM i shops to handle, ARCAD has created a service based on its own tooling that automates the mapping of field distribution.","og_url":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/","og_site_name":"ARCAD","article_publisher":"https:\/\/www.facebook.com\/pages\/Arcad-Software\/116086138469235","article_published_time":"2021-10-27T07:14:23+00:00","article_modified_time":"2021-11-17T08:54:33+00:00","author":"Myriam Goutte","twitter_misc":{"Written by":"Myriam Goutte","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/#article","isPartOf":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/"},"author":{"name":"Myriam Goutte","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#\/schema\/person\/56072f2a9491143460e3cadf23b9d730"},"headline":"Expanding Fields Is A Bigger Pain In The Neck Than You Think","datePublished":"2021-10-27T07:14:23+00:00","dateModified":"2021-11-17T08:54:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/"},"wordCount":474,"publisher":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/#organization"},"articleSection":["Press Articles"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/","url":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/","name":"Expanding Fields Is A Bigger Pain In The Neck Than You Think | Press","isPartOf":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/#website"},"datePublished":"2021-10-27T07:14:23+00:00","dateModified":"2021-11-17T08:54:33+00:00","description":"Because field expansion is such a big problem, and can take anywhere from nine months to more than a year for many IBM i shops to handle, ARCAD has created a service based on its own tooling that automates the mapping of field distribution.","breadcrumb":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.arcadsoftware.com\/arcad\/news-events\/arcad-press-articles\/expanding-fields-is-a-bigger-pain-in-the-neck-than-you-think\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"ARCAD","item":"https:\/\/www.arcadsoftware.com\/arcad\/"},{"@type":"ListItem","position":2,"name":"Expanding Fields Is A Bigger Pain In The Neck Than You Think"}]},{"@type":"WebSite","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#website","url":"https:\/\/www.arcadsoftware.com\/arcad\/","name":"ARCAD","description":"Experts DevOps &amp; Modernisation sur IBM i (alias AS\/400 ou AS400)","publisher":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.arcadsoftware.com\/arcad\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#organization","name":"ARCAD Software","url":"https:\/\/www.arcadsoftware.com\/arcad\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#\/schema\/logo\/image\/","url":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2017\/09\/arcad-group-logo-text-144.png","contentUrl":"https:\/\/www.arcadsoftware.com\/arcad\/wp-content\/uploads\/2017\/09\/arcad-group-logo-text-144.png","width":144,"height":200,"caption":"ARCAD Software"},"image":{"@id":"https:\/\/www.arcadsoftware.com\/arcad\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pages\/Arcad-Software\/116086138469235","https:\/\/x.com\/arcad_software","https:\/\/www.linkedin.com\/company\/arcad-software","https:\/\/www.youtube.com\/user\/ARCADSoftwareInc"]},{"@type":"Person","@id":"https:\/\/www.arcadsoftware.com\/arcad\/#\/schema\/person\/56072f2a9491143460e3cadf23b9d730","name":"Myriam Goutte","url":"https:\/\/www.arcadsoftware.com\/arcad\/author\/myriam-goutte\/"}]}},"_links":{"self":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/posts\/52785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/comments?post=52785"}],"version-history":[{"count":3,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/posts\/52785\/revisions"}],"predecessor-version":[{"id":53307,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/posts\/52785\/revisions\/53307"}],"wp:attachment":[{"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/media?parent=52785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/categories?post=52785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.arcadsoftware.com\/arcad\/wp-json\/wp\/v2\/tags?post=52785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}