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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
then you get a list of all ibraries where f551201z is located, maybe you mistyped something