Issue with universe query
Posted: Thu Apr 18, 2013 8:00 am
Hi
I have run the below query and it runs perfectly fine with no errors
In the above DUMMY1 column is a dump of whole record from DS_JOBOBJECTS and this time I wanted a dump of record from DS_JOBS and ran the below query but it fails with error shown :
The only difference in above two queries is the derivation for DUMMY1. Not sure why the second one fails to run.
Thanks
I have run the below query and it runs perfectly fine with no errors
Code: Select all
SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'ABC',1) = 0 THEN '0' ELSE 'FOUND' " AS REC, EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'ABC',1) = 0 THEN 0 ELSE DCOUNT(@RECORD[1, INDEX( @RECORD,'ABC',1)], @FM)" AS FOUND FMT '5R',EVAL DS_JOBOBJECTS."CONVERT(\@FM:@SM:@VM:@TM\,'$#!',@RECORD)" AS DUMMY1 FMT '1000L' FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND FOUND > 0 AND REC<>'0' AND DS_JOBS.CATEGORY LIKE 'ABC' GROUP BY JOB_NAME, DS_JOBS.CATEGORY, OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, REC,FOUND,DUMMY1 ORDER BY JOB_NAME,DS_JOBOBJECTS.OLETYPE, DS_JOBS.CATEGORY,DUMMY1;Code: Select all
>SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'ABC',1) = 0 THEN '0' ELSE 'FOUND' " AS REC, EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'ABC',1) = 0 THEN 0 ELSE DCOUNT(@RECORD[1, INDEX( @RECORD,'ABC',1)], @FM)" AS FOUND FMT '5R',EVAL DS_JOBS."CONVERT(\@FM:@SM:@VM:@TM\,'$#!',@RECORD)" AS DUMMY1 FMT '1000L' FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND FOUND > 0 AND REC<>'0' AND DS_JOBS.CATEGORY LIKE 'ABC' GROUP BY JOB_NAME, DS_JOBS.CATEGORY, OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, REC,FOUND,DUMMY1 ORDER BY JOB_NAME,DS_JOBOBJECTS.OLETYPE, DS_JOBS.CATEGORY,DUMMY1;
IF INDEX ( @RECORD , ABC , 1 ) = 0 THEN 0 ELSE FOUND
IF INDEX ( @RECORD , ABC , 1 ) = 0 THEN 0 ELSE DCOUNT ( @RECORD [ 1 , INDEX ( @RECORD , ABC , 1 ) ] , ( char ( 254 ) ) )
CONVERT ( @FM:@SM:@VM:@TM , $#! , @RECORD )
DataStage/SQL: Internal problem with ALIAS, submit GTAR.
>Thanks
