RE: [C400-L] Reading/writing file with NULL fields

["Jevgeni Astanovski" <J.Astanovski@xxxxxxxxxxxx>]

Yes. The first level problem is solved.

But still I have a feeling, that something is wrong here.
Spent a whole day in attempts to write a program, that adds records from one 
null-capable file to another (also null-capable) file.
Both files have identical structure of 3 fields:
field1 alphanumeric, no nulls allowed;
field2 alphanumeric, null capable;
field3 packed decimal.
Program works so:
reads each record from first file, looks if record with identical fields 1 and 
2 exists in second.
If not - adds;
If yes - updates the value of field 3 in second file.

It should be absolutely trivial!
Cannot make it running...
I tried simply to add a record to a null-capable file. As soon, as I open it 
with nullcap=y, inserts fail. Eve if inserted record contain no NULL fields. 
If I remove nullcap=y from open, everything works...

Ay advise will appreciated - may be there is some manual, that describes these 
pecularities?

Regards,
Jevgeni


> -----Original Message-----
> From: Elvis Budimlic [mailto:ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx]
> Sent: 18. detsember 2003. A. 0:40
> To: 'C programming iSeries / AS400'
> Subject: RE: [C400-L] Reading file with NULL fields
> 
> 
> Jevgeni, 
> 
> You need "rr nullcap=Y" when you open the file so you can 
> handle the null
> capable fields.
> If that doesn't suffice you may want to learn more about file 
> handle's null
> input map (fp->in_null_map).
> 
> Elvis
> 
> -----Original Message-----
> From: c400-l-bounces@xxxxxxxxxxxx 
> [mailto:c400-l-bounces@xxxxxxxxxxxx] On
> Behalf Of Jevgeni Astanovski
> Sent: Wednesday, December 17, 2003 4:13 PM
> To: C programming iSeries / AS400
> Subject: [C400-L] Reading file with NULL fields
> 
> There should be some trick about reading files with 
> NULL-capable fields!
> But I deal with it for the first time....
>  
> Have a file Y6CPF:
>  
> A          R Y6CPFR                                              
> A            CPNC           6A         TEXT('Account number')    
> A            DLP            3A         TEXT('Deal type') ALWNULL 
>  
> Try to read it :
>  
> fp = _Ropen("*LIBL/Y6CPF", "rr") ;
>  
> fb = _Rreadf(fp, &Collateral, sizeof(y6cpf), __NO_LOCK) ;
> while (fb->num_bytes == sizeof(y6cpf))                   
> {
>   ...
>   fb = _Rreadn(fp, &Collateral, sizeof(y6cpf), __NO_LOCK) ;
> }
>  
> Nothing strange, I always do it like this.
> Program gets out of the loop on first record, having field DLP=NULL.
> Shit! And my goal was to find just these records...
> What's wrong? It SHOULD be as simple as usual!
> Any help will be really appreciated.
>  
> Jevgeni Astanovski.
>  
>  
> 
> 
> _______________________________________________
> 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.
> 
>