Sidebar

How To Set Fixed Width Record Length Setting Programmatically

0 votes
208 views
asked Apr 14, 2022 by chris-m-3214 (320 points)
Is there a way to set the Fixed Width Record Length setting programmatically?  I'd like to have one channel that processeses all my fixed width files based on conditions so I need to set the fixed width programmatically for each particular file spec.

1 Answer

0 votes
We need a little more information but my first thought would be to use a system variable lookup table.

Using the first column to describe the name of what different values you want and then the following columns to define the different lengths.
answered Apr 14, 2022 by michael-h-5027 (14,350 points)
commented Apr 14, 2022 by chris-m-3214 (320 points)
I have fixed-width files of varying lengths so I am trying to find a way to set the fixed width record length value for the source at run time.  I can definitely set up a system variable lookup table.  How would I refer to that in the record length setting for the fixed width source?
...