• Dynamic operator on WHERE statement

    I have a file that has 2-fields that will be used to select records from file B. File A, field 1 = date_a & field 2 = Operator. I want to select records from File B and based on the value within the operator ( EQ, LT, LE, GT, GE) and the date_a. Ex: If in File A, the value of the field Operator...

    ibBusy4sure50 pointsBadges:
  • Transferring data between iseries without using DDM/FTP

    Is there any better way of transferring data between iSeries without using DDM/FTP?

    Sv2250 pointsBadges:
  • How to run JSP with Tomcat on OS/400 V6R1

    I'm replacing an iSeries by an I5 V6r1 but it appears that I cannot use Tomcat any longer to run JSP applications. What should I do?

    JPPLOU125 pointsBadges:
  • Regarding iSeries journaling

    Can we copy the journals in iSeries from one library to other library?

    iSeries115 pointsBadges:
  • Upgrade/migrate from 720 v4r5 to i5 520 v5r4

    Can a SAVLIB on a 720 v4r5 and a RSTLIB on an I5 520 v5r4 be accomplished, or do we have to upgrade to v5r2 and then to v5r4?

    Andrewsdad25 pointsBadges:
  • Transferring data from iSeries V5R4 to Windows 7 PC

    We are getting an error message (sys3827) when we try to transfer data from an RPG2 program on an iSeries 800 running V5R4 to a Windows 7 (64bit) PC running iSeries Access V6R1 (data to be used by Filemaker Pro 11). Any suggestions?

    jeffg25 pointsBadges:
  • iSeries WorkStation v5.9 on Surface Pro

    I'm not an IT guy, just a frustrated Outside Sales Rep. I recently BYOD a Surface Pro for work. A HUGE improvement over the 15" 6# monster I had before. The company that handles our AS/400 iSeries Access had issues installing it on my Surface Pro. They rolled back the graphics driver to Intel...

    gwydionjhr30 pointsBadges:
  • WRKQRY query

    In WRKQRY, while selecting the collating sequence, what is option 2-Query for iSeries English? I am trying to learn the options in WRKQRY and came across this. F1 help details are not digesting. Please help.

    RamvishakRamesh2,505 pointsBadges:
  • SFTP

    I need to transfer a file using SFTP. It's a PF with a 180 character field. When I try the put command from an iSeries library, the file goes over as binary. If I copy it to the IFS and transfer from there, it goes over as text. But, I cannot have this unencrypted file in the IFS, even temporarily....

    CandyS30 pointsBadges:
  • Is there a way to backup iseries partition without using a tape

    I am using zipseries to backup libraries one by one >> Is there a way to backup the whole iSeries partition without using a tape device? That is to take a backup on PC or laptop. We have IBM 9406-520...is there a way to backup the whole server to a laptop?

    abar1425 pointsBadges:
  • How to read MS SQL tables using iSeries RPG

    Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

    WoodEngineer6,365 pointsBadges:
  • Spool file info

    I need to capture spool file information from a job within that job. I can get most of the info from using RTVJOBA but how do I get the file number?

    RayM265 pointsBadges:
  • iSeries SQL Cobol

    In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with "date" as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks

    Pgmr4655 pointsBadges:
  • Sending Japanese characters from Websphere Message Broker to iSeries

    We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a...

    tonyflavell10 pointsBadges:
  • Canon ImageRUNNER on iSeries printing to specific mailboxes

    We have connected a Canon ImageRUNNER to our iSeries via the network.  I have created a Workstation Customization Object to send reports to a specific mailbox and can't get the PJL code to work.  I know the system is recognizing the Workstation Customization Object because I can get it to switch...

    KarenM15215 pointsBadges:
  • Getting DB2 data into SQL 2008 database

    We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to...

    ToddN20008,925 pointsBadges:
  • Block Crystal Reports from iSeries access

    We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we can...

    WoodEngineer6,365 pointsBadges:
  • Display the scheduler on iSeries system

    How can I remove access to WRKJOBSCDE,CHGJOBSCDE, ADDJOBSCDE and leave a user with access to a browse command?

    scheduler115 pointsBadges:
  • Change the language for a user

    How to change the language for user in iSeries?

    MayurRastogi390 pointsBadges:
  • QBatch subsystem Monitoring

    Hi Guys, I have requirements, I need the Job details like( Job Number, name , user) of any job as soon as they entered in Qbatch Subsystem. Do we have any API or some commands to fetch that... The only solution i m thinking is of take the *Print of WRKACTJOB command for QBATCH every minute and...

    ddaswani170 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