Forum: SQL

Hello, I have a handful of SQL queries that I have been running nearly every work day to monitor a few projects on hand. Each result then gets...

OK. I'll try to summarize this clearly. I'm completely stumped at what I did wrong or what factor I'm not aware of missing. I'm working on an...

Hello, I hit my head against this all yesterday, but have not found a clear explanation or way around this error. I'm trying to run a SQL...

Article at Practical SQL: Three Ways to JOIN Our tables tend to have unique column names (old school!) so I wasn't aware of the disappearing...

Hello, I'd like to "re-Declare" a SQL cursor in my SQLRPGLE program. Of course, the compiler won't let me do this, since it only allows a cursor...

** This thread discusses the article: Practical SQL: Calling RPG from SQL, Part II ** ** This thread discusses the Content article: Practical SQL:...

** This thread discusses the article: An Open-Source DB2 SQL Graphical Tool That You Can Use for All Your Databases ** ** This thread discusses the...

Got a new project working to receive a XML from a vendor that needed to parse into 2 databases. I tried using the new feature (Annotation...

I am building a subfile on an SQL loop that is based on selection criteria from an outer SQL loop. It works. However I'm taking one heck of a...

** This thread discusses the article: Practical SQL: SQLCOD and SQLSTT ** ** This thread discusses the Content article: Practical SQL: SQLCOD and...

Group, I have two files - file#1 is member of a PF (FILE A) keyed by donor#, (an alias has been created to point to the specified member) file#...

Tom, you are 100% right. Most of us converts like the dynamic selection, the dynamic sort, and the better joins we get from SQL over old fashioned...

Group, When running the sql command: ALTER TABLE mylib/mytable DROP COLUMN mycolumn, I continually receive the SQL Error SQL0952. Everything that...

** This thread discusses the article: Use SQL to Export and Delimit Files on the IBM i ** ** This thread discusses the Content article: Use SQL to...

I am currently do SQL in university in 1 of my modules. Just wondered if somebody had a good knowledge of the programme, and could help me a...

I enjoyed the article "Practical SQL: Don't Be Afraid of Recusrion", however I'm a bit puzzled. According to the V5R3 DB2 UDB for iSeries SQL...

Please Help! I wrote an embede SQL in free RPG. I use prepare statement. When i run it under my id, it works perfectly. Then I move this program...

The word "recursion" is a little scary. The technique actually being described (the WITH part) is called a "common-table-expression" and it can be...

** This thread discusses the article: Practical SQL: Dynamic Selection Criteria ** ** This thread discusses the Content article: Practical SQL:...