Hi, I have some column values:- employee_salary | dept 30000 1 35000 1 40000 1 I need employee-salary in one row separated by comma by executing a sql query i.e dept1_salary 30000, 40000, 50000 A SQL query would be very Continue reading Column Values into comma separated row
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: “Microsoft SQL Server Native Client 11.0” Hresult: 0x80004005 Description: “Unspecified error”. (SQL Server Import Continue reading SQL Conversion of data types Errors Multiple
Hi Helpers, In cobol DB2-Query where clause, i saw many developers were using working storage variable for any comparisons and host variable to pass direct values Example: Activefrom > :WS-Activefrom(it is Working storage variable) But while passing direct value Activefrom Continue reading DB2 Host Variable
Hi, I am having two db2 database of 9.7 Version, fix-pack 3,edition is ESE and Operating system is Linux( 5.4 Tikanga). During the application upgrade on the DR system the structure of the database tables on the secondary database changed. Continue reading Importing data in to another database tables with different table definition
Hi All, I have this store proc to delete from 2 tables. This code would run daily to ensure the tables dont get too large , so after the data has been copied to the target(PARTS) table it deletes the Continue reading Is this query sufficient to handle exceptions
hello guys.. i have an keen interest in Database. I want to learn Oracle. I need to make strong my basics. I dont know how to learn Oracle . Will you guys help me to learn oracle. Thanks
MySQL: Server version: 5.1.69 Source distribution Operating System: Linux 2.6.32-358.14.1.el6.x86_64 x86_64 I have following table structure CREATE TABLE `some_table` ( `some_table_id` int(20) NOT NULL AUTO_INCREMENT, `from_number` varchar(60) DEFAULT NULL, `to_number_proxy` varchar(100) DEFAULT NULL, `to_number` varchar(60) DEFAULT NULL, `datetime` timestamp NOT Continue reading Select query not selecting date range as provided in where clause
Hi all, Not sure whether anyone of you encounter the following error during initiating the db2hpu command INZU478E An error occurred while staging in the /tmp/ directory (reason code 2) /opt/IBM/HPU/V5.1/bin/db2hpu: 2883682 Segmentation fault INZ0666F PROGRAM ABORTED BY USER. Thanks.
Hello, I have got stuck in a very weird situation. I have trying to execute following update statement: update employee set name=’Gaurav’ where id=121; before and after this update the value of name remain same as previous i.e. ‘Sunil’, even Continue reading Update statement mystery
Hi All, I’m new to db2. Could you please help me to find out this issue that I’m facing while connecting db2 Database auditing must be enabled. Instance Name : DB2, Database Name: SAMPLE. Db2 version : 9.5 Operating system Continue reading Database auditing must be enabled. Instance Name : DB2, Database Name: SAMPLE.