What about using one file with multiple file members for each day? You
could override to the appropriate member as needed in your RPG program.
From the .NET side, it would be a little more complicated, but I think you
could use IBM's .NET data provider to create the member (via QCMDEXC),
then create an alias to the new member and finally insert your data into
it. You could optionally delete the alias afterwards. Can't say I've done
this (recently at least), so it may not be that simple. But it might be
another option.
Blake
date: Thu, 30 Jun 2011 16:04:20 -0500
from: Mike Wills <mike@xxxxxxxxxxxx>
subject: DDL, RPG, and Daily Transactions from .NET program
We have a daily process that will be pulling data from our internet
server and putting it on the i into a work file. Because I am not
creative and am copying what we have done in the past, I create a file
called TRANYYMMDD (with YYMMDD in the appropriate date) one for each
day. I am doing this via CREATE TABLE in the .NET program.
On the i side, I do a DSPFD to get a list of the files, then use RPG
to read the created file. I want to do a OVRDBF on each file to
process it. (Boy this sounds more complicated than it should be).
Anyway, I am getting a "RNQ1011 Undefined record type is found in file
TRANYYMMDD" How do I get around this?
OVRDBF Statement:
OVRDBF FILE(TRANYYMMDD) TOFILE(&FILENAME) MBR(*FIRST) LVLCHK(*NO)
OVRSCOPE(*JOB)
Otherwise, how would you do this? I think the idea of the original
setup was to separate the daily transactions easily.
--
Mike Wills
http://mikewills.me
midrange.com
