Skip to Content
0
Jul 13, 2020 at 07:36 AM

RFCs deactivating on teh SAP Hana

32 Views

Hello Experts,

i didn't understand what wrong with this sql statement. I woulld deactivating all RFCs on the new SAP Hana database.

Here are two statesments for error code:

--disable output devices
update SAPxxx.tsp03c set PAMSSERVER = lpad (PAMSSERVER, (length(PAMSSERVER)+1), '#');
update SAPxxx.tsp03d set PAMSSERVER = lpad (PAMSSERVER, (length(PAMSSERVER)+1), '#');
commit;

Syntax errror:

Could not execute 'update SAPxxx.tsp03c set PAMSSERVER = lpad (PAMSSERVER, (length(PAMSSERVER)+1), ''
SAP DBTech JDBC: [257]: sql syntax error: line 1 col 81 (at pos 81)
Could not execute 'update SAPxxx.tsp03d set PAMSSERVER = lpad (PAMSSERVER, (length(PAMSSERVER)+1), ''
SAP DBTech JDBC: [257]: sql syntax error: line 1 col 81 (at pos 81)

Statement 'commit'
successfully executed in 1 ms 154 µs (server processing time: 0 ms 119 µs) - Rows Affected: 0

Thank you for helping.