• PageDown and PageUp functions in SFL subfile

    How to manage the PageDown and PageUp function in SFLSIZ=SFLPAG subfile..? If anybody have the sample codes for this please share it... Thanks.

    Sureyz2,375 pointsBadges:
  • FRCDTA and PUTOVR keywords

    What is the purpose of FRCDTA keyword? What is the purpose of PUTOVR keyword?

    kennedy2802110 pointsBadges:
  • How to access F15 on keyboard

    How do I access F15 on my keyboard when it only goes to F12?

    Pwsadmin5 pointsBadges:
  • OVRDBF in real time

    Hi, Can anybody tell me about OVRDBF in real time answers?

    Ben Rubenstein5,190 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,375 pointsBadges:
  • AS/400 SORTA command

    How to sort array in Descending order using SORTA Command?

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

    I have 5 Different Files with 5 Members. I wanted to process all records in all members. I used OVRDBF FILE(FILE) TOFILE(FILE) MBR(*ALL command. It did not convert all records in all members. My AS400 version is not supporting EXTMBR(*ALL).

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

    I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can't see how to convert the temperature to a character string either as the sign is ignored. Any other...

    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.

    Larisagas265 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

    The customer is using custom gateway using IBM TX series (multiplatform v6) on AIX platform and the client's all IVR related transactions are available through LU 0 protocol only and we should not use any other in order to intract with AS 400 host (CICS). Please clarify the below: 1. The IBM TX...

    Srinivas naikk115 pointsBadges:
  • OVRDBF and UPDDTA

    I am using command OVRDBF to override my database physical file suppose "ABC " (file to be overridden) and second physical file let "DEF" (the one with which we are overriding) now I execute this command: OVRDBF FILE(ABC) TOFILE(LIBRARY/DEF). After the execution of this command when I use the...

    Durgesh813370 pointsBadges:
  • Unable to overwrite file with OVRDBF

    DCLF FILE(EMP001P) RCvF RcdFmt(EMPREC) OVRDBF FILE(EMP001P) TOFILE(EMP001P) MBR(SECOND) + SHARE(*YES) MONMSG MSGID(CPF0000) EXEC(SNDUSRMSG MSG("ERROR") ) RCvF RcdFmt(EMPREC) Here, I'm unable to overwrite the EMP001P file with second record. pls suggest correct way to do it.

    Kar425 pointsBadges:
  • Write record value onto DSPF using OVRDBF

    In a single CL/400 program, is it possible to declare physical file File1, then read a record and later writing the record value onto the DSPF using OVRDBF with in a same CLP?

    Kar425 pointsBadges:
  • OVRDBF not showing all file records

    In CL program, declared a file FILE01 and read some records, later using OVRDBF accessed another file FILE02. Still I'm getting records of FILE01 only but not FILE02. Why? Thanks Venkat

    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

    Can I use monmsg in an exit in brms to monitor for a CPF3741 MESSAGE

    Smallchange25 pointsBadges:
  • Where to get all MONMSG list of messages to code in a CLP

    Where could I get all the MONMSG list of messages to code in a CLP?

    ten20081,150 pointsBadges:
  • RUNRMTCMD fatal error: handle is invalid

    Hello, I am facing an issue while using the RUNRMTCMD command from iseries. I am trying to Zip a set of text files that are produced as output in the IFS directory. The IFS directory is mapped to the Win2000 machine. The command I am using to accomplish this is: RUNRMTCMD CMD('"C:WinzipWZZip.exe -a...

    Manish1230 pointsBadges:

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