Date: Fri, 17 Mar 2006 15:48:31 -0500
Reply-To: Faiyazmehadi Momin <Faiyazmehadi.momin@PHS.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Faiyazmehadi Momin <Faiyazmehadi.momin@PHS.COM>
Subject: Re: SAS Append on Server
I figured out the bug. It was wtih the settings in ODBC. The server
ODBC setting for performance was set to Direct. Due to which the ODBC
connection was now working. When I set it to Cursor, it worked perfect.
Thanks for your suggestion.
However now I have new issue of passing the parameter to stored
procedures. how do we pass Bit and Datetime values to stored procedures.
Your suggestion would be very helpful.
connect to ODBC as Conn2(dsn='ODBC connection' user=USER1 password=PWD1);
execute (EXECUTE Ins_NewTask_PAR &rows,
&ClinicalPatientID, "&AssignedToTeam", "&Notes", "&UserID", "&TaskType", "&
AssignedToUser", &ProcessedDate) by conn2;
disconnect from conn2;
Where Rows and l;ocked is Bit integer and Processeddate is Datetime