1
  • Linking and unlinking SQL data

    How do link data from a SQL view?

    lsizemore5 pointsBadges:
  • View in SQL 2000

    How to create view with parameter? Thanks and regards.

    Pkaur65 pointsBadges:
  • 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 ?

    Vkarakuzu20 pointsBadges:
  • 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 files in...

    bogeybetsy560 pointsBadges:
  • 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.

    BisonHawk25 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following