If it worked for me - it should work for you too ..read more

i've a stored procedure namea if i execute the command CALL namea(); non errors occurs. But if i call thi stored procedure from another stored procedure nameb with CALL instruction i receive error division by zero on a sql inside stored namea where i do something an UPDATE in a table. but in another instrucyions che i do same thing in onother table i don't recevie any errors this can be caused by a privilege that i changed ? how can i solve the problem ? thanks ..read more

Many of you may have seen the log message that starts out Code: "root" execution of the PostgreSQL server is not permitted. Yes, I know and now when I try to start up the server, I do so with the postgres account that does NOT have admin capability. My problem is that this message keeps flooding my /usr/local/var/log/postgresql@14.log file about every three seconds and I don't even have a postgresql server running. I starts sending the messages to the log file immediately after a reboot. How can I get these messages to STOP. Thank you for your wisdom and expertise ..read more

Hello, guys i’m working on an assignment, and i would like your input.So i need to make a database with normalization to at least 3NF.Does it meet the criteria because, in my head, it does seem to be 3NF Thanks guys ..read more

I am trying to find a certain value that exists in 3 tables with identical columns and I am trying to find with this process DECLARE @SearchValue NVARCHAR(255) SET @SearchValue = 'YourSearchValue' -- Search in Table1 SELECT 'Table1' AS TableName, YourColumnName AS MatchedValue FROM Table1 WHERE YourColumnName = @SearchValue -- Search in Table2 UNION ALL SELECT 'Table2' AS TableName, YourColumnName AS MatchedValue FROM Table2 WHERE YourColumnName = @SearchValue -- Search in Table3 UNION ALL SELECT 'Table3' AS TableName, YourColumnName AS MatchedValue FROM Table3 WHERE YourColumnName = @Sear ..read more

Hi everyone. I have installed DB2 LUW 11.5.8 some days ago on my Windows 10. Connection from PHP 8.1 works fine, but I do not succeed to connect from Perl (Strawberry Perl 5.32.1.1, 64bit). Trying to install DBD:DB2 (using CPAN) fails. So, I tried to connect using ODBC. But, when running my script (essentially the same that I use with Firebird ODBC), nothing happens; what I mean is that the script runs and runs, no output... The problem can't be a bad configuration of my DSN, because connection from Windows ODBC Administartor worls well, and I succeed to read data from the "sample" database fr ..read more

at the office I am running queries from a command line sybase shell and I would like to be able to page the output one screen at a time like you would do on a linux command line by piping command output through to less. Is this possible ..read more

This is a highly theoretical question for which there is no good answer. I hope it is a good discussion and I hope it is okay for me to ask. In the 1980s I worked for an aircraft manufacturer. They built large aircraft, some of the largest. There was an application they called Tumbledown. It would find hierarchical errors, such as an assembly being a component of itself. It would start at the top of the design and tumble down. At that time even the most advanced computers were not capable of processing the entire aircraft design in real time, at the time that the engineer updated the design u ..read more

Anyone familiar with the following books by C. J. Date: SQL and Relational Theory Database Design and Relational Theory Relational Theory for Computer Professionals How do they compare? I want to know for the purpose of deciding which to invest time and money into. Database Design and Relational Theory published by APress I think is the most economical. Is it a good investment of time? I have been programming for half a century. I am asking as a programmer. I am interested in read a book from a recognized authority such as C. J. Date. Normally I would first try to search for answers pr ..read more

I've gotten some stored procedures to work with LANGUAGE plpgsql, but now I want to start writing stored procedures using LANGUAGE pltcl but I'm having problems setting things up. I've installed some extra packages (although I'm not sure why the website I was looking at wanted me to also install the package for Perl, but I did it anyway). Code: sudo apt-get install postgresql-pltcl-15 sudo apt-get install postgresql-plperl-15 sudo apt install postgresql-15-postgis-3-scripts I've seen in pgAdmin there is something about Languages and the only one there is plpgsql. I don't know what to do abou ..read more