DSXchange

Hi,

I need your expert help for an issue with range lookup. My job is simple, input stream has a date, my reference has Fiscal Year, Start date and End Date. I need to get the fiscal year if the input date falls between start and end date. I've specified the range lookup exactly as mentioned in the IBM document. I'm getting below error while compiling.

Things i've tried- Removed range lookup and compiled..Compiles well hence no issue in any other stage
Tried adding 'Return multiple rows from ref link' ..same compilation error.

Below is the error details..please guide..Thanks in advance


##I IIS-DSEE-TFCN-00006 17:42:04(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=aix1ainf03d; -m=00C1C2F74C00
##I IIS-DSEE-TFCN-00008 17:42:04(002) <main_program> Conductor runnning PID = 15,007,998
##I IIS-DSEE-TOSH-00002 17:42:04(003) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 17:42:04(004) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 17:42:04(005) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 17:42:04(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TFOP-00020 17:42:04(010) <transform> Error occurred during initializeFromArgs().
##E IIS-DSEE-TFAV-00209 17:42:04(011) <transform> Unrecognized argument: -keep
##E IIS-DSEE-TCOS-00029 17:42:04(012) <main_program> Creation of a step finished with status = FAILED. (Untitled1_range.Lookup_3)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S3_Untitled1_range_Lookup_3 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink2;
0007: tablename 0 in;
0008: outputname 0 DSLink6;
0009:
0010: initialize {
0011: // define our control variables
0012: int8 RowRejected0;
0013: int8 NullSetVar0;
0014:
0015: }
0016:
0017: mainloop {
0018:
0019: // no condition for lookup link: in
0020: lookup(in);
0021: do
0022: {
0023: // initialise the rejected row variable
0024: RowRejected0 = 1;
0025:
0026: // evaluate columns (no constraints) for link: DSLink6
0027: DSLink6.START = in.DATE;
0028: DSLink6.END = in.DATE;
0029: DSLink6.YEAR = in.YEAR;
0030: writerecord 0;
0031: RowRejected0 = 0;
0032: next_match(in);
0033: } while (is_match(in));
0034: }
0035:
0036: finish {
0037: }
0038:
*** End of Internal Generated Transformer Code


Image of lookup stage:

http://i62.tinypic.com/ivgydd.png

Show us precisely how you specified the range lookup in the Lookup stage.

Thanks Ray for your response. The image of lookup stage and Range lookup rule is here.

http://i62.tinypic.com/ivgydd.png