Search DaniWeb - db2

Re: Question/Answering over SQL Data Using LangGraph Framework 2 Weeks Ago by Pelorus_1 Through its combination of natural language processing and structured query generation, LangGraph makes interfacing with databases and extracting insights over SQL data easier than ever. Re: SAP db - how to get the time update statistics was performed on a table? 2 Months Ago by peol To check when update statistics was last performed on an SAP table, use database-specific queries! For SAP HANA, check M_TABLES.LAST_COMPILED. In SQL Server, use STATS_DATE. For Oracle, check DBA_TAB_STATISTICS.LAST_ANALYZED. In DB2, use SYSCAT.TABLES.STATS_TIME. Stay optimized, stay ahead! Re: Multiple MySQL connections + transactions 1 Month Ago by Salem https://www.php.net/manual/en/mysqli.select-db.php I think the key word in all of this is "default". You can probably do what you want, but you have to refer to each DB by it's own handle. Using `select_db` is fine, if you only have one DB and you want to be lazy about referring to it. So you make it the default DB. But as … Re: How To Send MYSQL Data To An Email 2 Months Ago by Biiim Here's the code I've been using for about 15 years now - but a bit more simplified: function dbConnect($type = ''){ $conn = mysqli_connect( DBHOST, DBUSER, DBPASS, DBDB); if (!$conn) { echo "Error: Unable to connect to MySQL." . PHP_EOL; echo "Debugging errno: " . mysqli_connect_errno() . … Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim As far as I know you can connect to more than one database at a time but you require a separate connection object for each one. Since queries go through the connection object you can't run a query on more than one db at a time. It seems to me that transactions are also connection based so you would have to manually roll back a transaction on A if … Re: DB.php Problem 17 Years Ago by richie513 You now need to install the DB Package for PEAR and point the files that are calling on the DB.php file to point to that folders direction. P.S There is no need to change the php.ini file inside of the bin folder of apache. Just the one in the PHP directory:) You will have to download the DB package and install it manually as it is not … DB Design, trying to keep in sync without foreign-keys 17 Years Ago by cancausecancer I'm designing a db for a project which has tables: mainAccount, id int(11) auto_inc primary key username, password, country, email, verification users, id int(11) auto_inc primary key `type` tinyint (3) -fk userType.id description nvarchar interests nvarchar website nvarchar (many other columns..) userIndex, … DB Schema Export/Import Help 19 Years Ago by extofer I've been working on a production DB on a POS and Inventory System for over a year. That's over a year of data and along the way, I took that system and implemented to 4 locations and 4 individual servers. I've major software updates and Schema changes (adding Views, SP, changing Tables, etc.) By doing so, I can't keep up with all the changes and … Re: db run 15 Years Ago by network18 [QUOTE=itisnot_me;1094401]ok so what i want to beable to do is have a coded up website template (with php in it) that is stored in the DB. and i would like to call it in a query. That part works fine but what doesnt work is the php being called from the DB. It seems like it just calls the php but it does not execute. I did look this problem up on … DB-Authentication php/mysql on Mac OSX v3 20 Years Ago by jani Hello. I have installed PHP4 and MySQL (.dmg) on Mac OSX v3 client. Everything is up and running. I have created tables in my DB, established user privileges, etc through the 'terminal' app. I have turned on web sharing through the 'preferences' panel and dragged my .php files to the 'sites' folder. Accessing localhost/127.0.0.1 I see the .php … Re: DB.php Problem 17 Years Ago by richie513 Is this your own DB.php file, or are you trying to use the DB PEAR extension? If it is the PEAR DB file, you need to install PEAR then download and install the DB package, but in saying that, the DB package for PEAR is now out dated and is reccommended to you use the MDB2 PEAR package. Just some available info for you:) DB design capturing mergers and acquisitions 15 Years Ago by NewJoizey Hello - I'm just looking for some feedback and some discussion from other DB pros about the viability of a DB design I came up with. The goal is to create the DB back end to an application feature that keeps track of company name history in the event of name change, buy out or merger such that there is a traceable account history. I've come up … db run 15 Years Ago by itisnot_me ok so what i want to beable to do is have a coded up website template (with php in it) that is stored in the DB. and i would like to call it in a query. That part works fine but what doesnt work is the php being called from the DB. It seems like it just calls the php but it does not execute. I did look this problem up on the oracle (google) but saw… db modeling 14 Years Ago by sasha_3 Hi everybody, I have made my ER diagram for my DB, but i want it optimized. The db should store date for something like in attached images. I thought about a Products table with attributes: some_primary_Key, product_id, component_id,... The number of component is stored in another table; the question is how do i structure this dates so … DB SQL creating da/ds 13 Years Ago by applebule5 I am trying to set up a database with Students, Courses and grades. This is the main bulk of my code, I am stuck with the error below, could anybody help me? [CODE] Imports System.Data.OleDb Imports ADODB Public Class Form_Main Dim cn As OleDbConnection Dim StudentUpdateCommand As New OleDbCommand Dim CourseUpdateCommand … Re: db run 15 Years Ago by itisnot_me understand but what about running php from the DB. in my template i also have php to call the navigation and info from the DB on top of html. Re: db run 15 Years Ago by network18 [QUOTE=itisnot_me;1094884]understand but what about running php from the DB. in my template i also have php to call the navigation and info from the DB on top of html.[/QUOTE] you need to do the same for it DB issues when dropping DB and inserting test data 11 Years Ago by pezza Hi All, Having a few issues with some DB functions in my code at the moment. This code was developed by another user who kindly helped me out, and I know for sure it was working. The difference being that after having some compatability issues when upgrading to a new version of VS, I decided to create a new project from scratch and basically … Re: DB issues when dropping DB and inserting test data 11 Years Ago by cgeier When clicking on "Drop Tables", you need the offer the user the opportunity to cancel, in case the user accidently clicked the button. **Issue:** The error "Error (Open Connection): Error in dataAdapter. Invalid object name 'Schedule'", is occuring during the table drop because the timer is still executing a query on the table… DB design for friends network 17 Years Ago by rwagner I am building a site for which I would like to add a "friends" invitation system. Once member invites another to be a friend, the second member has to accept to become friends. So both members have to agree to be friends. My problem is that I can't think of a db schema that will allow me to do this without being redundant or requiring… DB Design Issues 16 Years Ago by varun077 Hi Friends, Our project is developed in J2ee technology using EJB, now we are migrating to hibernate. We are using Oracle 10g. Architecture of this project has not been satisfactory (including database) and we have several performance and maintenance issues, we are changing the architecture and database design now. I have some questions about … Db structure needed please 16 Years Ago by jamescumm Hi, I am a technophobe in his last year of a business/computing degree. If someone gave me the db structure for my final year project interim report to be handed in tomorrow I will be forever grateful................ I am designing a website where people can search for spare car parts. It will basically display a bunch of listboxes until the … Re: DB Connection IN c# 15 Years Ago by mahmoud_wow 1-import the nameSpace [CODE]using System.Data.SqlClient[/CODE] 2- Make a new object from SqlConnection Class [CODE] SqlConnection conn = new SqlConnection();[/CODE] 3- set the ConnectionString property of the SqlConnection; [CODE]string connString = @"Data Source=[COLOR="Red"]ServerName[/COLOR];Initial Catalog=[COLOR="Red"… Re: db run 15 Years Ago by itisnot_me ya i was thinking that is what i would have to do. even though it would be awesome if you can run some php from the DB but with some good security features Re: DB access error 14 Years Ago by boet Hi everyone I have a little problem I don't know how to fix. When I add data into the 'Preke' fields and click the submit button, it takes me to a blank page. It's suppose to take me to the 'Preke' page where the new info that's added, is displayed at the top of the page, with the rest of the old info underneath. I tried everything I know, but … DB Url databinding to Labels 14 Years Ago by wrathyimp I have a pages table with following columns: DB Table: sno name title url parentPage 1 Reports Reports [url]http://1[/url] 0 2 Reports Local [url]http://2[/url] 1 3 Reports Intl [url]http://3[/url] 1 Now I need to to display the label as Report - Local: So report will be linked to the … DB backup and restore problems 14 Years Ago by 00100110 Hello all, I started a new project wich function is restoring a corrupted DB. I started with making a backup of the original db and then trying to restore it again. But when executing my code i get following error [CODE]IErrorInfo.GetDescription failed with E_FAIL(0x80004005)[/CODE] Anyone got an idea how to resolve this? Functions:… DB design for learning english words 14 Years Ago by jayanandan I am designing my own site to learn English words. Attached is the image of my DB design. Can some one suggest/direct me to design the DB more perfectly? DB vs Code 12 Years Ago by DarkMonarch Hey, been awhile. I'm working on a portal for distributors, some type of JIT (just in time) implementation. Now i've been reading alot on DB so i can implement the right database and the right data structure. Now i see, i can do alot more then i'm use to do. My question: Is it better to pre-organized the data in the DB engin (i'm using MySQL) … Re: DB vs Code 12 Years Ago by DarkMonarch Nah! i don't have any code yet, i'm still at the designing part. yeah i'll be using mysqli, but i was refering to MySQL engin Simple exemple: a query that ORDER BY something ASC versus a quicksort or bubble sort or do a complex query to pin point a specific data versus a dicotomic search yes i understand some manipulations can only be done in…