Hi all,

I have this code:

TABLE FILE TESTFOC
PRINT LAST_NAME
      FIRST_NAME
      IND1
      IND2
      LAST_UPDATE_BY
      LAST_UPDATE
BY EID
ON TABLE HOLD AS TSTDATA FORMAT ALPHA
END
-RUN

SQL SQLORA SET ORACHAR FIX
MODIFY FILE TESTORA
FIXFORM FROM TSTDATA
DATA ON TSTDATA
END
-RUN

Basically, what I'm trying to do is move data from a focus db to an oracle table. All the fields except the EID has MISSING=ON on the master file for both TESTFOC.mas and TESTORA.mas. The problem is, if a field is null, it takes the next field over and puts it on that field. So, say, IND1 is null, it populates IND2 on IND1, then IND2 gets populated with LAST_UPDATE_BY which then throws an oracle error message because IND2 is A1V while LAST_UPDATE_BY is A8V. What's going on?

I'm running this on 7.6.4.

This message has been edited. Last edited by: Kerry,

Just a thought,

Try removing the FORMAT ALPHA leaviong just

ON TABLE HOLD AS TSTDATA