• 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 Tidmarsh31,735 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...

    ToddN200012,805 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...

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

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