Hello All,<br><br>I've problems while creating system interfaces using subfiles.<br>Subfile definition looks something like this:<br> DEFINE REC-ID CHAR*4 = "0010"<br><br> DEFINE CHARGES CHAR*14 = ""
<br> <br> DEFINE C-LLC CHAR*14 = **something<br><br> DEFINE C-LCC CHAR*14 = **something<br><br> DEFINE C-PSX CHAR*2 = **something <br><br> DEFINE C-PCD CHAR*3 = **something <br><br> DEFINE C-UNT CHAR*8 = **something
<br><br><br> DEFINE RECORD-DAS CHAR*183 = DEK OF NS-RECORD + & <br> BNI OF PD-RECORD + &<br> MULT$S_OF_PTS OF NS-RECORD + &
<br> CHARGES + &<br> C-LLC + &<br> C-LCC + &
<br> FRA OF NS-RECORD + &<br> C-PSX + &<br> C-PCD + &
<br> ESG OF NS-RECORD + &<br> C-UNT + &<br> WCP OF NS-RECORD + &
<br> WC2 OF NS-RECORD + &<br> PST OF NS-RECORD + &<br> MAS OF CB-RECORD + &
<br> CUM OF CB-RECORD <br> <br> DEFINE NLSVINT CHAR*1= "N" IF NLSR$S_OF_PTS OF NS-RECORD = "N" ELSE "Y"<br>
<br><br> SUBFILE $PIC_DATA/OPNLSVINT1 KEEP &<br> INCLUDE REC-ID, &<br> PRN OF NS-RECORD, &
<br> CAT OF NS-RECORD, &<br> MER OF NS-RECORD, &<br> RECORD-DAS, &
<br> NLSVINT &<br> INDEX PRN UNIQUE &<br> SEGMENT PRN<br><br clear="all">When I create this subfile for the first time, sho item command displays:
<br>REC-ID CHAR X(4)<br>*
PRN CHAR X(12)<br>
CAT CHAR X(12)<br>
MER CHAR X(12)<br>
RECORD-DAS CHAR X(183)<br>
NLSVINT CHAR X(1)<br><br><br>In the first run, to compare data of previous day, we create one more subfile:<br> ACCESS *$PIC_DATA/OPNLSVINT1
<br><br> SELECT IF REC-ID <> REC-ID <br><br> SUBFILE $PIC_DATA/OPNLSVINT2 KEEP APPEND &<br> INCLUDE OPNLSVINT1 &
<br> INDEX PRN UNIQUE &<br> SEGMENT PRN<br><br><br><br>At the end of job execution it renames OPNLSVINT1 to OPNLSVINT2 ( .dat,.sfd,.idx ) and creates OPNLSVINT1 next day with comparison with OPNLSVINT2 of previous day.
<br>And when I run the job again...., and the do a sho ite command, it displays:<br><br>OPNLSVINT2 TYPE SCALE SCALE DEC PICTURE<br>
REC-ID CHAR X(4)<br>*
PRN CHAR X(12)<br>
CAT CHAR X(12)<br>
MER CHAR X(12)<br>
NLSVINT CHAR X(1)<br>
RECORD-DAS CHAR X(183)<br><br>As you the single character flag precedes the 183 character item now.. which automatically changes the Layout(data in output).<br>Could anyone provide any comment/hints to fix this?
<br><br>Sorry if I'm spamming your mail box. :-)<br><br>Thanks in advance.<br><br>Regards,<br>Vamsi<br><br>-- <br>"Nothing is impossible as impossible itself says i m possible"