Embedded SQL

895 pts.
Tags:
Embedded SQL
SQLRPGLE
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Nutangujar
    will SQL support view names longer more than 10 char
    895 pointsBadges:
    report
  • Nutangujar
    I tried long name and it works perfectly on my system i hope it works the same at client site too..
    895 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following