• SQL (QMQUERY) date conversion issue

    I inherited a QMQUERY program that my user came to me today indicating that the week number was not correct. This query puts data into a workfile and a second query is called that splits other data into fields. As far as the two relevant fields are concerned, the second program does not modify...

    azohawk1,880 pointsBadges:
  • Error in calling RPGLE program from CL

    I have a job running under subsystem. This job is using a CL program which inturn calling RPGLE program. The CL program is failing in call statement to RPGLE with following error message in jobog: Pointer not set for location referenced. Pointer not set for location referenced. Pointer not set for...

    Mayurp5 pointsBadges:
  • Data structure array in RPG

    I have a physical file has 10 column like filed01, filed02, field03......field10 Now I want to define a data structure with 10 subfield of char 5 and use in cursor. For example: select * from t1 fetch from t1 into :DS1 Now I want a array of 10 element automatically get the value from my DS1. Thanks...

    97834441841,465 pointsBadges:
  • RNF7591 on func’s result

    Dear all! I am trying to work with DS fields returning from procedure call. Here are definitions: d fileds E ds EXTNAME(file1:rfmt1) qualified d rsltds ds likeds(fields) d getDS pr likeds(fields) d inID const like(ID) d inDATA const like(DATA) options(*nopass) If I write:...

    tempally25 pointsBadges:
  • Where do I download IBM iSeries ACCESS 6.1 x32 bit for Windows 7

    Can anyone please give me the link to download IBM iSeries ACCESS 6.1 x32 bit for Windows 7?

    harisudhan211,005 pointsBadges:
  • IFS Command *PUBLIC authority

    How do I change DTAAUT and OBJAUT for IFS CRTDIR command? I need to make *PUBLIC DTAAUT *EXCLUDE and OBJAUT *NONE. I tried CHGAUT but the object is looking for a path.

    maryann4610 pointsBadges:
  • Issue with a IBM z/OS FTP MPUT execution in a batch job

    I am trying to MPUT multiple *.XML files from a vendor server to my local server. This process works for multiple files TEST.XML and TEST2.XML, but not for 20160518.XML. Are there filename restrictions. The first character has to be character or is it possible to transfer multiple filename that are...

    LeeAnnNunnery5 pointsBadges:
  • AS/400 DB2 Sav file

    Can an AS/400 DB2 Sav file be restored or migrated to MS SQL Server or Oracle? If not, can non IBM program or script be used to parse data from a SAV file?

    jknight275 pointsBadges:
  • AS/400 can not send the mail to mail server

    Our AS400 version is V7.1. After I run the command: SNDDST TYPE(*LMSG) TOINTNET(('my-mail@my-company.com' *PRI))  DSTD('TEST1 Description') LONGMSG(' TEST1') IMPORTANCE(*HIGH) PTY(*HIGH) The log show: Send distribution completed successfully. But the mail server receive nothing. I have set the...

    TOMJia105 pointsBadges:
  • Easy way to identify DB file for specific data on screen (AS/400)

    I am trying to identify where a specific line of data is coming from when I am in a session. I've tried Shift+ESC+3+14, and all I get are active DB files. Is there a way to focus the search to one specific line of data and identify the source DB?

    mssanwo15 pointsBadges:
  • Unable to connect to AS/400 server

    I have downloaded as400 emulator TN5250 (free trial version). After installing the setup it took the IP address automatically. But if I say connect by giving a session name, it says "Sorry, unable to connect to the selected mainframe"

    Anugwag40 pointsBadges:
  • RPG large number

    Yes I'll research this on my own, it seems like it'd be an interesting topic. What is the largest numeric size usable in RPG? I'm after the high-end, not the decimals. TMI: I have a calc that blows up when the result is too large for the target field. I know I can calc to a 15.6 numeric, but hoping...

    aceofdelts2,330 pointsBadges:
  • Reset job number on OUTQ

    The job I submit is not the last on the OUTQ. How can I reset, please? Thank you - Yonathan Magal, Israel

    YonatanMagal5 pointsBadges:
  • Call by value/Reference

    Hi,Please explain with the example of call by value and call by reference in RPGLE.Thanks

    as400dev585 pointsBadges:
  • How to substring and cast in select where statement on iSeries with RPG free

    Hi. I'm relatively new to free form RPG and I rewrote a program to be RPG free and SQL. I'm having problems with my where clause. I'm trying to substring the second byte on a 2 digit packed field. I've tried to use the CAST statement to convert the packed field to CHAR and then do the SUBSTRING on...

    raynesnf65 pointsBadges:
  • Difference between READE and CHAIN

    Hi, What is difference between CHAIN and READE both reads equal key record? Looping possible do while in both so that both will filter equivalent key records but what is main difference then? Thanks!

    6r1,765 pointsBadges:
  • Can OS/400 change an object’s update date?

    Can OS/400 change an object's update date? I have an audit issue because fields ODSRCD and ODLDAT in a *PGM object appear to be changed, while the application has not changed and we don´t even have the source code.

    GerardoB5 pointsBadges:
  • RPGLE calculation of date

    I had a requirement to calculate a due date based on given date + n number of days. The due date should exclude Saturday and Sunday comes in between the range. Is there any way to achieve this? For eg.  if 15 days add to 6 May, 2016, then the due date should be 27 May, 2016.

    Babs312290 pointsBadges:
  • Working on AS400 for 3 years, please help me with some sources to get job in abroads.

    Hi, I am working on AS400 development for 3 years in INDIA for MNC company. But i didn’t get a chance to travel to Onsite to work closely with clients. Some of my friends who had same experience in AS400 got jobs in US and UK and some other countries through some external sources. Now I don’t...

    ManishAS40015 pointsBadges:
  • Error code CWBCO1048

    I keep getting a CWBCO1048 A firewall or blockage or Time-out occurred trying to connect IBM i. How do I cure this. It seems to happen in only this one branch and not in any others? Thanks Leo

    superbru43115 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