I am trying to execute a user defind function in DS through query as given below. When I click on view data I am able to see it but when I execute tha job it is aborting by giving message as invalid character.
My query is
Select User_defN_Func(1) from Dual;
Please let me know the solution to this
Error whil executing userdefined function in DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Error whil executing userdefined function in DS
Forget doing that... you're trying to mix oracle and DataStage syntax. It won't work.
In theory there's no difference between theory and practice. In practice there is.
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Error whil executing userdefined function in DS
It worked. It was my mistake. I gave a ; at the end of the query. Thats why it was giving an error as invalid character. Now its working fine.ogmios wrote:Forget doing that... you're trying to mix oracle and DataStage syntax. It won't work.
Thnx...
SMB
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Error whil executing userdefined function in DS
It worked. It was my mistake. I gave a ; at the end of the query. Thats why it was giving an error as invalid character. Now its working fine.ogmios wrote:Forget doing that... you're trying to mix oracle and DataStage syntax. It won't work.
Thnx...
SMB