Nutangujar 
750 pts. | Sep 29 2009 7:10PM GMT
I tried long name and it works perfectly on my system
i hope it works the same at client site too..
Q:
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:
Sep 28 2009 9:29 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
