• DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • Compare a field from a file to a column from DB2

    Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.

    BobBill10 pointsBadges:
  • What is command we can use for calculate difference between 2 times (like subdur)?

    we can use subdur for calculate the difference between 2 dates. and what's the function code that can use for difference between two times?

    Ccss10 pointsBadges:
  • Locking in AS400

    Good day, I hava a process in as400 system that locks if 2 users enter the application at the same time. I thought that once it is out of System-36 and becomes ILE Cobol, locking would be resolved. I was wrong. This is what it does: 1. File is read and data presented on screen (database file). 2....

    Lenny2113115 pointsBadges:
  • Copy of QPDZDTALOG

    Hi there, Is there a way to automatically generate an additional spool copy of QPDZDTALOG (generated during DFU) similar to SNDNETSPLF without interrupting the original spool or to automatically dump the spool contents to a file without the knowledge of the guy who is using DFU. Have a nice day....

    Usheriff25 pointsBadges:
  • Convert Spool file to DB file

    Hi, I have a spool file which I created by WRKACTJOB (*print).. Is it possible to convert the spool file format to a database file..... What does an OVRPRTF command do ...? Thanks, Yogesh

    Cool400115 pointsBadges:
  • WRKOBJLCK problem – file locking I think

    this is the problem. I run a long job containing updates of 2 files, OCLINE and OCHEAD. The program finishes fine but when I try to get into the file maint programs for these files, a blanks screen comes up. Then I sign off the terminal and sign on again and the maint program works fine. I think it...

    Mikea5 pointsBadges:
  • Writing directly ot iSeries optical drive

    We are creating a file that is being copyied to the IFS using the cpytoimpf command. This is working fine. But the problem is that the file is for a State agency that is requiring that the file be sent on a CD for security instead of emal which would be our normal process. Is it prossible to copy...

    AS400PCFileTransfer16115 pointsBadges:
  • When I call CL by 3 parm. (‘ ‘) change to (‘)

    When I call CL by use 3 parm like this command = CALL PGM(CTLMNUCUP) PARM('MENUA' '1' 'CALL PGMA ('')') In pgm it show Parm3 = 'CALL PGMA (') What the method I can solve? thk u.

    Naveeya5 pointsBadges:
  • How to find out number of members in Source file ?

    Hi All, i want to find out how many number of members are available in one source file. For example i have created one source file (QRPGSRC) in (LIBRARY1) now i want to find how many sources are available in LIBRARY1/QRPGSRC this source in my RPGILE program. Do we have any AS400 command or API to...

    Mohan K695 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • field validation in display file and cl

    i created one field in display file, i want accept only chars . how to validate in display file and cl program.

    Geethardi10 pointsBadges:
  • Restrict user to Specify Workstation ID

    Here is the situatiion: We have told users to use only their workstation id range only but some users are not follow instructions and in that case they are using other user workstation id range. Although, system value QLMTDEVSSN is already set as '1' (Limit). By setting up system value we can only...

    abiha6325110 pointsBadges:
  • Security for Synon library lists?

    I am having some problems locking down the library lists available to my developers. I'm sure previously, if they attempted to change their library list, using the synon library lists previously setup, and they were not authorised to one of the libraries in that list, it would fail. For some reason...

    MMTechnical50 pointsBadges:
  • Which iSeries models support P6 processors?

    Hi We currently have 550 and 825 boxes, am assuming they are all P5 processors. Please could you tell me which are the model boxes that would support P6 processors? Thanks in advance

    harisudhan211,005 pointsBadges:
  • List of files in Directory on the IFS

    I have files on the IFS in a directory /EDIIN. I need to have a program send the files based on their name to diffent locataions. Is there a way I can get a list of those file outputed to a DB so I can read through it.

    Emadkaradsheh105 pointsBadges:
  • How to email reports from OS V5R4M0

    How can I email reports to my users from OS V5R4M0?

    kkharper10 pointsBadges:
  • How do you create a file containing Simplified Chinese characters (DBCS) and English in the same field on IBM iSeries IFS in UNICODE UTF-8 format?

    Caveat - I am not an iSeries programmer(since 15 years ago), so please be very specific with your answer so that I can understand it. I am trying to print product labels with Simplified Chinese characters on a Zebra bar code printer from data retrieved from IBM iSeries (AS/400). The data for the...

    Tom P5 pointsBadges:
  • How can As400 RPG check if user is logged in

    Looking for As400 RPg code to check if user is logged in AS400. All assistance is greatly appreciated. Thanks, Alex Bernardo

    DHLSameday185 pointsBadges:
  • COBOL/400 Debugging

    Hello Everyone, Can anyone explain me the exact difference between *SRCDBG and *LSTDBG? Thanks & Regards Bibin

    BibinGeorge130 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