column name in table was auto-renamed

[testingasfourhundred]

Hi,

I have compiled my CL reading a table.
When I check the spool I saw that these

QUALIFIED FILE NAME - QTEMP/AFFE23
RECORD FORMAT NAME - AFFE23

CL VARIABLE TYPE LENGTH PRECISION TEXT
&AFFE200001 *CHAR 10
&AFFE200002 *CHAR 6

Then when I tried recompiling the same CL in another screen.
This is what I saw in the spool
QUALIFIED FILE NAME - QTEMP/AFFE23
RECORD FORMAT NAME - AFFE23

CL VARIABLE TYPE LENGTH PRECISION TEXT
&AFFEOBJECT *CHAR 10
&AFFEOTYPE *CHAR 6

I'm not sure what I have done but whenever I recompile now, I cannot recreate the first scenario.
Appreciate it if someone can explain. Thanks!

[B.Hauser]

Each job has its own QTEMP. Are you sure the AFFE23 tables are created in the same way in both jobs?
It seems to me that in the first job the column names arre longer than 10 characters, so 10 character digit names are created consisting of the first 5 characters or the long name and adding a 5 digit counter.
In the second job the column names AFFEOBJECT and AFFEOTYPE are maximum 10 characters.

Birgitta

[testingasfourhundred]

I see, I didn't notice that the variable got changed. Let me try that. Thanks for your reply.