• QTXTSRC wrap commands

    I am trying to enter in a command for FTPing that will execute a command on a remote system but I get cutoff at 80 characters. How do you wrap to the next line ? here is my command that is missing the last ')': quote RCMD RSTOBJ OBJ(*ALL) SAVLIB(R36MODSDTA) DEV(*SAVF) SAVF(DISASTER/DISASTER Thanks,...

    Andyrads0 pointsBadges:
  • XLS integration to Iseries

    I am looking for information on getting XLS data to the Iseries. Specifically would like to get XLS into XML format so an EDI/XML translator can pick it up and send through our existing EDI processes. The XLS will come from e-mail clients.

    Roses060 pointsBadges:
  • Retrieving data into a COBOL/400 program

    Cynthia wrote in with this question recently: "How can the contents of a data area be retrieved into a COBOL/400 program?" -- Debra Tart, associate editor

    DebraTart0 pointsBadges:
  • Move Date field to numeric field in COBOL

    Is there a function in COBOL to move a Date field to a numeric field (yyyymmdd)?

    KevinBattreall0 pointsBadges:
  • SDA design field

    Edwin wrote in with this question recently: "We have created a PF with six fields; one field has a 500 character length. How can I put or display the field in SDA with a 500 field length? And can we design a overlapping field with subfile?" -- Deb Tart, associate editor

    DebraTart0 pointsBadges:
  • AS400 Programming in RPG 400

    i am a novice at programming. Have written a small program which populates a PF. I am not sure how I can display a USER message which would reflect if the user attempts to add a record which is a duplicate on the key field. I did try to browse the programmer's guide but find that i would have to...

    DVKAMTE0 pointsBadges:
  • COMMAND – parameter title

    What is the way to define parameters in a command so they will be indented and displayed under a title like: Inline Options:: . Inliner . . . . . . . . . . . *OFF *OFF, *ON . Mode . . . . . . . . . . . . . *NOAUTO *NOAUTO, *AUTO . Threshold . . . . . . . . . . 250 1-65535, *NOLIMIT . Limit . . . ....

    GonenSho0 pointsBadges:
  • Write a file system driver over an IFS

    Dayala wrote in with this question recently: Is there any way to write a file system driver over an IFS other than creating a UDFS? My intention is to write a file system driver that intercepts create, open, read, write, close functions, and register it with IFS. Is that possible? If it?s possible,...

    DebraTart0 pointsBadges:
  • Automate transferring data from the iSeries

    Rick wrote in with this question recently: "I am trying to automate transferring data from the iSeries to a PC server using FTP. I have built the CL's, the RPG ILE program and the test file. Everything looks good except that when I execute the CL and the program gets to the FTP portion I receive a...

    DebraTart0 pointsBadges:
  • Passing a parameter to the SQL command

    Jhon wrote in with this question recently: "How can I pass the parameter to the SQL command if they are stored in a Source file?" -- Deb Tart, associate editor

    DebraTart0 pointsBadges:
  • A copy tool??

    Hello to all, I am a COBOL programmer working for a life assurance company which uses a life assurance package developed on the iSeries. I have been tasked with looking into whether it is possible for us to copy a 'contract/policy' from our live environment to a development/test environment. This...

    ITnavan0 pointsBadges:
  • sending message and variable to message queue using RPGIII

    Is there a way using RPGIII that I can send a message with a variable to a message queue?

    AS400Consultant0 pointsBadges:
  • List of Values in a SP Parameter

    I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in('Value1', 'Value2','Value3',...

    Saratusthra0 pointsBadges:
  • New overlay software needed

    Nancy wrote in with this question recently: "We are upgrading from iSeries V4R5 to iSeries V5R3. We need to change our overlay software from Forms eXpress (which is no longer made, which means no support) to something else that will also work with the iSeries format. This should also transfer well...

    DebraTart0 pointsBadges:
  • Positioning a field depending on certain conditions

    Jana wrote in with this question recently: "Can I position a field depending on certain conditions? For example: If the condition is true, the field will be on (10,10). If false, the condition will be displayed at (15,10). Is that possible? If yes, please let me know how?" -- Debra Tart, associate...

    DebraTart0 pointsBadges:
  • SQL Select

    Does anyone know of a way to use SQL (embedded) to select only the 1st occurence of duplicate key records in a file. I have a file where there may be duplicate keys and I need the 1st occurrence of the key as the data following the key is the data that is needed.

    RPGCRAZY30 pointsBadges:
  • iSeries and PHP

    I am on a i520 running V5R3, I am thinking of using PHP to build some SQL query built web pages. I use PHP at home on Linux with MySQL so I think I have just enough knowledge to be dangerous. I was reading the RedBooks paper ?Bringing PHP to Your IBM eserver iSeries Server?. It appears to be...

    Verl8100 pointsBadges:
  • Variable Positioning of a Field in a display file

    Is it possible to set the postion of a field in a display file as per the condition without using two record formats? Like, if a said condition is true, the field will be displayed at (10,10), otherwise it will be at (15,10).

    Rajsekhar0 pointsBadges:
  • RRN in Query

    Does anyone know of a way to retrieve the rrn in a query and print it on a report?

    Fabrics0 pointsBadges:
  • data encryption/decryption

    We are in the process of building encryption/decryption applications. We are using the IBM QC3ENCDT AND QC3DECDT API'S. I've starting testing against our database using apprx 3000 records to encrypt and then decrypt. Out of that 3000 records, there are 17 instances of failure to decrypt to clear...

    Rigger0 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.