Informix Error 309
be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: error -309 using order by via ODBC Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-05-03,08:15 #1 MEP View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 2 Unanswered: error -309 using order by via ODBC Hello, we have migrated our database to IDS 9.21 and work with it via ODBC SDK 2.81.TC2 and IBM Informix 3.82. Starting a select statement with an 'order by', i get now an error message 309, if the field i wish to sort is not a primary key. Is this a known problem or can anyone help us? Thanks in advance Reply With Quote 10-08-03,10:03 #2 gurey View Profile View Forum Posts Registered User Join Date Aug 2003 Location Argentina Posts 780 Re: error -309 using order by via ODBC Originally posted by MEP Hello, we have migrated our database to IDS 9.21 and work with it via ODBC SDK 2.81.TC2 and IBM Informix 3.82. Starting a select statement with an 'order by', i get now an error message 309, if the field i wish to sort is not a primary key. Is this a known problem or can anyone help us? Thanks in advance Hi, Verify the syntax SQL. column-name must be in SELECT list Gustavo. Reply With Quote 10-08-03,15:28 #3 MEP View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 2 Re: error -309 using order by via ODBC Originally posted by gurey Hi, Verify the syntax SQL. column-name must be in SELECT list Gustavo. Dear Gustavo, certainly the ordered column is in the select list. The problem is, that the order by only gets a resul
user forum > Topic: bigint/int8 bigserial/serial8 difference 11 replies Latest Post - 2010-05-27T07:59:14Z by SumitGoyal Display:ConversationsBy Date 1-12 of 12 Previous Next SystemAdmin 110000D4XK 1143 Posts Pinned topic bigint/int8 bigserial/serial8 difference 2010-04-03T13:42:05Z | Tags: Answered question This question has been answered. https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014452778 Unanswered question This question has not been answered yet. Is bigint and int8 are the same data type and if not what's the difference. The same for bigserial and serial8. Informix ODBC Driver does not http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/err_msgs/8_x/ccmalarms861.html return an ODBC standard data type for BIGINT and BIGSERIAL when driver option 'Report Stardard ODBC Types Only' is set in DSN setup Advanced tab. For example calling SQLGetTypeInfo I get the following info informix error for these data types (I am assuming -114 is SQL_INFX_BIGINT) type sql data type ------------- BIGINT -114 BIGSERIAL -114 INT8 SQL_BIGINT SERIAL8 SQL_BIGINT Log in to reply. Updated on 2010-05-27T07:59:14Z at 2010-05-27T07:59:14Z by SumitGoyal SumitGoyal 060000J2GE 7 Posts Re: bigint/int8 bigserial/serial8 difference 2010-04-05T09:58:13Z This is the accepted answer. This is the accepted answer. As per informix release notes BIGINT and BIGSERIAL data types have the same range of informix error 309 values as INT8 and SERIAL8 data types. However, BIGINT and BIGSERIAL have advantages for storage and computation over INT8 and SERIAL8. I am also facing the same issue with Informix ODBC driver. But -114 is for SQL Unknown datatype.Please clarify the same. How to use BIGINT and BIGSERIAL in the application for fetching result set from Informix database using Informix ODBC driver. Log in to reply. SystemAdmin 110000D4XK 1143 Posts Re: bigint/int8 bigserial/serial8 difference 2010-04-05T13:18:59Z This is the accepted answer. This is the accepted answer. SumitGoyal 060000J2GE 2010-04-05T09:58:13Z As per informix release notes BIGINT and BIGSERIAL data types have the same range of values as INT8 and SERIAL8 data types. However, BIGINT and BIGSERIAL have advantages for storage and computation over INT8 and SERIAL8. I am also facing the same issue with Informix ODBC driver. But -114 is for SQL Unknown datatype.Please clarify the same. How to use BIGINT and BIGSERIAL in the application for fetching result set from Informix database using Informix ODBC driver. More... I believe it is a bug in Informix ODBC driver to return data type as -114 (SQL_INFX_BIGINT) for bigint and bigserial (should return SQL_BIGINT) when driver option 'Report Stardard ODBC Types Only' is set in the DSN Advanced optio
My Cisco Cisco Unified Communications Manager (CallManager) System Error Messages for Cisco Unified Communications Manager 8.6(1) Hierarchical Navigation HOME SUPPORT PRODUCT SUPPORT UNIFIED COMMUNICATIONS CISCO UNIFIED COMMUNICATIONS MANAGER (CALLMANAGER) TROUBLESHOOT AND ALERTS ERROR AND SYSTEM MESSAGES System Error Messages for Cisco Unified Communications Manager 8.6(1) Error Message UC_CALLMANAGER-2-CallManagerFailure : Indicates an internal failure in Unified CM Additional Text[String] Host Name of Hosting Node[String] Host Node IP Address[String] Reason code[Enum] ExplanationThis alarm indicates that an internal failure occurred in the Cisco CallManager service. The service should restart in an attempt to clear the failure. Recommended ActionMonitor for other alarms and restart Cisco CallManager service, if necessary. Collect the core file if available, SDL and CCM/SDI trace files (you can gather these from Trace and Log Central in RTMT using the Collect Files feature) and contact the Cisco Technical Assistance Center (TAC). Reason Code - Enum Definitions Enum Definitions - Reason Value Definition 1 Unknown - Unified CM has failed for an unknown reason 2 HeartBeatStopped - An internal heart beat has stopped after the preceding heart beat interval 3 RouterThreadDied - An internal thread has failed 4 TimerThreadDied - An internal thread has failed 5 CriticalThreadDied - An internal thread has failed Error Message UC_CALLMANAGER-5-SDLLinkISV : SDL link to remote application restored Remote Application IP Address[String] Unique Link ID[String] Local Node ID[UInt] Local Application ID[Enum]Remote Node ID[UInt] Remote Application ID[Enum] ExplanationThis alarm indicates that the local Unified CM has gained communication with the remote Unified CM. Note that the remote Unified CM should also indicate SDLLinkISV with a different LinkID. Recommended ActionInformational only; no action is required Reason Code - Enum Definitions Enum Definitions - LocalApplicationId Value Definition 100 CallManager Enum Definitions - RemoteApplicationId Value Definition 100 CallManager Error Message UC_CALLMANAGER-1-SDLLinkOOS : SDL link to remote application is out of service Remote Application IP Address[String] Unique Link ID[String] Local Node ID[UInt] Local Application ID[Enum]Remote Node ID[UInt] Remote Application ID[Enum] Ex