Some of the flat files have over 100 columns. You have the record description for all these in separate files in some obscure format that forces you to type in the record length for every single column manually. Adding delimiters to the flat files would simply rule out this problem as the delimiter tells my importing application (Business Objects Data Integrator) exactly how big the column is.-Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand"Ī delimiter implies veriable length data, so how will using a delimiter tell your importing application how big the column is? (not to mention the data type and column name) CODO ERGO SUMĪ return question: you have 200 flat files which are all going in to different tables with different structure in a sql server database. The problem is with maintenance.we are moving a few hundred vision files over to sql server every day for reporting purposes and when some of the files have over 100 columns it gets pretty nasty to keep contol over how many characters each column is (I have to do this manually for each file).
I don't have anything working.I'm creating a new solution. I don't see any benefit of a delimited file over a fixed width file.If you have something working, why mess with it? CODO ERGO SUM We did evaluated AcuCobol once when moving from DOS to Windows, but decided to stick to MicroFocus
I try to see if i can dig out any AcuCobol manual when i am back in office tomorrow. Yeah.-Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" I'm afraid I am Working for a financial company now, and our main business application was created in the early 80's using cobol. But I as using MicroFocus Cobol not AcuCobol. Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand"Ĭobol ? Are you serious ? I was using cobol before switching over to SQL. The command we are using right now is this:vutil -unload -t sourcefile destinationfileI'll be surprised if anyone even has a clue of what I'm talking about here (I sure don't!) and if anyone can even would be totally far out. We are using "vutil" to dump the data right now, but it's creating a fixed-width file and we would *really* like it to be a delimited file of some sort.
We have a system based on AcuCobol and vision-files and we need to dump the entire datafiles in to txt-based files to be imported in to a sql server. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with.