Embedded SQL
In SQL RPGLE program, I declare a cursor using a view..
The view has name Emp_Pat_Dept_Data(EMPdata)
the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field names in the actual PF
Thanks,
NG
Software/Hardware used:
AS400
The view has name Emp_Pat_Dept_Data(EMPdata)
the empdata is the AS400 name. In my cursor def which name I should use. Also for the fields referenced do I need to use the renamed field names in the view definition or I can use the field names in the actual PF
Thanks,
NG
Software/Hardware used:
AS400
ASKED:
September 28, 2009 9:29 PM
UPDATED:
September 29, 2009 7:20 PM
Answer Wiki:
Emp_Pat_Dept_Data is the name created with the create view, so you should be able to use it in SQL commands.
If you use that view you will only see the fields in the view's field list
The fields will have the field names assigned in the view.
Phil
===============
Well, I don't know why it wouldn't support the long name.
Doesn't seem that hard for you to try it...or google it...becoming a bit too dependent.
Let us know the answer.
Phil
=============
cool-thanks for the feedback.
To see all answers submitted to the Answer Wiki: View Answer History.
will SQL support view names longer more than 10 char
I tried long name and it works perfectly on my system
i hope it works the same at client site too..