• AS400 spool converting into .TXT file which includes ASCII characters

    1) We are generating AS400 spool file which is of SNA Character String (SCS) data stream, it does contain PCL codes in it. 2) By enabling Host Print Transform, we are able to convert as400 spool to ASCII format .TXT windows file which contains PCL code in ASCII format. Question is, Is there any...

    TNKR130 pointsBadges:
  • using SQL in RPG

    I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2. Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from...

    rmb115 pointsBadges:
  • Journalling – why the SAVCHGOBJ?

    We need to turn on journalling to allow a backward recovery if a big batch job goes wrong. Do I still need to do the SAVCHGOBJ before starting the journalling in order for the restore to work or is that just for forward recovery? I still don't understand the need for it....

    BritishGent65 pointsBadges:
  • File lock on DB2 AS/400

    How do I make a file lock on a DB2 file before accessing it, to ensure that is is not updated while I'm acccessing it ?

    train0125 pointsBadges:
  • Wild card search in AS/400 query

    How do I find records that actually have percent sign in them using the like '%  "%"  %' when the % is the wild card?

    tracyv2940 pointsBadges:
  • Colors in subfile

    In my subfile, when I delete some records, I don't want to remove that records from the subfile. Instead, I want to show them in red color. What is the best way to achieve this?

    RamvishakRamesh2,505 pointsBadges:
  • How to copy records from physical to another physical file.

    Hi, I have a question when i seen my requirement. I have two physical files and one RPG program. What I need is, I want to write RPG code for " Copy updated records from one physical file to another physical file" . (Another physical file is for Backup Purpose. ) Regards Surya P

    SURYAP300 pointsBadges:
  • cross system reactive

    Hi, just wanted to know if there is any Reactive jobs which can scheduled using Advanced JS or native JS. They system does not have any ROBOT or any other tools.

    harisudhan211,005 pointsBadges:
  • Active Ports

    Hi friends, when I'm plugged in Subsystem QCTL, I see the Ports 23, 2520, 8471 and 8476 listenning '. I'm monitoring that Ports and that Ports do not listenning it sounds an alarm for my monitoring software. what am I doing wrong?, or is there another way to monitor these ports. Tks again.

    PutzGrilla785 pointsBadges:
  • AFPU QCCSID AS/400

    I have trouble getting the Swedish characters å ä ö work when I use AFP Utility in an AS/400 CCSID have 37 as the system value (QCCSID)

    tomges10 pointsBadges:
  • as400 web services

    how to send value in another program through as400 webservices

    97834441841,355 pointsBadges:
  • Object lock in AS/400

    What is meant by an object lock in AS/400? How can it be prevented?

    Parthibhan3010 pointsBadges:
  • iSeries QBATCH – 3 options

    Our site uses just the one batch job subsystem and generally this is fine, but at cerain times of the year two departments compete to run quite hefty reports. The users don't like it when their jobs get stuck in the queue as some of these jobs take a while to run. QBATCH is set to *NOMAX, but the...

    BritishGent65 pointsBadges:
  • Crystal Reports 8.0 Error

    I have created a formula called @DateCode: WhilePrintingRecords;NumberVar dblYear:= 0;NumberVar dblWeek:= 0;StringVar strYear:= "00";StringVar strWeek:= "00";StringVar strDate:= {OrderDet.User_Text1};DateVar dtDate;DateTimeVar dtDateTime;StringVar strDateCode:= "0000"; If IsDate(strDate) Then(...

    ShopTechBBaxter25 pointsBadges:
  • mq/400 in as/400

    Hi Guys Hope u guys r in the pink. I have a file in XML format which is sent to iseries through MQ series.This file has to be parsed and the records are to be written to a physical file and also into content manager.Could anyone please tell me how to do this task? Could you plz post the code if you...

    madhuchowdary350 pointsBadges:
  • Automatic DASD

    Hi everyone, I was how can i have an hourly display of DASD in our system. I want to use this for monitoring purposes Thanks in advance Jose

    joverparas380 pointsBadges:
  • Delete Physical file member data (selected)

    I have a physical file in AS/400 machine which has a member which contains history data. I tried to delete few records from the member using SQL statement. but there is no place to enter the member name in the SQL statement. So I need to know a method to delete few selected records in the file...

    kcs10 pointsBadges:
  • Can Audit journal and database journal receivers be tampered. ?

    Can Audit journal and database journal receivers be tampered.ie. entries modified or deleted by users who have *AUDIT authority alongwith *ALLOBJ authority.

    JohnsonMumbai1,160 pointsBadges:
  • Link to file in IFS – file not found error.

    To avoid sending very large SQL results through the email system I have created a command to place the file in the IFS and just send a link to the user via email. When I click on the link to open the file, it opens right up. When the users click the link, they get a "file not found" message. Why? I...

    Jsuper25 pointsBadges:
  • What should we do as AS/400 Programmer?

    I'm AS/400 programmer for years. As we know AS/400 market is shrinking. I plan to learn new technology. but I don't know much more other programming language. Could anyone please suggest which should I learn to integrate with my RPG programming skills? PHP or Java? or others ?

    as400career30 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