ERROR related to one of the Input files

[daxinz]

First I thank so much Ray and Julio for replying my previous question. I am doing the match to see what happen.

I get an error related to one of the input file. Another file is not mentioned in error log. Experts please help again.

1) in sas program, I created the text file from a sas dataset as following:

filename outds1 "/path/matchssa/KP123109" lrecl=126;
format aRow $126.; /* (obs=100) */
substr(aRow, 1, 1)=srckp;
..... /* there are missing values */
substr(aRow, 20,35)=lnameq; /* last name */
.....
substr(aRow, 126,1)="0"; /* All row ended at the same place*/
FILE outds1;
PUT aRow;
Program is submitted from window XP to UNIX to be execute.

2) in QS match setting, all "Missing Value"are 'S', all f"Feld type" are 'S', all "field data type" are 'A'. I also have two additional varibles read on last name and first name from byte 1 to byte 4. The "Start/End/length" are corrctly set.

3) [b]ERROR[/b]:
Error exec: /emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vio.c:12; vio.c:1516) ERROR: Incomplete record read from file /emc-nas/user/x966892/QSProjects/NEWGS/Data/KP123109
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vio.c:13; vio.c:1518) ERROR: len=126, BufCnt=100, BufSize=102400, HaveCnt=100, readCnt=0, readRtn=0
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vutils.c:13; vutils.c:1412) ERROR: vexit status=1
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.Step001.log:ERROR: freqld FAILED (1)

Op Failed Step001 (1)
EXITVAL=1 /* in step 1, block/match vars have missings values */

4) [b]KP123109.DIC:[/b]
;;QualityStage v7.0
RECORD 125
FILE ${DATAA}
CODEPAGE DEFAULT
FILEFORMAT FIXEDTERM
VAR LSONDEX 105 8 S A
VAR FSONDEX 113 8 S A
VAR SRCKP 1 1 S A
VAR SRCINDE 2 9 S A
VAR SSNKP 11 9 S A
VAR LNAME 20 35 S A
VAR FNAME 55 25 S A
VAR MNAME 80 1 S A
VAR DOBYR 81 4 S A
VAR DOBMN 85 2 S A
VAR DOBDY 87 2 S A
VAR LNYSIIS 89 8 S A
VAR FNYSIIS 97 8 S A
VAR ZIPKP 121 5 S A
VAR LNAME4C 20 4 S A
VAR FNAME4C 55 4 S A

Any instruction is welcome. Do I need to do more to handle missing value and line endding? how?
thanks in advance.

[ray.wurlod]

Can you try changing the file definition so that the field definitions are in correct positional order?

(Clutching at straws a bit, I admit, but it's been a long time since I used QS version 7.)

[daxinz]

In the userguid on my computer, I read this:
In general, input files must be fixed-length files with an end-of-record
terminating character, and they must contain alphanumeric data.

1) How to have a "end-of-record terminating character"? I put "\n", it gives and extra '\' at the end.

2) only [a-zA-Z 0-9], Single quotion and '-' are not allowed?

Thanks

[daxinz]

if prm = prxmatch("/([^a-zA-Z \-0-9\']+)/", aRow);
no prm >0.

Please keep helping.

I still do not know if I need to put file ending or line ending char at related place.

Thanks so much.

[daxinz]

I figured it out.

I did a lot of changes, and I do not know what exactly makes the difference.

I reformatted both file A and file B, adjusted the datafile definition in QS designer, and adjusted the UNIX folder's user access privilege. In my system, the QS server and my work folder are on different UNIX computers, and I edit and submit the programs from Windows XP.

Thanks