Command overview

5 pts.
Tags:
AS/400
AS/400 commands
What are the different commands to see a file/table in an AS/400 database and also some commands to update, create table, insert record (data)
ASKED: October 1, 2013  7:40 AM
UPDATED: October 8, 2013  2:10 PM

Answer Wiki

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

Fourth time putting in an answer for this question. I have tried to put in the Discussion section, but it does not stay.

AS400 commands are made up of nouns and verbs.

Nouns: F= File, OBJ= Object, PGM=Program, etc

Verbs: WRK=Work, ALC=Allocate, DSP=Display, etc

Use the GO CMDxxx menu system. Replace xxx with any noun or verb.

Discuss This Question: 4  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
  • CharlieBrowne

    Third time putting in an answer for this question. It does not stick

    AS400 commands are made up of nouns and verbs.

    Nouns: F= File, OBJ= Object, PGM=Program, etc

    Verbs: WRK=Work, ALC=Allocate, DSP=Display, etc

    Use the GO CMDxxx menu system. Replace xxx with any noun or verb.

    39,780 pointsBadges:
    report
  • philpl1jb

    On the command line, type:

    go cmdfile

    48,545 pointsBadges:
    report
  • philpl1jb
    SQL can be used to update, create table, insert record
    48,545 pointsBadges:
    report
  • TomLiotta

    To "see" a file, the RUNQRY command is most commonly used. It will dynamically create a query object that can list rows. That assumes that you're asking about "seeing" data contained in a file rather than seeing the file itself.

    But generally "commands" don't access data in files. There have been commands that were created to access data. We'd need to know what 3rd-party commands have been installed (or created) on your system before we know what they might be.

    There are commands that can give you access to utilities or to SQL, and the utilities can modify data. For example, the UPDDTA command will connect you to a temporary DFU utility. From there you can modify data. And in i 6.1 and later systems, the RUNSQL command lets you execute a SQL statement that may INSERT, DELETE or INSERT data.

    But native commands by themselves don't do it.

    Tom

    125,585 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