• Plus signs in fields when using a date from a file compared to the month and year function

    I have included the complete SQL statement. I keep getting +++ in ontime and percent. select c.totallines, c.ontime, decimal(((c.ontime/c.totallines)*100),15,2) as percent from (select decimal(sum(b.totallines),15,2) as totallines, decimal(sum(b.ontime),15,2) as ontime from (select a.ord as ord,...

    LoriWood20 pointsBadges:
  • Avision AV2800 Scanner

    I am almost at the point of purchasing a new Avision AV2800 Network Scanner for our Company. Problem I have is whether it will enable us to save our scanned files directly on to an iSeries5 IBM Server. I have heard other companies with a "Windows" file server do not have any problems with this, but...

    Crescents5 pointsBadges:
  • QSYSOPR does not have authority to perform upgrade

    we were trying to perform the Prepare for Install from GO LICPGM and loaded the CD'S as QSYSOPR and we were NOT AUTHORIZED, is OS upgrade on iSeries not a part of QSYSOPR profile?

    harisudhan211,005 pointsBadges:
  • unlock multimember file

    I have an unusual problem with an RPGLE program. This is called inside of other programs that were originally a package software. The file is multi-membered and I am not able to remove locks on the member even when I exit the program, use other programs, etc. I am on an iSeries and commitment...

    VGP300 pointsBadges:
  • 5733SC1; ability to sftp to a Unix box

    I have a need to get information from an i5 to a Unix box. And it has to be unattended. Catch; Unix is allowing only SFTP (not i5's definition of secure ftp, the Unix definition. Port 22). So, FTP isn't an option. In all IBM & everyone else's 'documentation' about all can find out is that need...

    Neptune210 pointsBadges:
  • Secure FTP

    Please help me to set up Secure FTP for our AS400 iSeries-V5R2 machine to accept SFTP from Unix machine. Thanks. Luong Nguyen

    Ncb5 pointsBadges:
  • How to get the log of SFTP in batch mode

    Hi, I have a SFTP process from iSeries to other system.  If I run the CL with command sftp -b script.txt user@server in on-line mode I get the log of process, like: Connecting to Server...                            sftp> chdir...

    ricardoval20 pointsBadges:
  • Download from iSeries directly to an Excel xls file – no CSV

    I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.

    Sillyhp35 pointsBadges:
  • Has the certification for AS/400 v5r4 operator ceased?

    Am trying to find certification for 000-975 ( i think ) for iSeries v5r4 operator, has it been taken of record because all I see is v5r4 administration and no operations.

    harisudhan211,005 pointsBadges:
  • Batch jobs disappear

    Batch jobs show under WRKUSRJOB while the job is active but then disappear once the job finishes, even though there are spool files for this job. Any ideas on how to change this so the job remains visable to the user so that they can easily find the spool files for the job?  Happens for both jobs...

    Dkmj25 pointsBadges:
  • List all file members from a multi member AS400 File

    I need to be able to retrieve a list of the members of a multi member file  so that I can process the members that meet certain criteria.  I need to be able to do this from a PC application. If there is anyone with any ideas I would be grateful.   Thanks

    AndrewPage5 pointsBadges:
  • retreiving Job information (command String) for jobs waiting in job queues on an Iseires

    When we submit a job on an Iseries to a job queue, it gets submitted with a command string. I have a process where I am using APIs to go out and get information on jobs that are on our job queues that are waiting to run. The APIs that I use work great but they do not show me the command string that...

    ISERIESTECH135 pointsBadges:
  • Running the QSPOLJBQ API

    I am calling this API that is an RPG program. When I run the program in debug mode it runs fine and displays all my jobques on the screen. When I enddbg, the program only goes through the code 1 time. Would anyone know why this is happening?

    ISERIESTECH135 pointsBadges:
  • Transfer Or copy savf from Iseries Server to Other Without use ftp

    Hi How copy savf file from iseries server to other without need to user FTP because it not working with me

    AS400SQL25 pointsBadges:
  • Need Help With QMHRCVM – Receive Nonprogram Message API

    Need Help With QMHRCVM - Receive Nonprogram Message API.  I am having problems with the parameters (4 BYTES)  Can someone help? D ERRORDS         DS                  INZ      D  BYTESPROV              1      4B 0 INZ(116) D ...

    jldunn55 pointsBadges:
  • Autorun wrkusrprf at login

    I have created a "Support" ID and I would like to Auto run wrkusrprf after the user (Support Desk) signs in to manager user accounts only

    Chomskie0 pointsBadges:
  • Websphere 6.0 Performance

    We have a basic Websphere application that is infrequently used. As a result, when it is used, everyone pays the "first time" penalty, and response times can be VERY slow. The second attempt is better, but by then the client is already mad. Is there a way to keep the application "awake" so that...

    Jbiddle5 pointsBadges:
  • records retrievel

    how can i retrieve deleted records?

    Daudgill5 pointsBadges:
  • Iseries 5.4 HP Printing.

    We have been replacing our HP printers throughout the organization. I have updated the new IP address within the wrkdevd and updated the driber info. Now when the user prints from the AS/400 it will print portrait instead of landscaped....where should I be looking....this is driving me nuts! THanks

    Rmason335 pointsBadges:
  • How to check a perticular record

    How to check a perticular record in aphysical file without using READ and CHAIN

    9633695 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