Link to home
Start Free TrialLog in
Avatar of matrix0511
matrix0511

asked on

Where to Find Table in Backup LIB on AS400?

I executed the following tasks below to copy a table from one LIB (CRPDTA) to a backup LIB (TBLBACKUP).

However, after running this I would now like to verify the records in the table in the backup LIB to make sure everything went ok. But it fails when I try to run the table count.


Here is the tasks I took to backup/copy the table:

Save data in files before generating tables, if there are table generation requests.
- Using OWPKGBLD menu on OSK3, run option 25.
- Enter the following information:
  From file  . . . . . . . . . . . > F551201Z        
    Library  . . . . . . . . . . .     CRPDTA
  To file  . . . . . . . . . . . .      F551201Z
    Library  . . . . . . . . . . .     TBLBACKUP
  From member  . . . . . . . . . .   *FIRST        
  To member or label . . . . . . .   *FIRST        
  Replace or add records . . . . .   *NONE        
  Create file  . . . . . . . . . .   *YES                
  Print format . . . . . . . . . .   *CHAR

It said the copy was successful.

But when I try to check the records by running a record count command I get this:

                              Enter SQL Statements      
                                                         
 Type SQL statement, press Enter.                        
        select count(*) from crpdta/f551201z            
      SELECT statement run complete.                    
    >                                                   
                                                         
         select count(*) from TBLBACKUP/f551201z        
      F551201Z in TBLBACKUP type *FILE not found.        
    >                                                   
                                                         
         select count(*) from tblbackup/f551201z        
      F551201Z in TBLBACKUP type *FILE not found.
SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Try WRKOBJ *all/f551201z  
then you get a list of all ibraries where f551201z    is located, maybe you mistyped something
Avatar of matrix0511
matrix0511

ASKER

Thanks guys. I won't be able to connect back to this client system until later this week. I'll try your suggestions then.

Thanks!
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial