I just tried different values of inserbuff and dbcommit and it does not work (including recommendation dbcommit=0)   When I used insertbuff=1 it works. But, it is supposed that this parameter increase speed for insertion? if I use 1, massive insertions could be slow? ... View more

I just tried using proc sql and insert, and it happens the same, it only insert first record ... View more

thanks   That's what I was trying to do. But why do you use proc corr? As I understand your code, you use sscp option in order to show only sum of squares ... View more

I'm getting the same error using SAS Financial Management 5.6 ... View more

I'm have got this message recently   I used the option trace referred in this post and I got this      ORACLE_1: Prepared: on connection 11 1 1562878422 no_name 0 SQL (2) SELECT * FROM LDC.CLIENTE_TERCERO 2 1562878422 no_name 0 SQL (2) 3 1562878422 no_name 0 SQL (2) 4 1562878422 no_name 0 SQL (2) ORACLE_2: Prepared: on connection 11 5 1562878422 no_name 0 SQL (2) SELECT * FROM LDC.CT_SEGMENTACION 6 1562878422 no_name 0 SQL (2) 7 1562878422 no_name 0 SQL (2) 8 1562878422 no_name 0 SQL (2) ORACLE_3: Prepared: on connection 11 9 1562878422 no_name 0 SQL (2) SELECT NULL as TABLE_QUALIFIER, t.owner as TABLE_OWNER, t.table_name as TABLE_NAME, t.num_rows as ROW_COUNT FROM all_tables t WHERE t.table_name='CLIENTE_TERCERO' AND t.owner='LDC' 10 1562878422 no_name 0 SQL (2) 11 1562878422 no_name 0 SQL (2) 12 1562878422 no_name 0 SQL (2) 8 The SAS System 16:50 Thursday, July 11, 2019 ORACLE_4: Executed: on connection 11 13 1562878422 no_name 0 SQL (2) SELECT statement ORACLE_3 14 1562878422 no_name 0 SQL (2) 15 1562878422 no_name 0 SQL (2) 16 1562878422 no_name 0 SQL (2) ORACLE_5: Prepared: on connection 11 17 1562878422 no_name 0 SQL (2) SELECT NULL as TABLE_QUALIFIER, t.owner as TABLE_OWNER, t.table_name as TABLE_NAME, t.num_rows as ROW_COUNT FROM all_tables t WHERE t.table_name='CT_SEGMENTACION' AND t.owner='LDC' 18 1562878422 no_name 0 SQL (2) 19 1562878422 no_name 0 SQL (2) 20 1562878422 no_name 0 SQL (2) ORACLE_6: Executed: on connection 11 21 1562878422 no_name 0 SQL (2) SELECT statement ORACLE_5 22 1562878422 no_name 0 SQL (2) 23 1562878422 no_name 0 SQL (2) 24 1562878422 no_name 0 SQL (2) ORACLE_7: Prepared: on connection 11 25 1562878422 no_name 0 SQL (2) SELECT "TIPOIDENT", "IDENT", "SEGMENTACION", "IDCLIENTE" FROM LDC.CLIENTE_TERCERO WHERE ( ("TIPOIDENT" NOT IN ( 'I' , 'J' ) ) ) 26 1562878422 no_name 0 SQL (2) 27 1562878422 no_name 0 SQL (2) 28 1562878422 no_name 0 SQL (2) ORACLE_8: Executed: on connection 11 29 1562878422 no_name 0 SQL (2) SELECT statement ORACLE_7 30 1562878422 no_name 0 SQL (2) 31 1562878422 no_name 0 SQL (2) 32 1562878422 no_name 0 SQL (2) ORACLE_9: Prepared: on connection 11 33 1562878422 no_name 0 SQL (2) SELECT "DESCSEGMENTACION", "CODSEGMENTACION" FROM LDC.CT_SEGMENTACION 34 1562878422 no_name 0 SQL (2) 35 1562878422 no_name 0 SQL (2) 36 1562878422 no_name 0 SQL (2) ORACLE_10: Executed: on connection 11 37 1562878422 no_name 0 SQL (2) SELECT statement ORACLE_9 38 1562878422 no_name 0 SQL (2) 39 1562878422 no_name 0 SQL (2) ORACLE: Pipelined I/O thread did not timely terminate ORACLE: Pipelined I/O thread terminated on 2nd attempt 40 1562878424 no_name 0 SQL (2) ORACLE_11: Prepared: on connection 11 41 1562878424 no_name 0 SQL (2) SELECT "TIPOIDENT", "IDENT", "SEGMENTACION", "IDCLIENTE" FROM LDC.CLIENTE_TERCERO WHERE ( ( ("TIPOIDENT" NOT IN ( 'I' , 'J' ) ) ) AND ( ("SEGMENTACION" IN ( '00' , '01' , '02' , '03' , '04' , '05' , '06' , '11' , '13' , '15' , '17' , '50' , '51' , '52' , '53' , '54' , '55' , '56' , '88' , '99' ) ) ) ) 42 1562878424 no_name 0 SQL (2) 43 1562878424 no_name 0 SQL (2) 44 1562878424 no_name 0 SQL (2) ORACLE_12: Executed: on connection 11 45 1562878424 no_name 0 SQL (2) SELECT statement ORACLE_11 46 1562878424 no_name 0 SQL (2) 47 1562878424 no_name 0 SQL (2)   ... View more