i am getting the following fatal error
Job design
lookup seq file with Db2 database 1 and put ino target table
Db2 database1
.
.
seq file......................lkup......................xfm..............>db2 database
The follwing error coming from reference Db2 database 1
db2_Job_Def_Group,0: DB2 reported: SQLSTATE = 42S22: Native Error Code = -206: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "DEFN_NUM" is not valid in the context where it is used. SQLSTATE=42703 [:0]
i have used the following query
#def_num # and group_num# and #psdaDB2_LUW_EDW.pvDBEnvironment# and #psdafilelocation# are job parametersselect 1 as batchdummy,max(job_batch_gk) AS JOB_BATCH_GK_REF from AUDIT#psdaDB2_LUW_EDW.pvDBEnvironment#.JOB_BATCH where job_defn_num=#defn_num# and job_group_num=#group_num#
I just copy the same job with all same parameters just seq file is different
i don't know why its showing where as already existing job runs fine .