MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » January 2013

Re: QCLSRC with PF38-SRC attribute



fixed

On 24 Jan 2013 09:44, Monnier, Gary wrote:
So you've already converted all your source code and only want to
change the file attributes of QCLSRC and QDDSSRC from PF38-SRC to
PF-SRC?

I guess I don't see any major issue if this is all you want to do.

Simply create QCLSRC and QDDSSRC in a different library (without the
PF-38-SRC attribute), copy your source to the new files, delete the
PF38-SRC files and move the new QCLSRC and QDDSSRC files back to the
original library. It may take you an hour at most.

CPYF FROMFILE(yourS38lib/QCLSRC) TOFILE(yournewlib/QCLSRC)
FROMMBR(*ALL) TOMBR(*FROMMBR) MBROPT(*REPLACE) FMTOPT(*NONE)

<<SNIP>>

FWiW:

Using save\restore as described by Mark is ideal; even maintaining the Member Level Identifiers:
http://archive.midrange.com/midrange-l/201301/msg01186.html

However if one were to use a _copy_ feature instead, then...

The CPYSRCF command has a Source Change Date (SRCCHGDATE) parameter which may make that command preferable over CPYF [for the ability to ask for the preferred outcome to maintain that value]:

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/dbp/rbafoucsrf.htm
"Copying to and from source files using the Copy Source File (CPYSRCF) command

The Copy Source File (CPYSRCF) command is designed to operate with database source files. Although it is similar in function to the Copy File (CPYF) command, the CPYSRCF command provides defaults that are normally used for copying a source file.
...
Source change date (SRCCHGDATE)

Specifies, for new members added to the to-file, or if MBROPT(*REPLACE) was specified, whether the 'Last source update date/time' will be a new date/time, or copied from the 'Last source update date/time' of the member in the from-file.

*FROMMBR
The 'Last source update date/time' of the new member in the to-file, or if MBROPT(*REPLACE) was specified, will be the same as the member being copied.

*NEW
The 'Last source update date/time' of the new member in the to-file, or if MBROPT(*REPLACE) is specified, will be a new date/time.
..."

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/cl/cpysrcf.htm
_i Copy Source File (CPYSRCF) i_
"The Copy Source File (CPYSRCF) command copies a database source file or DDM file to a source physical file or DDM file and converts the character data from the from-file CCSID to the to-file CCSID.
...
This command provides similar support as the Copy File (CPYF) command. Note that the default for the MBROPT parameter is *REPLACE (unlike other copy commands), which clears existing records in the receiving member of the to-file before replacing them with records copied from the from-file. Also, the default for the TOMBR parameter is *FROMMBR, which causes from-file members to be copied to like-named to-file members.
..."

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/dbp/rbafosrccpy.htm
_i Copying source file data i_
"You can use the Copy Source File (CPYSRCF) and Copy File (CPYF) commands to write data to and from source file members.

When you are copying from a database source file to another database source file that has an insert trigger associated with it, the trigger program is called for each record copied.

* Copying to and from source files using the Copy Source File (CPYSRCF) command
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/dbp/rbafoucsrf.htm

The Copy Source File (CPYSRCF) command is designed to operate with database source files. Although it is similar in function to the Copy File (CPYF) command, the CPYSRCF command provides defaults that are normally used for copying a source file.

* Copying to and from source files using the Copy File (CPYF) command
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/dbp/rbafocpyfi.htm

The Copy File (CPYF) command provides additional functions over the Copy Source File (CPYSRCF) command for copying to and from source files.

* Source sequence numbers used in copies
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/dbp/rbafossqnb.htm

When you copy to a database source file, you can use the SRCOPT parameter to update sequence numbers and initialize dates to zeros."






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact