| ramesh |
Posted: Jan 04, 2008 05:03:02 AM |
Total Post: 69
Joined: Dec, 2006
|
i prepared a sql
and trying to run it but following err:-
SP2-0042: unknown command "˙ūS" - rest of line ignored.
help me.
|
|
|
 Murtuja |
| Posted: Jan 04, 2008 05:59:28 AM |  |
|
Total Post: 843
Joined: Jan, 2006
|
Can you post that sql here ?
|
|
|
|
|
| ramesh |
| Posted: Jan 04, 2008 06:51:07 AM | |
|
Total Post: 69
Joined: Dec, 2006
|
spool c:\ho\loctables.txt
set lin 5000
set trimspool on
set echo on
drop tables DUMMY_PLIST;
drop tables DW_BANKTRAN_LOG;
drop tables DW_DESPATCH;
drop tables DW_GLTRACE;
drop tables DW_INVOICE;
drop tables DW_INVOICE_TRACE;
drop tables DW_INVTRACE;
drop tables DW_NETSALES_SUMM;
drop tables DW_PORCP;
drop tables DW_PORCPDET;
drop tables DW_PORDER;
drop tables DW_SORDER;
drop tables DW_SRETURN;
drop tables DW_SRETURNDET;
drop tables DW_SUNDRYBAL;
drop tables MITEM3;
drop tables MIT_TENVSTAN_201006;
drop tables TMP_GLTRACE;
drop tables TMP_STOCK;
drop tables TMP_STOCK_STATUS;
drop tables TMP_STOCK_STATUS1;
drop tables TMP_STOCK_STATUS2;
drop tables BACKUP_TAXTRAN;
drop tables USER_RIGHTS_BACKUP_010806;
drop tables RCV_ADJ_BACKUP;
drop tables INVOICE_BACKUP;
drop tables BATCHLOAD1;
drop tables BATCHLOAD10;
drop tables BATCHLOAD11;
drop tables BATCHLOAD12;
drop tables BATCHLOAD2;
drop tables BATCHLOAD3;
drop tables BATCHLOAD4;
drop tables BATCHLOAD5;
drop tables BATCHLOAD6;
drop tables BATCHLOAD7;
drop tables BATCHLOAD8;
drop tables BATCHLOAD9;
drop tables BATCHLOADDET1;
drop tables BATCHLOADDET10;
drop tables BATCHLOADDET11;
drop tables BATCHLOADDET12;
drop tables BATCHLOADDET2;
drop tables BATCHLOADDET3;
drop tables BATCHLOADDET4;
drop tables BATCHLOADDET5;
drop tables BATCHLOADDET6;
drop tables BATCHLOADDET7;
drop tables BATCHLOADDET8;
drop tables BATCHLOADDET9;
drop tables CLSTK_200511;
drop tables ITEM_LOT_PACKSIZE_180607;
drop tables ITM2MENU_BKUP_010806;
drop tables MTABLE;
drop tables NETSALES;
drop tables RECEIPT_BACKFLUSH_UTL1206;
truncate table SM_RECEIPT_ITEM;
truncate table SORDALLOC;
truncate table SORDER_STAT_LOG;
delete from APPRAISAL_SPEC;
delete from APPRAISAL_SPEC_TABLE;
delete from CADRE_AD;
commit;
delete from CADRE_MTHAD;
delete from CADRE_PERK;
commit;
delete from CADRE_SITE_LVETBL;
delete from GRADE;
delete from GRADE_MTHAD;
commit;
delete from GRADE_PERK;
delete from GRADE_SITE_LVETBL;
delete from GRADE_SITE_OT;
commit;
delete from HIERARCHY;
commit;
delete from HIERARCHY_DET;
commit;
delete from HOLIDAY;
commit;
delete from LOANPARTY;
delete from LOAN_SCHEME;
delete from LOAN_SCHEME_GRADE;
delete from LVETABLE;
delete from QUALIFICATION;
commit;
delete from SM_RECEIPT_ITEM;
delete from SM_REC_CUST;
commit;
delete from SM_SALES_CUST;
delete from SM_STK_ITEM;
commit;
delete from INVTRACE where LOC_CODE in ('INTR','INTR1') and tran_date <= '31-aug-2004';
commit;
delete from INVTRACE where LOC_CODE in ('INTR','INTR1') and tran_date <= '31-dec-2005';
commit;
delete from INVTRACE where LOC_CODE in ('INTR','INTR1') and tran_date <= '31-mar-2007';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-jan-2001';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-jan-2002';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-jan-2003';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-jan-2004';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-jan-2005';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-jan-2006';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-jan-2007';
commit;
delete from INVALLOC_TRACE where tran_date <= '30-sep-2007';
commit;
delete from SORDFORMDET where tran_id in(select tran_id from SORDFORM where order_date <= '30-sep-2007');
commit;
delete from SORDFORM where order_date <= '30-sep-2007';
commit;
SPOOL OFF
exit
|
|
|
|
|
| Murtuja |
| Posted: Jan 04, 2008 09:29:19 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
I have unix environment and your sql file is working fine for me.
I guess your sql file have some junk charactes so try to create new file. (copy each statement and paste)
|
|
|
|
|
| ramesh |
| Posted: Jan 09, 2008 12:21:37 AM | |
|
Total Post: 69
Joined: Dec, 2006
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
