Hi, someone tel me the following which i can use in place of oracle's.
1. what can i use in place of sysdate.
2. how can i perform data type conversion in db2.
3. what is the option of acheiving cursor for loop in db2.
4. how can insert the error message into a table when an error
occured while calling the procedure corrosponding an sqlcode.
5. can i convert a varchar type value to date type (i.e. 'dd/mm/yy')
and in integer vaue.
i.e. we can perform in oracle as
datavalue varchar(100);
and we perform the following function to convert thr data type such as
1. to_date(datavalue,'DD/MM/YYYY')
2. to_number(datavalue).

If any one has the solution for my problems please mail me soon.
I am very thankfull for that.
By by
Jitendr Kumar
jitu1105@rediffmail.com

1) assyming sysdate is the current date from the server, in DB2 use: CURRENT DATE (also CURRENT TIME and CURRENT TIMESTAMP)

2) try using CAST

3) not sure what you are asking, Try FETCH

4) do not know what you are asking

5) yes see DATE and INTEGER functions, There is also a TO_DATE function

Andy