New member creation through CL

Supriyob2

165 pts.

Tags:

AS/400 administration

AS/400 Control Language

I need to create members dynamicaly once my file size is full through Cl.How can i do this?How can i set range to this new members?

Asked: October 31, 2008 6:12 AM Last updated: November 3, 2008 1:13 PM

Answer Wiki

Last updated: November 1, 2008 2:29 PM GMT

Gilly40023,730 pts.
History
Contributors
- Ordered by most recent
- Gilly40023,730 pts.

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

Hi,

You can use ADDPFM to create a new member (you’ll have to give it a unique name). You’ll need to make sure that your MAXMBRS is set high enough for the number of members – you can use CHGPF to change the MAXMBRS.

To access your new member, you’ll need to use OVRDBF.

Regards,

Martin Gilbert.

Discuss This Question: 3 Replies

philpl1jb Oct 31, 2008 1:09 PM GMT

Do you really want to add the member -- you could also increase the file size. Retrieve Member Description (RTVMBRD) can be used to get the number of records

54,090 pointsBadges:

report
Supriyob2 Nov 3, 2008 6:35 AM GMT

My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ....so on..hence this small files will only contain records with size upto 3mb. Can you provide me with a code in cobol or rpg.

165 pointsBadges:

report
Gilly400 Nov 3, 2008 1:13 PM GMT

Hi, You can calculate the approximate size of your member using the record length x number of records. So if you take 3Mb and divide it by your record length, you get the approximate number of records in a 3Mb file member. Using this number you could use CPYF (with start and end record numbers) to copy your large file to separate members of approximately 3Mb each. I've done something similar in the past to get around the 65K number of records limit in excel. Regards, Martin Gilbert.

23,730 pointsBadges:

report