Hi,
I want to execute a Teradata parameterized macro in a DataStage job.
The job will have one input sequential file stage from where I will get some values and using them as parameters I have to execute a macro in the target Teradata stage.
How to achieve this?
How to execute a Teradata Macro in a DS job?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 34
- Joined: Fri May 16, 2008 6:24 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How do you execute Teradata macros in SQL (or in BTEQ)? You use exactly the same techniques - embedding them in SQL statements typically - if using them from DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 34
- Joined: Fri May 16, 2008 6:24 am
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am
-
- Premium Member
- Posts: 34
- Joined: Fri May 16, 2008 6:24 am
resolved
nishadkapadia wrote:What specific problem you are facing, since if using Teradata API stage and the normal method of mentioning 'USING <<column_name>> , followed by exec <<macro_name>> ( :column_name ).
Do please post any specific message / error you are facing.
It was my mistake, It got resolved when I mentioned the datatype in the u/d sql. Thanks Nishad.