Trigger to create flat file for new row in table. Load Flat File. Microsoft SQL Server. Flat File import from Access Visual Basic. Export to flat file. Space Delimiter in a flat file. Oracle Database. Get Ahead by Going Headless. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Who owns this outage? Building intelligent escalation chains for modern SRE. Podcast Who is building clouds for the independent developer?
Featured on Meta. Now live: A fully responsive profile. I want to commit after each updates. If my program ends normally, no problem. Lespagnard -- - Mitch Sent via Deja. Thu, 24 Apr GMT marcel. But your shop probably doen't have IMS since you're coming up with this question in the newsgroup -: And obviously the hint to use a DB2 table as an intermediate was not an option for you why not?
There is no way to synchronise flat files and commit-processing in DB2 if you don't involve some external software external to DB2. Apart from IMS or some specialised software f. BMC's Application Restart Control the only other way is by "manual" interference in between abend and restart.
And with manual I mean: running a job to synchronise afterwards. Code your program so that it displays or writes as a record the sequence-number of the commit-point after each commit-point. Input is the report-file that has been closed as part of the abend-processing.
As far as I know the report-file will be closed properly in most cases by MVS or OS , that is to say with a "normal" end-of-file marker. Ian Bjorhovde Ian Bjorhovde IBM Db2 This was formerly provided only by Netezza and this functionality has made its way to Db2. Paul Vernon 3, 1 1 gold badge 7 7 silver badges 21 21 bronze badges. Doug Dailey Doug Dailey 11 1 1 bronze badge. There are two alternatives for DB2 UDB Universal Database , which may be helpful in specific use cases: DataLinks : it is basically another data type that keeps a reference to your external file.
It also provides several levels of control over external data such as referential integrity, access control, coordinated backup and recovery, and transaction consistency. DB2 Extenders : they extend functionality of the DB2 to operate on specific file formats, e. Is it a joke or have you been living under a rock for the last ten years? DataLinks were removed in version 9. Thanks for the answer, but it is not an up to date answer.
0コメント