Datastage &PH& file contents
Posted: Thu Feb 08, 2001 4:07 am
Hi All,
We have a number of jobs which, basically of two types which give as a sample the following output in &PH& respectively, has anyone else had these errors or have an idea as to why they are happening.
TIA
DSD.RUN_43960_12093
0001 DataStage Job 260 Phantom 12858
0002 RetrieVe: syntax error. Unexpected symbol. Token was "@ID".
0003 Scanned command was SELECT RT_LOG260 WITH @ID < AND @ID
0004 DataStage Phantom Finished.
Obviously there is a problem with the retrieve SELECT statement (NOT SQL), my question is why?
DSD.RUN_55632_12093
0001 DataStage Job 110 Phantom 19864
0002 Attempted READ of record ID larger than file/table maximum
0003 record ID size of 255 characters.
0004 Attempted READ of record ID larger than file/table maximum
0005 record ID size of 255 characters.
0006 Attempted READ of record ID larger than file/table maximum
0007 record ID size of 255 characters.
0008 Attempted READ of record ID larger than file/table maximum
This job is a batch job which calls a function we have written to set up the environment variables for the dependent jobs.
Phil Walker
DataStage Consultant
Project Clarity
Carter Holt Harvey Forests
DDI: 96094
MOD: 025 835 197
EMAIL: phil.walker@chh.co.nz
We have a number of jobs which, basically of two types which give as a sample the following output in &PH& respectively, has anyone else had these errors or have an idea as to why they are happening.
TIA
DSD.RUN_43960_12093
0001 DataStage Job 260 Phantom 12858
0002 RetrieVe: syntax error. Unexpected symbol. Token was "@ID".
0003 Scanned command was SELECT RT_LOG260 WITH @ID < AND @ID
0004 DataStage Phantom Finished.
Obviously there is a problem with the retrieve SELECT statement (NOT SQL), my question is why?
DSD.RUN_55632_12093
0001 DataStage Job 110 Phantom 19864
0002 Attempted READ of record ID larger than file/table maximum
0003 record ID size of 255 characters.
0004 Attempted READ of record ID larger than file/table maximum
0005 record ID size of 255 characters.
0006 Attempted READ of record ID larger than file/table maximum
0007 record ID size of 255 characters.
0008 Attempted READ of record ID larger than file/table maximum
This job is a batch job which calls a function we have written to set up the environment variables for the dependent jobs.
Phil Walker
DataStage Consultant
Project Clarity
Carter Holt Harvey Forests
DDI: 96094
MOD: 025 835 197
EMAIL: phil.walker@chh.co.nz