#DateForumTypeThreadPost
928 Aug 2015 @ 09:44 PDTDatabaseReplyInvalid session mode for procedure executionThanks Fred , I was able to change it in below option and it worked   ODBC ADministrator --> Configure --> Options --> Session Mode 
827 Aug 2015 @ 02:14 PDTDatabaseReplyInvalid session mode for procedure executionHello all .. Any idea how to set this it SQL assistant  Getting same error : CALL Failed. 5510:  Invalid session mode for procedure execution.  help   procedure X...
701 Dec 2014 @ 03:06 PSTDatabaseReplyselecting one record out of many records depending on few rulesThanks much Dieter , I understood the logic and its working fine 
601 Dec 2014 @ 12:40 PSTDatabaseReplyselecting one record out of many records depending on few rulesThanks Dieter for the response .  There are 4 rules  If 01 02 and 07 then ind  to 02  if 01 and 02 then ind  to 02  if 01 and 07 then ind  to 07 ...
530 Nov 2014 @ 11:21 PSTDatabaseTopicselecting one record out of many records depending on few rules Hi , I tried checking forums before posting this query. Please suggest    I am  getting below o/p by joining couple of tables ACT ACTIND A1   01 A...
419 Aug 2013 @ 04:33 PDTDatabaseReplyUsing static Day value in a particular Date   Thanks Dieter .. I was about to ask the same question as I got error while trying more than one value in the IN clause using my old code aswell .   :-)       &...
319 Aug 2013 @ 01:43 PDTDatabaseTopicUsing static Day value in a particular Date Hi .. Have a requirement in which I have to search particular day for the current month , the query is running ..  For ex . If I am running query for May'2013 the where condition should b...
213 Aug 2013 @ 08:46 PDTDatabaseReplyCan we use position function in stored procedureDieter , My mistake , there was some issue the way I was using in SQL ( Select POSITION('' in fieldname) into variable from table ) and as part of SPL Code ( IF position('',varia...
113 Aug 2013 @ 03:52 PDTDatabaseTopicCan we use position function in stored procedureHi .. Can we use POSITION function in stored procedure ? It gave error when I try to use this function , probably because Stored Procedure itself contains POSITION keyword !! Actually I wanted t...