• CL program entery missing in JOBLOG

    Hi all, I have a CLP program C1 which is using SBMJOB inside the program to run 5 different batch jobs, and when i submit C1. I am getting Spool entries only for the internal submit jobs submitted by C1, but there is no entry for C1. But I want to get the starting time and ending time of my batch...

    Sai4AS4001,420 pointsBadges:
  • DLYW / DLY-5

    Hi all, When i submit a job, it is straight away going to DLYW status, Some times to DLY-5 status. What could be the problem.. please answer me. Thanks.

    Sai4AS4001,420 pointsBadges:
  • Date calculation using a variable

    This is the original standard date calculation I was using. I need to change the number of months to a variable that I'm getting from a DTAARA. Value is zoned. The error I get isDate, Time or Timestamp value is not valid. I can't find a way to change the one or two digit value to a 'date' field...

    badspeller30 pointsBadges:
  • Difference between RPG & RPGILE

    What is the difference between RPG & RPGILE?

    Ambrish 82310 pointsBadges:
  • How to Clear AS/400 810 drives of data before sending back to vendor

    Need to send a rented machine back to the vendor, but want to format or scrub our data off before I do it. What command can I use to do this?

    JacKieG5 pointsBadges:
  • AS/400 Query: Current Date

    Is there a quick way of running a query to select records based on current sysdate. I know you can get current date using Current command but I can't use it in selection.

    Gerrib150 pointsBadges:
  • AS400 Query Dates

    How do you computed dates in Query

    Philip915 pointsBadges:
  • Timestamp InCOBOL/400

    Can we use Timestamp in COBOL/400. If we can, how?

    Michael Tidmarsh48,400 pointsBadges:
  • Emails from server

    Hi, I need to find how many mails have been sent from my server. I also need to know that address. How can I track that?

    kingstoniseries205 pointsBadges:
  • Firewall preventing NET USE drive mapping PC to iSeries.

    Does anybody know what ports are used when I run net use * \\servername\share PWD /User:USER ? The firewall is stopping it somewhere although ports 137, 139, 445, and 8471-8477 are open on the firewall. It eventually times out with "System error 53 has occurred - The Network Path was not Found"...

    stropley10 pointsBadges:
  • Call a iSeries stored proc from a SQL server 2005 stored proc

    Ok I'm missing something. I've tried entering a few examples I have found in forums but can't get past a syntax error I cannot find. I'm using a linked server as well. Here is the code for the SP. Any pointers would be great! USE [MyDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER...

    ToddN200054,395 pointsBadges:
  • IFS to Spool

    I want to Convert IFS PDF File to Spool. How can I do that?

    rajeshece1,215 pointsBadges:
  • Debugging a CLP Program

    Hi all, I have a CLP Program which have a call to another CLP Program and an RPG Program. now i want to debug all these from end to end. How should i proceed.

    Sai4AS4001,420 pointsBadges:
  • WRKQRY

    how to write a Query which need to find Count(*all) of field1 group by another field field2 With some internal conditions on other field?

    Sai4AS4001,420 pointsBadges:
  • Delete contents of IFS directory

    Hi..... I have a requirement like delete the objects within the TMP folder instead of deleting the folder. Kindly suggest me the ways of deleting the objects with in TMP Directory. If I use RMVDIR, it will delete entire directory. But my requirement is need to delete the objects with in TMP only....

    venkatktata285 pointsBadges:
  • RUNRMTCMD problems.

    I am trying to use the RUNRMTCMD I have successfully used this command in the past with no problems. I have allowed the services to interact with the desktop. My problem is when I run the command I am running a VBS passing in to parms from my CL. The command runs but my spool file comes back and...

    400CodeMonkey65 pointsBadges:
  • AS/400 future

    Hi, I'm working as an AS/400 developer over the past 3.6 years. I'm just bit worried about its future. Please suggest me whether to stay or change technology? What is going to happen to AS/400 developers in the future. Information and suggestions are really appreciated. Thanks in advance.

    ITas4005 pointsBadges:
  • Read Only File defined in Update/Add mode

    The environment in which I am working is not having the authority to add a library in *USE authority. File ABLCDEF1 is in a Library with *USE authority. In RPGILE if I declare a file like below: FABLCDEF1IF E K DISK And then have an update statement. Will the program fail in file declaration it...

    123qazwsx09810 pointsBadges:
  • Hi, AS400 – SQL triggers for tables

    Hi, 1.Could any one let me know whether AS400 SQL Triggers will accept cursors. 2. DOW is also not accpeting.Instead i tried the below code, but even then i am getting SQL0104 error. Declare c1 Cursor For Select STATUS from T_RODTLS TR Where TR.COMPANY_CODE = @Company and TR.VPC_CODE = @VPC and...

    As400pgmmer310 pointsBadges:
  • Read/write Form file with same fields.

    Hi all, I am reading from file PF1 with a record format R1 And based on some criteria/calculations i am writing the data to another file PF2 with same field names as PF1. I think Prefix is useful in this case, if so for which file i need to specify the prefix while declaration?

    Sai4AS4001,420 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.

Following