Activity Stream - Database Journal Forums

01-24-2023, 01:08 AM

johnsonmillie53 replied to a thread Reverse Engineering via tracing in Database Lounge

Your approach of directing your client to obtain vendor approval in writing before attempting to trace and reverse engineer the application is a...

2 replies | 20768 view(s)

01-24-2023, 01:00 AM

johnsonmillie53 replied to a thread Access 365 - Query - Duplicate Unique Values in query output - how to resolve please in Microsoft Access

In Microsoft Access, if you are running a query and the output contains duplicate unique values, you can use a DISTINCT clause or a GROUP BY clause...

6 replies | 20818 view(s)

01-23-2023, 03:19 PM

June7 replied to a thread [newbie] Include latest ID into INSERT? in Structured Query Language (SQL)

Possibly: INSERT INTO 'phpbb_posts' (forum_id,topic_title,topic_poster,topic_time) VALUES ((SELECT LAST_INSERT_ID()), other data...);

1 replies | 74 view(s)

01-23-2023, 06:45 AM

littlebigman started a thread [newbie] Include latest ID into INSERT? in Structured Query Language (SQL)

Hello, I need to write a script in SQL to import topics + posts into a phpBB forum. The issue I have is: How can I reference the last topic ID...

1 replies | 74 view(s)

01-23-2023, 01:08 AM

johnsonmillie53 replied to a thread Crosstab query Access2003 - How to restrict results parameterized? in Microsoft Access

In Microsoft Access 2003, you can use a parameterized query to restrict the results of a crosstab query. A parameterized query is a query that allows...

2 replies | 16604 view(s)

01-23-2023, 12:56 AM

johnsonmillie53 replied to a thread What namspace and I missing for Serilog? in Database Programming

The error message you are seeing suggests that the compiler cannot find the "WriteTo.File" extension method for the Serilog LoggerConfiguration...

1 replies | 9965 view(s)

01-21-2023, 12:54 AM

johnsonmillie53 replied to a thread How to use calculated column value in where clause in Informix

There are a few ways to retrieve data filtered by the results of a calculated column it totally depends on the database you are using. Here are some...

1 replies | 29937 view(s)

01-20-2023, 02:17 AM

johnsonmillie53 replied to a thread Informix Password Problem. in Informix

It sounds like you may have removed the Informix database server without properly backing up or saving the login information, which is why you are...

1 replies | 61992 view(s)

01-19-2023, 08:06 AM

johnsonmillie53 replied to a thread Suggest Best Book for MySQL for Beginner in MySQL

Hi there. I'm pursuing my basic course in coding and before I started my course, I had read a few books that helped me a lot. If you are still...

1 replies | 2400 view(s)

01-19-2023, 12:06 AM

johnsonmillie53 replied to a thread seeking help in LIKE / MATCHES in IBM informix sql in IBM DB2

The reason that the query is returning a row where c2 = '5' is that the '%' wildcard character in a SQL LIKE statement represents zero or more...

2 replies | 2741 view(s)

01-18-2023, 12:25 AM

johnsonmillie53 replied to a thread How to query Customer's credit/debit total balance with this table structure in MYSQL in MySQL

You can use a combination of the SUM() function, the CASE statement, and a subquery to retrieve the customer's credit/debit total balance with this...

2 replies | 1082 view(s)

01-18-2023, 12:20 AM

johnsonmillie53 replied to a thread How precisely are parameters set and used in datasets in SSRS? in Reporting Services

In SSRS, parameters are used to provide dynamic values to a report. They can be set in the report's dataset queries, as well as in other parts of the...

1 replies | 10201 view(s)

01-18-2023, 12:14 AM

johnsonmillie53 replied to a thread Compare two tables from different databases in Sybase

Yes, you can use checksum or hash values to compare the data in two tables from different databases in Sybase. This approach can be more efficient...

1 replies | 4106 view(s)

01-18-2023, 12:09 AM

johnsonmillie53 replied to a thread Trying to Create REGEXP Pattern That Will Detect Numbers Separated by a Space in MySQL

The issue with the regular expressions you provided is that they are looking for a specific format of the string where the numbers are 4 digits and...

2 replies | 1721 view(s)

01-17-2023, 11:54 PM

johnsonmillie53 replied to a thread query multiple tables in Microsoft Access

In Microsoft Access, you can use a query to combine data from multiple tables and update the serial number column in the template table with the...

2 replies | 14746 view(s)

01-17-2023, 11:40 PM

johnsonmillie53 replied to a thread How to copy Oracle database to another machine in Oracle

Export the source database: On the source machine, use the Oracle Data Pump export utility (expdp) to export the source database. This will create a...

4 replies | 19412 view(s)

01-17-2023, 01:29 PM

June7 replied to a thread how to list 10 sufficient employee in sql ? in Microsoft SQL Server 2008

lower salary AND more cars? Which has priority? Sort by number of cars then by salary and limit to 10? Build an aggregate query that counts cars...

6 replies | 17696 view(s)

01-17-2023, 02:04 AM

johnsonmillie53 replied to a thread How to create instance after installing data server client in IBM DB2

Creating an instance after installing the data server client depends on the specific database management system (DBMS) you are using. SQL...

1 replies | 2302 view(s)

01-17-2023, 01:57 AM

johnsonmillie53 replied to a thread SQL Results without Spaces between columns in IBM DB2

To remove spaces between columns in the results of a SQL query, you can use the CONCAT function to concatenate the values of each column together...

1 replies | 2702 view(s)

01-17-2023, 01:49 AM

johnsonmillie53 replied to a thread how to list 10 sufficient employee in sql ? in Microsoft SQL Server 2008

To list the top 10 employees in SQL, you can use a SELECT statement with an ORDER BY clause and a LIMIT clause. The ORDER BY clause is used to sort...

6 replies | 17696 view(s)

01-17-2023, 01:37 AM

johnsonmillie53 replied to a thread onstat -g ses returns "Changing data structure forced command termination" in Informix

The error message "Changing data structure forced command termination" is typically encountered when you are using the onstat command to view session...

3 replies | 178 view(s)

01-17-2023, 01:33 AM

johnsonmillie53 replied to a thread How to delete records from table trade code that No have parent code value and parent in Microsoft SQL Server 2008

You can use a DELETE statement with a subquery. The subquery would be used to select the records that do not have a parent code value and parent, and...

2 replies | 19726 view(s)

01-17-2023, 01:25 AM

johnsonmillie53 replied to a thread How to check blocking queries in SQL Server Ask? in Microsoft SQL Server 2008

In SQL Server, you can use the system function "sp_who2" to check for currently running or blocked queries. This function returns information about...

2 replies | 13018 view(s)

01-13-2023, 03:53 AM

Steve R Jones replied to a thread onstat -g ses returns "Changing data structure forced command termination" in Informix

Thank You.

3 replies | 178 view(s)

01-13-2023, 12:59 AM

tuccero replied to a thread onstat -g ses returns "Changing data structure forced command termination" in Informix

I was informed by IBM community group that this is a known bug on Informix version 11.40FC9. I am posting this here for anyone who might experience...

3 replies | 178 view(s)

01-11-2023, 10:16 AM

tuccero started a thread onstat -g ses returns "Changing data structure forced command termination" in Informix

Hello, I installed a new informix server version IBM Informix Dynamic Server Version 14.10.FC9 running on a RedHat Enterprise Linux 8.4 VM...

3 replies | 178 view(s)