• 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 Tidmarsh34,110 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...

    ToddN200015,605 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:
  • FTP in AS/400

    I want to FTP some date from a PF in one system to another AS/400 box, Is there an API which can help me out?

    PRIYAS40 pointsBadges:
  • Connect Direct File transmission

    How to confirm whether the file has fully transmitted from source system(say mainframe) to iseries. I know how to check manually using wrkoutq. Mainframe is transmitting FileA to iseries. File transmission itself will take 1 hour to complete or sometimes may take upto 2 hours. iseries job should...

    anuppdas105 pointsBadges:
  • Batch Job Procedure

    Hi all, i have a CL program C1 which internally have a CALL to an RPG program R1 which reads a file F1 and writes to file F2. My CL program C1 also using SBMJOB command to CALL another CL program C2 which was designed such a way that it will submit 5 jobs(with all the neccesary information given)....

    Sai4AS4001,420 pointsBadges:
  • SQL optimization in COBOL400

    I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch? The file has key as date. My sql would look like Delete from FileA where Date < 'some date'

    anuppdas105 pointsBadges:
  • AS400-Who created a user profile

    Is there a report on the AS400 that will show who created a user profile.

    Lope4451720 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