#DateForumTypeThreadPost
726 Aug 2016 @ 10:30 PDTDatabaseReplyEXPORTING SELECT QUERY OUTPUT TO A TEXT FILEDear Mr. ulrich, appologies for writing in uppercase. I am using this query in Microsoft PowerQuery through ODBC connection. KAM
625 Aug 2016 @ 10:51 PDTDatabaseTopicEXPORTING SELECT QUERY OUTPUT TO A TEXT FILEHELLO, CAN ANY TELL ME HOW TO EXPORT RESULT OF FOLLOWING QUERY TO A TEXT FILE SELECT ACCOUNT_NAME, ACCOUNT_TITLE FROM DB_BRANCH.ACCOUNTS WHERE BRANCH_PARTY_ID = '5555' ...
517 Aug 2016 @ 05:11 PDTDatabaseTopicResults differ between query applied on single and query applied on whole branch accountsDear All, Please refer this ACCOUNT_NUM = 680213 BRANCH_PARTY_ID = 12311 Both ACCOUNT_NUM and BRANCH_PARTY_ID are part of EVENT table. Account No 680213 is part of branch 12311 I run followin...
403 Aug 2016 @ 01:15 PDTDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. Oh found the abs() function and it worked. Sum(abs(t2.Event_Amt)) Regards   KAM
303 Aug 2016 @ 12:49 PDTDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. Thank you very much Sir, Your suggested code worked fine. Just need to ask two more things if you can please help. 1. The field Event_Amt contains Negative as well as positive number so their su...
202 Aug 2016 @ 09:03 PDTDatabaseReplyODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. @dnoeth Actually i want to select Account_Num and Account_Status_End_Dt from Account_Status_Hist table based on Account_Num from Agreement Table with condition that their bnrahc_party_id should be...
102 Aug 2016 @ 05:14 PDTDatabaseTopicODBC: ERROR [42000] Data Type "Account_Num" does not match a Defined Type name. Dear All, I am getting the subject error while running following code theough ODBC. with t1(Account_Num, Acct_Status_End_Dt) As ( Select Account_Num, Acct_Status_End_Dt from dp_view_t24_ibg....