PDA

View Full Version : Auto Code - SQL created files


rodiusd
04-10-2010, 05:13 AM
When using AutoCode to create an program on a file who was created by SQL we are getting the follwoing compiler error:

001200 fMEMBERS uf a e k disk
001300
001400 ** internal variables
*RNF2121 30 001200 Record format MEMBERS in file MEMBERS already defined;
record format is ignored.
*RNF2109 40 001200 All Record Formats for externally-described file MEMBERS
ignored or dropped due to error; file ignored

This is normal behavior because the SQl create is using the same name for the record as for the file.

We dont want to use ALTER on these files because other pgm's are using them.

Is there a way around within valence without changing the table(file),

Could this be taken up as an FeatureRequest to the AutoCode option.

sean.lanktree
04-10-2010, 09:44 AM
Thanks, I added this to our internal to-do list. For now, unless you want to make the changes to program VVACFMNT (this is what produces the HTML/RPG programs from autocode), simply apply the rename keyword with your file (in your generated source code) and replace any write/delete/update with your newly renamed record format.

rodiusd
04-10-2010, 09:59 AM
Thanks could do that, but it seems something that should be include in the AutoCode so don't have to go to the generated code.

Also i propose to think about to include an option "Replace Y/N" beside the objects name to be created in the AutoCode.