Re: Determine SQL or System naming?

You might as well say that RLA should go away now that the system has SQL access. One benefit of how database works on IBM i is the dual access capability, IMO.

Every flavor of SQL has extensions. And *SYS is like that.

Now as to dialect - SQL on IBM i may be the most compliant flavor of SQL as concerns the published SQL standards. And they are not going on a "feature" chase for non-compliant features. Again, every flavor of SQL has its own extensions.

My question on something like select without from is, does that comply with the ANSI SQL standard? Or is it a variant from only certain RDBMS'?

Regards
Vern

On 3/16/2020 3:00 PM, D*B wrote:

...
read postings carefully! Using "/" as qualifier from SQL naming is throwing an error and using "." as qualifier is working for SQL and the non SQL mode!!!
Using naming *SYS is in contradiction to the spirit of SQL!!! It's some sort of joke having a true database, supporting referential integrity and searching tables by libl (think about!!!).

The SQL dialect of db2/400 doesn't allow select without from, other dialects would allow select current_date, just returning current_date, db2 enforces to use a from clause, if the table, you are using would have more than one record, you would get more than 1 result. So DB" introduced a table, existing in all installations, having one and only one record, ensured by a constraint and read only acces - this is sysibm.sysdummy1.

D*B