Hello there,
How can load data to MAXDB1 as SQL scripts? I used SQLCLI command line but it fails. it does not recognize the SQL file format Here is how I called SQLCLI : C:\Program Files\sdb\programs\bin>sqlcli -d maxdb1 -u warid,rami123 -S oracle -c ; -n localhost -r i \adm_system_directoris.sql * -3005: POS(1) Invalid SQL statement SQLSTATE: 42000 I used -c to indicate that the statement separator is ';' no the default one '//' , Is there any faster way to upload data ? , what is the problem with the SQLCLI command? The following is sample of the file content [adm_system_directoris.sql] ( generated by TOAD from Oracle DB ): INSERT INTO CDR_PROCESSING ( CDR_SCENARIO, PROCESSING_ORDER, PROCESSING_ACTION, DESCRIPTION, CLOSING_MODE, CLOSING_NAME, SM_PREFIX, ACTION_STATUS, LOGNAME, LOGDATE, FLEX_FLD1, FLEX_FLD2, FLEX_FLD3, FLEX_FLD4, FLEX_FLD5 ) VALUES ( 'S1', 1, 'FF', NULL, 'INSTANT', NULL, NULL, NULL, 'MUSTAFAH', TO_Date( '05/07/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , NULL, NULL, NULL, NULL, NULL); INSERT INTO CDR_PROCESSING ( CDR_SCENARIO, PROCESSING_ORDER, PROCESSING_ACTION, DESCRIPTION, CLOSING_MODE, CLOSING_NAME, SM_PREFIX, ACTION_STATUS, LOGNAME, LOGDATE, FLEX_FLD1, FLEX_FLD2, FLEX_FLD3, FLEX_FLD4, FLEX_FLD5 ) VALUES ( 'I1', 1, 'FF', NULL, 'INSTANT', NULL, NULL, NULL, 'NAVEED', TO_Date( '05/07/2005 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM') , NULL, NULL, NULL, NULL, NULL); ....... .... .. . With Regards, Rami ALSAHHAR International Turnkey Systems www.its.ws <http://www.its.ws/>
