View in SQL 2000
How to create view with parameter? Thanks and regards.

Answer Question   |  June 22, 2011  9:12 AM
SQL 2000, SQL Parameters, SQL Server, SQL Server 2000, SQL View

How can I see SQL VIEW inside ?
Dear Friend, I see the VIEWS on AS/400 as logical file,but I don’t know wit which SQL it is created. How can I see the SQL Sentence of this VIEW ?

Answer Question   |  November 9, 2010  1:32 PM
AS/400 SQL View, Logical Files, SQL View, SQLVIEW AS/400

Join Logical files and SQL views
I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical [...]

Answer Question   |  July 30, 2009  5:11 PM
DDS, Join Logical file, Logical Files, SQL DDL, SQL View

Refresh a SQL View in ILE
I have created a view and am using in an ILE module. I have updated one of the files that the view is built with. How do I refresh the View to see this record the next time I run the SQL view? Is there a CREATE OR REPLACE VIEW in RPGILE? Thank you.

Answer Question   |  April 7, 2009  5:05 PM
AS/400 SQL View, RPGILE, SQL View