Skip to Content

How to execute BTEQ script in BODS and using optimized sql from BODS in BTEQ?

Hi Experts,

Could you please help me, is there any way we can use BODS optimized SQL in BTEQ and is there any we can call BTEQ from BODS?

Thanks in advance!

Regards,

Faisal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 16, 2016 at 10:38 AM

    Hi Faisal,

    BTEQ is just a SQL Tool. The version of the Teradata DB you are trying to run the scripts on is important and if it is supported in your version of BODS, you can make use of the SQL script. I imagine the scripts are big enough not to worth the trouble of redevelopment using the native BODS SQL transforms logic.

    regards,

    Bogdan

    Add comment
    10|10000 characters needed characters exceeded