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
Datastage &PH& file contents
Change MAXKEYSIZE in uvconfig from 255 to 768.
Looks like the error selecting based on long @ID values (generally caused by tables with many primary key columns) has cause a sunsequent SELECT statement to be mis-generated. Thats my guess anyway. Have you opened a support call? (Im in Singapore and cant see the support
mail/database.)
-----Original Message-----
From: Walker, Phil (Forests Manukau) [mailto:Phil.Walker@chh.co.nz]
Sent: Thursday, 08 February 2001 12:07
To: informix-datastage@oliver.com
Subject: Datastage &PH& file contents
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
Looks like the error selecting based on long @ID values (generally caused by tables with many primary key columns) has cause a sunsequent SELECT statement to be mis-generated. Thats my guess anyway. Have you opened a support call? (Im in Singapore and cant see the support
mail/database.)
-----Original Message-----
From: Walker, Phil (Forests Manukau) [mailto:Phil.Walker@chh.co.nz]
Sent: Thursday, 08 February 2001 12:07
To: informix-datastage@oliver.com
Subject: Datastage &PH& file contents
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