TABLE type not detecting in AS/400 Green Screen

635 pts.
Tags:
AS/400 administration
AS/400 green screen
iSeries Navigator
hi, I created a table from i series navigator of type TABLE in lib XYZ. Now i want to see the object in AS/400 green screen. How do i see that Thanks Siddharth

Answer Wiki

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

My favorite is the RUNQRY command. Enter it as RUNQRY QRYFILE(XYZ/tablename). It is very quick and very dirty, but it will show you everything in the table.

Or use the WRKQRY command and build a more elaborate output, screen or print. There is also SQL and other query products.

Good luck,

Leo Burkett

=====================================================================

My reply above assumed you wanted to view the rows in the table. The table is an object, and a “file” in OS/400-speak, so object and file commands can be used.

Try DSPOBJD OBJ(XYZ/tablename) OBJTYPE(*FILE) (Display Object Description) to see attributes of the table which are common to all objects.

Try DSPFD FILE(XYZ/tablename) (Display File Description) to see attributes of your specific table.

Try DSPFFD FILE(XYZ/tablename) (Display File Field Description) to see attributes of the columns in the table.

Leo

Discuss This Question:  

 
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

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