I want to see whether the column is created with the option, 'GENERATED ALWAYS AS IDENTITY', to make use of that in my application whether to create the record including the value for that column or not. Can anyone please help me in getting this attribute/property from any syscolumns information from DB2 database?
coder21k
Posts
-
How to get the 'GENERATED ALWAYS AS IDENTITY' attribute of the column from a DB2 table? -
Problem with TIMESTAMP WITH LOCAL TIMEZONE datatype in Oracle 9iNo, the Daylight savings time is not checked. The timezone is set to 'US/Canada' "-5:00 Hrs".
-
Problem with TIMESTAMP WITH LOCAL TIMEZONE datatype in Oracle 9iI am seeing a weird behavior in reading a column(of type TIMESTAMP WITH LOCAL TIME ZONE) from Oracle 9i version as compared to othe versions of Oracle (10g and 11g). I have developed a windows client which connects to the foriegn database(ORACLE) and do the transactions(WRITE and READ). Though the value which is written(storage value) is same in all the versions, the value which I read from the database is different wih Oracle 9i. If anyone has faced this issue, please help me resolving this. Thanks in advance.
-
Tracking application crashes in 'C'I am working on a database application, developed in 'C' programming language, which talks to database through the odbc drivers. What is the best way to track/troubleshoot the 'crash' errors like NULL pointers, memory crashes, etc? As the application is a huge code base, I am looking for one smart way to track the application crashes. Please suggest, if any?
-
What is the best way to track 'database' modifications?Suppose, I have an application which talks to a database in SQL/Oracle, and presents some set of data to the user. If, for any reason, someone modifies the table structure in the original database, and the application tries to work on the database, there will be an error or incorrect data being displayed. Is there any way to prompt the user that there was a modification happened on this database ,.. with these tables modified,.. and so on? Or can we write a windows service to do this kind of tracking a database?
-
Allocating a new SQL_HANDLE_ENV for every new logical databaseI have an application which has two database connections with two different logical databases (with different DSNs). Can I work with the sane SQL_HANDLE_ENV for both the connections, or do I need to create a new SQL_HANDLE_ENV for every logical database? Please help me.
-
Proper #include sequenceOne way to make sure you include only required headers. is by using #define macros.
-
Visual C++ equivalent of "TModule" in Borland C++ [modified]Thanks for your reply. I have modified my question including the details of what TModule is.
-
Visual C++ equivalent of "TModule" in Borland C++ [modified]If anyone has previously used "TModule" in Borland C++, can you please let me know the equivalent(if any) class in win32 or atlease close to that class in similarity. I am migrating one of my application wrtten in borland C++ to visual C++. Just for your reference: "TModule in Borland C++ forms the basis for the TApplication class, which encapsulates the application's global functions such as startup tasks, message loops, and error handling. The TDll class provides a similar base for developing dynamic link libraries (DLL)."
modified on Thursday, July 15, 2010 4:03 AM
-
Borland C++ to Visual C++ conversionI have a graphics application which is written in Borland C++ using various classes like TDC, TPen, etc. which I have to convert into Visual C++ application with MFC. What is the best approach to make this more efficient and less time consuming? Is there any third-party library which has Visual C++ wrappers for Borland C++? Please suggest.
-
[C#] Propertygrid - Textbox and listbox for previous valuesProbably, you can add vscrollbar control to your application and you can display the previous values from a stored data file like .xml or .txt. You can implement this using serialization.
-
Adding sub-menu items to visio objectI am using visio 2007 in one of the editor in my application, in which I want to add new menu items to the visio objects. That means when I right-click on the object, I should get my new meni item with the sub-menus inside it.The problem here is, I am able to add new menu items to the visio object but sub-menus, I could not add. Can someone help me out by providing me necessary information to resolve this?
-
What issues(thread sync issues?) may come up while migrating a multi-threaded application to windows 7 environment with multi-core processor?I have a multi-threaded .NET application which was built on 2.0 framework, which I am migrating to windows 7 environment(and .NET 3.5) with multi-core processor. What are the various issue which might come up? Does anyone has this experience of facing any thread synchronization issues? If so, please share with me.Also please let me know about the coding changes required to resolve these issues.
-
Challenges of running an application on multi core environmentThanks for your comments!! Exactly, I am also worried about the thread/process synchronization issues that may come up in the multi core environment. Can anyone have the experience of facing such issues, or atleast have the knowledge about the issues, if so, please reply?
-
Challenges of running an application on multi core environmentI want to know what sort of complexities may arise, if we port an existing application(huge application having so many threads connected to various components) onto a multi-core system.What all the things that can be taken care of while developing an application in order to make it run efficiently in multi-core environment too? If someone have the experience in handling such scenario, please suggest.
-
Problem with Visio 2007I have upgraded an application which was using 'Visio' and 'VisiOcx' of Microsoft Office Visio 2003 version, to Microsoft Office Visio 2007 (Upgraded the application from visual studio 2005 to visual studio 2008). The upgraded application is causing issues in not triggering 'Selection Change' event for VisiOcx. Can someone help me in resolvign this issue please?
-
How to convert hundreds of VS2005 soltions to VS2008?Thanks for the reply. Yeah I know using the command promt to convert the files to vs2008. But again it will open up the wizard to convert. I am expecting a tool/shortcut methos to convert a series of .sln files located in a folder at one shot. Is it possible to do that?
-
How to convert hundreds of VS2005 soltions to VS2008?I am facing a tedious task of converting whole application(which have hundreds of solution files) from visual studio 2005 to visual studio 2008. Please help in minizing the work of opening every solution file in 2008 and converting and saving. Also please help me in chaging the project settings for all these files at once and building all the solutions.