SQL-Using count and inner join in a single query
Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I’m using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I’m using. [...]

Answer Question   |  July 27, 2010  11:13 AM
SQL 2005, SQL 2005 Database, SQL generated files, SQL Query, SQL Server, SQL Server 2005

Documenting column in SQL table in QADBIFLD (AS400)
When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this column. Now my question: How can text-documenation [...]

Answer Question   |  March 2, 2010  10:12 AM
AS/400 SQL, Documentation, QADBIFLD, SQL, SQL generated files, SQL tables

File Level Identifiers
If we save and restore SQL generated files which were created under an old OS/400 system software will the Format Level Identifier be changed and how does this affect the file?

Answer Question   |  July 12, 2011  2:08 PM
File Level Identifier, OS/400, SQL generated files