I am using a query with decode function which returns N or Y. I need to read it in a variable and then proceed.. I am not able to read it. format shows A1V.

How can I read that value?
Please reply..its urgent
Thanks a lot in advance !

This message has been edited. Last edited by: <Emily McAllister>,

This doesn't work?

-READFILE SQLOUT
END
-SET &FIELD = &FIELD ;

quote:

posted December 23, 2015 12:57 PM Hide Post
This doesn't work?


-READFILE SQLOUT
END
-SET &FIELD = &FIELD ;

This is howI am trying now..

TABLE FILE SQLOUT
PRINT
*
ON TABLE HOLD AS RECHLD FORMAT ALPHA
END
-RUN
-READ RECHLD &RECCNT.A1.
-TYPE &RECCNT
-EXIT

Yours gave some error..

Here's a simple example I just came up with:

-SET &ECHO='ALL';
ENGINE SQLMSS SET DEFAULT_CONNECTION MetricDatamart
SQL SQLMSS
SELECT 'Y' AS VALUE;
TABLE
ON TABLE HOLD AS SQLOUT
END
-RUN

-READFILE SQLOUT
END

-SET &FIELD = &VALUE;
-TYPE &FIELD

In your SQL CAST the field

 

       CAST(FIELD AS CHAR(1))                    AS FIELD ,
 

Thank you so much both of you..It worked.

quote:

-READFILE SQLOUT

This is one of the reasons that we ask for the version that folks are working with.

From Bharathi's signature, we can see that it is 7.6. -READFILE wasn't available in that release which is why it didn't work for them.


Happy holidays

T