Logical file changes and SQL

25 pts.
Tags:
Logical Files
SQL
SQL statements
I need to make a change to a logical file. I have a program that is accessing this logical via an SQL statement. If I recompile the logical, do I have to recompile the program as well? (the file is not listed in the 'F' specs, it's only referenced in the SQL statement.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

The rule of thumb for me is that if you use select * into a data structure. or use * to denote all fields into a data structure, then you’ll need to decide:

– If there are more or less columns (fields) than before, you will need to recompile.
– If the field list remains the same and in the same order, you probably won’t.
For this reason, it’s good practice to name the columns you want rather than fetching everything.
It does depend on what you’re changing. If it’s just selection criteria in an SQL view, then you probably don’t need to recompile.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • NJSTATEBOB
    Thanks for your response. What is actually changing is within the logical (which is classified as 'UNIQUE') the field that is being specified for the UNIQUE, needs to have a value added to it.

    For example:

     

                                        UNIQUE       
    R BMASTR                 PFILE(BMASTER)
                                             
    K BILL#                                
    K BILLCLS                              

    S BILLCLS                 VALUES(5 6 70 88 99)

    In this example, I need to add the number 20 to the 'VALUES'

    THANKS!!!

    25 pointsBadges:
    report
  • philpl1jb
    No .. that will affect which rows are visible not the structure of a row.
    54,090 pointsBadges:
    report
  • NJSTATEBOB
    Thank You for your help!
    25 pointsBadges:
    report

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.

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

Following

Share this item with your network: