[db2] Forum Topics

i want to combine multiple rows into a single row using **DB2**. I have found this code, but I do not know how can i edit it>? CREATE FUNCTION MySchema/MyUDF ( PARCol2 CHAR(5) ) RETURNS VARCHAR(1024) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA CALLED ON NULL INPUT DISALLOW PARALLEL BEGIN …

The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all …

Hi guys, I need to put data that i get it from db2 and display it into each text boxes (Name, Address and Postcode). What i got now, its displayed Name's data that i got from db2 into all text boxes (Name, Address and Postcode) . All i want is …

Hello, What seems so trivial, has been bugging me. I have a table with duplicate values on one column, while non-duplicate (date) values on the other. If I am to use DISTINCT it will only eliminate the row with the same date. But how do I use DISTINCT and only …

Hi! Could you help me initialize or load the data into a Data Grid View Control using iDB2 Connection? I've tried this code I've seen from the net but it does not seem to work :( I am initializing the connection using form_load and not in the Properties Window. Imports …

Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated Security=True" Dim conn As SqlConnection = New SqlConnection(str) conn.Open() Now, I wanted to execute a delete query, however, I already …

Hello guys, I created two database in derby: DB1 with one table Customers and its columns id,name,last And DB2 with one table Purchases anf its colums CustID, total I would like to makes queries from data in both of these database. I tried SELECT C.name, C.last, U.Total FROM DB1.Customers C …

Good day, Just want to ask some help, Please! I always encounter "Cannot find Table 0" when i call Stored Procedure in DB2 using VB .Net with Ole DBConnection Provider. Here is my code: Private Sub cmdPost_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdPost.Click rsSearch = clsDAOMngr.getConfigParam(2) For …

What is the Diffrence between Db2 and Oracle databse please explain

hi i am entirely new to eclipse, db2 and wasce. but for a certain project i need to make a project using the above tools in java. so i did the following 1. Installed db2 v 9.7 with username & password both admin 2. Installed wasce 3. Installed Eclipse my …

Hello, I have installed DB2 Everyplace, it installed successfully but not able to configure. Getting Error while try to configure it. The error is like this : [CODE] [exec] UPDATE DATABASE CONFIGURATION FOR DSYMSGDB USING MAXLOCKS 50 [exec] SQL1032N No start database manager command was issued. SQLSTATE=57019 [exec] SQL1032N No …