TABLE type not detecting in AS/400 Green Screen

635 pts.
Tags:
AS/400
AS/400 administration
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
Asked: Last updated:
Related Questions
1

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.

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.

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

Following

Share this item with your network: