Currently I am working on a project like migrating from Sybase to Teradata.While converting strored procs to teradata I came across few new functionalities in SYBASE.I did google in many places but no use,So finally I am posting the functionalities here as follows
In most of the procedures they have used below functions so please provide solution in teradata
1)message STRING('CREATING TOP 25 TEMP_TOPSHIPPERS : ',now()) type info to client;
2)message ' ' to console;
3)set temporary option row_count = 25;
4)LOCATE (I think its like InString functionality please correct me if I am wrong)
Thanks in advance.
Please help me out its pretty urgent and impacting our deliverables..I tried almost all blogs and help centers but i didn't get the solution.
Your response will really help to me.