I am trying to run a query thru JCL using the DSNTIAUL option in jcl.
My query is running fine except that a char 'æ' is getting appended in the begining . Please let me know how can I eliminate this .

My query looks like this :
Select 'PAVAN'||empn0||'|'||deptno||'|'
from emp,dept
where emp_status='ACTIVE'

the o/p is as follows :

æPAVAN1234|SALES|

How do I eliminate 'æ' from my o/p?

The JCL I am using is

//STEP10 EXEC PGM=IKJEFT01,
// DYNAMNBR=20,
// COND=(0,NE)
//*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) PARMS('SQL')
/* END OF INPUT
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//*
//SYSREC00 DD DSN=pavan.DUMP.Output,
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(CYL,(200,50),RLSE),
// DCB=(RECFM=FB,LRECL=400,BLKSIZE=0)
//SYSPUNCH DD DUMMY
//*
//SYSIN DD *
above query
/*

Thanks in advance!!
Pavan.

your SELECT results in a column of type VARCHAR. That means, a two-byte length indicator preceeds your result.

Try this:

Select CAST( 'PAVAN'||empn0||'|'||deptno||'|' AS CHAR(xxx) )
from emp,dept
where emp_status='ACTIVE'

where xxx is the length of your result.

by the way:
you use an inner join, but there is no join criteria in your where-clause.