RE: Accessing PF with changing structure.

 Jevgeni,

I guess there is an even better solution in your situation: each time the
physical is recreated just build a view over it with the fields in the
correct order. The source for the view is not a function of the filed
sequence in the physical file.

Regards,

L. Raikov
Principal Consultant
Misys Retail Banking Systems 

Level 30
9 Castlereagh street,
Sydney 2000
NSW Australia

T +61 2 92168833
F +61 2 92314380

external e-mail: Lo.Raikov@xxxxxxxxx

 

> -----Original Message-----
> From: Jevgeni Astanovski [mailto:J.Astanovski@xxxxxxxxxxxx]
> Sent: 21 June 2003 01:06
> To: C programming iSeries / AS400
> Subject: RE: [C400-L] Accessing PF with changing structure.
> 
> 
> Thank's.
> I've evaluated different ways.
> 1. DDM. Define a DDMPF and override original file to DDM 
> before compilation. Works but somehow tricky....
> 
> 2. Using API to retrieve file structure and "manually" find 
> right field. Too much programming...
> 
> 3. Embedded SQL seems to be the easiest one. I decided to 
> write a program, that retrieves all fields with index value 
> passed to it. And then I can call it from all other programs, 
> that need to access this file. Exactly as Leonid thought, 
> being compiled with one file structure and transferred to 
> another machine with another file structure, it still works.
> Do not know how do THEY achieve it....
> 
> Jevgeni.
> 
> > -----Original Message-----
> > From: Bob Crothers [mailto:bob@xxxxxxxxxxxxxx]
> > Sent: 17. juuni 2003. A. 16:56
> > To: 'C programming iSeries / AS400'
> > Subject: RE: [C400-L] Accessing PF with changing structure.
> > 
> > 
> > Jevgeni,
> > 
> > Are the files externally defined?  If so, use SQL to get at them.
> > 
> > Select FIELD0, FIELD1, FIELD2, FIELD3 from mypfile
> > 
> > Will always get the data the way you want it.
> > 
> > Bob
> > 
> > > -----Original Message-----
> > > From: c400-l-bounces@xxxxxxxxxxxx [mailto:c400-l-
> > > bounces@xxxxxxxxxxxx] On Behalf Of Jevgeni Astanovski
> > > Sent: Tuesday, June 17, 2003 6:42 AM
> > > To: C programming iSeries / AS400
> > > Subject: [C400-L] Accessing PF with changing structure.
> > > 
> > > Can anyone advise me of how can I solve the following problem?
> > > I have a physical file defined via DDS:
> > > First PF1:
> > > 
> > > A    FIELD0   06A
> > > A    FIELD1   01A
> > > A    FIELD2   02A
> > > A    FIELD3   03A
> > > K    FIELD0
> > > 
> > > I have to read data from the file from C-program.
> > > I declare it via #pragma mapinc.... and nicely read data using
> > > _Rreadk for example.
> > > Absolutely no problem - works all the time.
> > > 
> > > The problem is, that this file is created somewhat dynamically
> > > by another application, and sometimes it is like this, but
> > > sometimes fields are swapped:
> > > 
> > > For example:
> > > A    FIELD0   06A
> > > A    FIELD2   02A
> > > A    FIELD1   01A
> > > A    FIELD3   03A
> > > K    FIELD0
> > > 
> > > As my program needs FIELD1, it never obtains it in the second
> > > case until I recompile it....
> > > 
> > > Is there a way to retrieve FIELD1 always, irrespectably of
> > > where it is in the record.
> > > The record size is always the same and the fields themselves
> > > are always identical.
> > > 
> > > Any advise will be highly appreciated.....
> > > 
> > > Jevgeni Astanovski
> > > IT support department manager
> > > Sampo pank.
> > > Tallinn, Estonia.
> > > 
> > > 
> > > _______________________________________________
> > > This is the C programming iSeries / AS400 (C400-L) mailing list
> > > To post a message email: C400-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/c400-l
> > > or email: C400-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/c400-l.
> > 
> > 
> > _______________________________________________
> > This is the C programming iSeries / AS400 (C400-L) mailing list
> > To post a message email: C400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/c400-l
> > or email: C400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/c400-l.
> > 
> > 
> 
> _______________________________________________
> This is the C programming iSeries / AS400 (C400-L) mailing list
> To post a message email: C400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/c400-l
> or email: C400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/c400-l.
>