Strange Problem

[GCC Consulting]

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of Rick Mitchell
> Sent: Thursday, March 31, 2005 12:26 PM
> To: filepro-list at lists.celestial.com
> Subject: Strange Problem
> 
> I have two fields:
> 
> 29  Date of transaction   8  yymd
> 30  Serial # of transact  9 
> 
> I have an index built on Field 29
> 
> File is called mbien04p
> 
> I am importing new data.
> 
> I get field 29 and 30 from the raw data.
> 
> I do a lookup to the file
> 
> 
> lookup test=mbien04p k=29 i=h -nx
> 
> I will have data in field 29, i.e. 20040626 and when I do a 
> lookup to it it fails.
> 
> Do I need to use these as integers instead of date edits?
> 
A few things come to mind.

1. Have you checked the index H's length to insure that it is 8 characters long.

2. Have you manually tested the date in IUA?  Are you taken to that or those
records?

3. Have you run your process with the debugger and checked the field value that
is failing?

4. What platform are you having this problem on?

Richard Kreiss
GCC Consulting