IBM Support

CREATE ALIAS with *LAST member

News


Abstract

The CREATE ALIAS statement can be used with a member name of *LAST. This alias refers to the most recently created member of a file at the time an SQL statement references it.

Content


See the SQL Reference for details:
 

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;7.5.0;and future releases"}]

Document Information

Modified date:
07 May 2024

UID

ibm17148991