• 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,720 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...

    Durgesh813375 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:
  • 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:
  • RUNRMTCMD error CPF91CC – related to user id?

    I am trying to execute RUNRMTCMD command from CLP on one partition to another partition using *SNA method. I can execute this CLP without any error when I specify my user id and password on remote user id and remote password parameters. When I try to execute the same CLP by specifying another user...

    Cursorposition195 pointsBadges:
  • RUNRMTCMD error CPF91CC

    I tried to run .bat file on pc using remote command but I have the below error: A remote host refused an attempted connect operation Command did not complete successfully. (CPF91CC) noting that i used the command RUNRMTCMD CMD(CMD) RMTLOCNAME('199.199.199.199' *IP)

    Hanisadeq120 pointsBadges:
  • Declare and read multiple logical files in RPGLE

    Is it possible to declare and read the Multiple logical files in RPGLE Programs? Why?

    rajeshece1,215 pointsBadges:
  • Display name as blanks in RPGLE

    FTESTCF IF E K Disk * /Free EmpNo = 100; Chain (EmpNo) TestCF; If %Found(TestCF); Dsply EmpName; Endif; Dsply EmpName; Clear RTEST; EmpNo = 101; Chain (EmpNo) TestCF; If %Found(TestCF); Dsply EmpName; Endif; Dsply EmpName; Above Code Employee NUmber 100 is found in File. Employee Name is coming as...

    rajeshece1,215 pointsBadges:
  • Decide variable name based on value in RPGLE

    I want to move some values to variable in RPGLE Program. I want to decide the Variable name based on the value which i received. Eg: If i am getting 'DEmail:xxxx@xxx.com' from my calling program, i want to move to DEmail Field. All the Fields are available in Display File. How will i achieve this....

    rajeshece1,215 pointsBadges:
  • Check records in RPGLE file without reading it

    How to check the Records Existence in a file without reading a file?

    rajeshece1,215 pointsBadges:
  • Change numeric field to character field in free-format RPGLE program

    I wanted to change Numeric Field to Character field. I am using Free format RPGLE Program. I have used %Char to do this operation. It is moving 2 to Character field, While trying to move 02 to Character field. I am expecting '02' in Character field. How to achieve this in Free format RPGLE Program?

    rajeshece1,215 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.

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

Following