I’m hoping this is super simple…we’re new to WebMethods (coming from Sterling Integrator) so I’m trying to migrate some processes over. Some of the jobs we have require flat files to be built from database extractions. I have the jdbc connections working and I’m able to create flat files (created a flat file dictionary, schema, and then document type). For some of the files I need to create a static header record that contains the field names and then all the data records from the jdbc extraction after.
So my question is how do I create the header record with the static field names as the first record? I’m not sure how or where to define this record. I thought about trying to hard code the values in the first iteration of the looping record but I’m not sure if that’s the best way or if I should somehow define the static record in the dictionary/schema somehow.
Hopefully I’m overthinking this and it’s easier than I’m making it. Any guidance and help would be GREATLY appreciated. Thanks in advance.