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

Processing your response...

Discuss This Question: 3 &nbspReplies

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

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

WHen an SQL Object is created with a long name (over 10 characters), IBM generates a system name for it (Unless the SQL CREATE VIEW statement gave it an explicit system name). If IBM Generated it, your view would look something like "EMP_nnnnnn", where nnnnnn is a number sequence assigned at the time of creation. You can do the WRKOBJPDM command on the library where your view resides and filter to EMP* to see a list of objects that fit this naming convention.
If the name was explicitly assigned in the SQL, you will need to do one of the other options listed above to find the based on tables and the system name.

You can find the equivalent AS400 PF name in SYSTABLES.
For ex:
you can use below SQL query to find the equivalent AS400 PF name
SELECT SYSTEM_TABLE_NAME FROM SYSTABLES WHERE TABLE_NAME = 'EMP_TMP_TPL_HDR'

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

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