Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. LIBNAME CISCO SQLSVR DBLIBINIT='SET ANSI_NULLS, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING ON' Datasrc="nikolaev.ivan.ru" SCHEMA=cc USER=vorob2 PASSWORD="{SAS002}9930904131DC199B130A9E7D42A49B5D" ;
  2. proc sql;
  3. insert into CISCO.vContact_I (FirstName, MidName, LastName, Address, Phone, MobilePhone, EMail, ClientCode, AddInfo, Sex, TOPIC_ID, CUSTOMER_RK, RESPONSE_TRACK_CD, QuestFlag, CriticalMessage, RegularMessage)
  4. values ('N/A','AO Lomon', 'Воронин Саша', 'N/A/N/A/N/A мес/платеж N/A','N/A', 'N/A','N/A','01039602','',1,.,'01039602','26670201',0,'N/A','N/A');
  5. quit;
  6.  
  7. ERROR: CLI execute error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]INSERT failed because the following SET
  8. options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or
  9. indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial
  10. index operations. : [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared.
  11.  
  12. proc sql;
  13. connect to sqlsvr as sql
  14. (Datasrc="nikolaev.ivan.ru" USER=vorob2 PASSWORD="{SAS002}9930914010DC199B130A9E7D42A49B5D");
  15. execute(
  16. SET QUOTED_IDENTIFIER ON;
  17. insert into cc.vContact_I (FirstName, MidName, LastName, Address, Phone, MobilePhone, EMail, ClientCode, AddInfo, Sex, TOPIC_ID, CUSTOMER_RK, RESPONSE_TRACK_CD, QuestFlag, CriticalMessage, RegularMessage)
  18. values ('N/A','AO Lomon', 'Воронин Саша', 'N/A/N/A/N/A мес/платеж N/A','N/A', 'N/A','N/A','01039602','',1,'','01039602','26670201',0,'N/A','N/A');
  19. ) by sql;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement