I have this code, but the file is one position off,
for example school year should start in position one and end in position one
then
student_last_name format a16 size 1
should start in position 2 and end in position 17 size 16
and
student_first_name format a16
should start in position 18 end in 33 size 16
etc... etc...
also last name and fisrt name should be left justify
I change RPAD to lpad but it looks wear, is that right?
Please help my boss is waiting for the file
set verify off
set echo off
----set pagesize 9999
set wrap off
set heading off
set trimspool on
set linesize 9999
column school_year format a1;
column student_last_name format a16 ;
column student_first_name format a16 ;
column student_mi format a1;
column street1 format a50 ;
column street2 format a50 ;
column city format a28 ;
column state format a2;
column zipcode format a9;
column telnumber format a10;
column dateofbirth format a8;
column ssn format a9;
column dep_status format a1;
column natural_parents format a1;
column parent_own_business format a1;
column student_finaid_status format a1;
column federal_verification format a1;
column college_code format a4;
column foreign_addr_ind format a1;
column country format a25;
column foreign_postal_code format a15;
column student_email_address format a50 ;
column alternate_id format a12;
column parent_email format a256;
column filler format a279;
column slash format a1;
column cr/lf format a2;
spool finaid2.lst
select
--RPAD(NVL(RZFIDOC_SCHOOL_YEAR,' '),1),
RPAD(NVL('0',' '),1),
rpad(nvl(RZFIDOC_LAST_NAME,' '),16),
rpad(nvl(RZFIDOC_FIRST_NAME,' '),16),
rpad(nvl(RZFIDOC_MI,' '),1),
rpad(nvl(RZFIDOC_STREET_LINE1,' '),50),
rpad(NVL(RZFIDOC_STREET_LINE2,' '),50),
RPAD(nvl(RZFIDOC_CITY,' '),28),
rpad(nvl(RZFIDOC_STATE_CODE,' '),2),
rpad(nvl(RZFIDOC_ZIP,' '),9),
rpad(nvl(RZFIDOC_TELPHONE,' '),10),
rpad(nvl(to_char(RZFIDOC_BIRTH_DATE,'MMDDYYYY'),' '),8),
rpad(nvl(RZFIDOC_SSN,' '),9),
rpad(nvl(RZFIDOC_DEP_STATUS,' '),1),
rpad(nvl(RZFIDOC_NAT_PAR_MRTL_STATUS,' '),1),
rpad(nvl(RZFIDOC_OWN_BUSINESS,' '),1),
rpad(nvl(RZFIDOC_FINAID_STATUS,' '),1),
rpad(nvl(RZFIDOC_FED_VERIF,' '),2),
rpad(nvl(RZFIDOC_COLLEGE_CODE,' '),4),
rpad(nvl(RZFIDOC_FOREIGN_ADDR_IND,' '),1),
rpad(nvl(RZFIDOC_COUNTRY,' '),25),
rpad(nvl(RZFIDOC_FOR_POSTCODE,' '),15),
rpad(nvl(RZFIDOC_EMAIL,' '),50),
rpad(nvl(RZFIDOC_ID,' '),12),
rpad(nvl(RZFIDOC_PAR_EMAIL,' '),256),
rpad(nvl(RZFIDOC_PAR_EMAIL,' '),279),
'\',
CHR(13)||CHR(10)
from
faismgr_midd.RZFIDOC