OVRDBF on iSeries used in a CL program

750 pts.
Tags:
CL Program
iSeries
OVRDBF
SQL
I am using an SQL statement to insert into a file. I am doing some sub-stringing on a record then inserting into another file. I am getting a LVLCHK error on the output file. How can I use OVRDBF in my CL to insert to my output file? My file PROFILE has the data and PROFILE2 is my output file and the one getting the LVLCHK error.


Software/Hardware used:
V7R1M0
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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.
  • TheRealRaven
    You're asking how to do something that shouldn't be done and almost certainly doesn't need to be done. Far better would be to correct the problem. You should be able to structure a SQL statement that doesn't run into a LVLCHK.

    If we know the file structure for PROFILE2 and can see the SQL, we can probably work out a correction.
    34,485 pointsBadges:
    report
  • ToddN2000
    I have never run into a LVLCHK with SQL. It would help if we could see your SQL code to better understand what you are trying to accomplish. Also check the file you are trying to do the insert to. If this is a DDS defined file, are there any select/omits being used, unique keys or other thing you may not be considering. If you are trying to insert into a LF, are the fields defined in this file?
    131,645 pointsBadges:
    report
  • GregManzo
    SQL is late binding, therefore not capable of getting LVLCHK itself, but can cause problems if it re-creates a file. Which program is getting the LVLCHK? Is in an RPG pgm trying to read the output?
    2,950 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: