• Difference between Structured Query and Query in AS/400?

    We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. What is the difference between Structured Query and Query? (SQL and QRY)

    anupsshelke420 pointsBadges:
  • Use 200-character variable in AS/400 subfile

    Hi.. I have 200 character-length variable (for ex Address) as a field name. I want to use this in a subfile. Is it possible? How? By using sflfold option?

    Sureyz2,195 pointsBadges:
  • PageDown and PageUp functions in SFL subfile


    Sureyz2,195 pointsBadges:
  • FRCDTA and PUTOVR keywords


    kennedy2802110 pointsBadges:
  • How to access F15 on keyboard


    Pwsadmin5 pointsBadges:
  • OVRDBF in real time


    Ben Rubenstein3,395 pointsBadges:
  • Confirm an AS/400 record without read and chain

    How do you know a record exists without doing read and chain?

    kennedy2802110 pointsBadges:
  • Error in AS/400 code?

    Fstdt if e disk Dnam s 10a Ddept s 3a C/exec sql C+ SELECT NAME, BRANCH INTO :nam, :dept FROM stdt WHERE STDID < 10 C+ C/end-exec C seton lr Hai all ..! I have this code .. But i'm not getting the output.. how can i get the result?

    Sureyz2,195 pointsBadges:
  • AS/400 SORTA command

    How to sort array in Descending order using SORTA Command?

    rajeshece1,195 pointsBadges:
  • OVRDBF does not convert all records


    rajeshece1,195 pointsBadges:
  • Convert data to character string in AS/400 query


    Jubal5 pointsBadges:
  • Select code within AS/400 query

    I have to run a Query based on PF without DDS with record length 2997. I have to select Company Code '01' which is the 925-927 positions in the file. How do I do select in the Query? Please advice. Thank you.

    Larisagas260 pointsBadges:
  • Define query without WRKJOBSCDE

    How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g....

    Querys100 pointsBadges:
  • IBM TXSeries and AS/400


    Srinivas naikk115 pointsBadges:


    Durgesh813370 pointsBadges:
  • Unable to overwrite file with OVRDBF


    Kar425 pointsBadges:
  • Write record value onto DSPF using OVRDBF


    Kar425 pointsBadges:
  • OVRDBF not showing all file records


    VENKYAS40075 pointsBadges:
  • Difference between MONMSG CPF000 and CPF999

    Is there any difference between MONMSG CPF000 & CPF999?

    Knowledgeseekerone30 pointsBadges:
  • Using MONMSG to monitor for a CPF3741 message


    Smallchange25 pointsBadges:

Forgot Password


Your password has been sent to:

To follow this tag...


REGISTER or login:

Forgot Password?
