2 questions about save-list & data export
- caijc
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
11 years 8 months ago #13674
by caijc
2 questions about save-list & data export was created by caijc
Hi,All, 2 questions from new guy, please help me and thanks any way:
Q1.If I just want to list 2 fields of a file, such as F.VERSION, I can use: SELECT F.VERSION and LIST F.VERSION BUSINESS.DAY , but the result can only be shown on screen. How to save the result to a file? I used SAVE-LIST, but only @ID is saved to file, I want both @ID and BUSINESS.DAY are saved to the file.
Q2.Is Dl.DEFINE & BCON the only way to export & restore data? When I just need to save one record in F.VERSION for backup and restore later, must I generate a package? Is there any other way to achieve this more easily?
Q1.If I just want to list 2 fields of a file, such as F.VERSION, I can use: SELECT F.VERSION and LIST F.VERSION BUSINESS.DAY , but the result can only be shown on screen. How to save the result to a file? I used SAVE-LIST, but only @ID is saved to file, I want both @ID and BUSINESS.DAY are saved to the file.
Q2.Is Dl.DEFINE & BCON the only way to export & restore data? When I just need to save one record in F.VERSION for backup and restore later, must I generate a package? Is there any other way to achieve this more easily?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired
Less
More
- Posts: 2859
- Thank you received: 649
11 years 8 months ago #13675
by jpb
Replied by jpb on topic 2 questions about save-list & data export
A1 - SELECT F.VERSION WITH ... SAVING EVAL"@ID : ' ' : BUSINESS.DAY"
will do the job. In your &SAVEDLISTS& you will then find one line per record with the BUSINESS.DAY appended. If the field is a MV the value will be subvalued...
A2 - DL and BCON are the official ways.
Copying and restoring of individual records can be made more simple but a bit deeper system knowledge would be helpful...
You can e.g. just copy the record out of F.VERSION to a temporary directory and copy it back via F.VERSION$NAU with RECORD.STATUS = IHLD (whereas this is where the system knowledge is needed to have the record on IHLD).
Using OFS can also be a solution.
And not to mention the 3rd-party-products in the market that can help you.
will do the job. In your &SAVEDLISTS& you will then find one line per record with the BUSINESS.DAY appended. If the field is a MV the value will be subvalued...
A2 - DL and BCON are the official ways.
Copying and restoring of individual records can be made more simple but a bit deeper system knowledge would be helpful...
You can e.g. just copy the record out of F.VERSION to a temporary directory and copy it back via F.VERSION$NAU with RECORD.STATUS = IHLD (whereas this is where the system knowledge is needed to have the record on IHLD).
Using OFS can also be a solution.
And not to mention the 3rd-party-products in the market that can help you.
Please Log in or Create an account to join the conversation.
- caijc
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
11 years 8 months ago #13676
by caijc
Replied by caijc on topic 2 questions about save-list & data export
Hi, JPB, thanks for your reply. But for Q1,I use:SELECT F.VERSION SAVING EVAL"@ID : ' ' : BUSINESS.DAY", but in &SAVEDLISTS&, nothing is created. Is anything wrong?
For Q2, please make an explain on how to " copy the record out of F.VERSION to a temporary directory and copy it back via F.VERSION$NAU"?
For Q2, please make an explain on how to " copy the record out of F.VERSION to a temporary directory and copy it back via F.VERSION$NAU"?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired
Less
More
- Posts: 2859
- Thank you received: 649
11 years 8 months ago #13677
by jpb
Replied by jpb on topic 2 questions about save-list & data export
for 1 - did you do SAVE-LIST ... ?
for 2 - if you don't know what is meant I don't want to be responsilbe for blasting something at your site and I don't expain further. Make use of DL, it's fast and save.
for 2 - if you don't know what is meant I don't want to be responsilbe for blasting something at your site and I don't expain further. Make use of DL, it's fast and save.
The following user(s) said Thank You: armin
Please Log in or Create an account to join the conversation.
Time to create page: 0.086 seconds