Issue with universe query

[zulfi123786]

Hi

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;

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 :

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.
>

The only difference in above two queries is the derivation for DUMMY1. Not sure why the second one fails to run.

Thanks

[ray.wurlod]

GTAR = general technical assistance request; it means contact your official support provider.

[zulfi123786]

What gets me confused is the select statements are the same except

First query:

Code: Select all

EVAL DS_JOBOBJECTS."CONVERT(\@FM:@SM:@VM:@TM\,'$#!',@RECORD)" AS DUMMY1 FMT '1000L'

Second Query:

Code: Select all

EVAL DS_JOBS."CONVERT(\@FM:@SM:@VM:@TM\,'$#!',@RECORD)" AS DUMMY1 FMT '1000L'  

First one runs but second fails