• Never ending Job and Subsystem

    We have a job within a subsystem that just won't go away. We have tried ending both the job and the subsystem it is running in but it never ends. This job has no program stack but does have open files and active object locks. Is there anyway to end both the job and subsystem without having to power...

    Divemaster5 pointsBadges:
  • iSeries on the Web – some pages HTTP, some HTTPS?

    Warning: newbie to web programming and all the security implications. We are developing a small shopping website to be hosted on our iSeries. We will be purchasing an SSL certificate. Only some of our pages need to be encrypted (HTTPS). Most of the pages do not contain sensitive info, so do not...

    Chance105 pointsBadges:
  • User Exit Programs FTP

    Hello I am struggling with first user exit program. I only want to allow specific users (those keyed into a file), to be able to log into FTP. In addition, I only want to allow the function of the SENDING of files, once logged in. I am struggling with how to capture the user id from the STRFTP...

    Piano520 pointsBadges:
  • Subtracting Date/Time AS/400 V5R4

    I am familiar with the subdur command. I have used it to get the # of days between 2 dates and the number of minutes between 2 times. How do I get the difference in minutes when the times fall on separate days. I guess I need to know how to calculate the interval between 2 times when the dates are...

    GHENDER200 pointsBadges:
  • Using .NET gridview control with AS/400

    I am tiring to update a table in the AS/400 with the .NET gridview control and I am having trouble binding the parameters to the SQL query. My select query work if I use a liked server but it is slow. Next I tried the ODBC driver but my select query is not working with the same input parameters....

    DJJIII5 pointsBadges:
  • iSeries password history look up

    I may be trying to reinvent the wheel here, but I have written an interface via PHP to allow users to update their iSeries password. I am calling a procedure that validates against all the password rules we have in place: Must be 7 char long, must have at least one number, cannot contain a char in...

    nadsetlab5 pointsBadges:
  • Zipping CSV to AS/400

    Hi I have one doubt in zipping the CSV files. I'm keeping the daily running reports in My IFS called ABC folder. wrklnk ABC. This folder contains 10 CSV files with date extension. Now I want to zip all this CSV files and FTP to another system. How to do this in AS/400? Please help me out in solving...

    iiiiiiiiiiiii335 pointsBadges:
  • How to send packets in peer-to-peer networking

    Hello, I'm still new in IT field. I want to ask some question about networking. How do I want to send TCP and UDP packet in peer to peer network environment which is without any server in my topology? I don't know what software should I use. After sending both packets, I have to capture the packets.

    Skh35 pointsBadges:
  • Ports communcations with AS/400

    Hi, How can I know the ports that I need to be open in my firewall if I want to entrance to my AS/400 V5R3M0 from internet? Can you tell me please what are the ports communications that I need to open in my firewall? Because if I only open the port 23 the system don't work from internet. Best...

    Ggat25 pointsBadges:
  • User Exit Programs FTP

    Hi Bruce I have this program added to the QIBM_QTMF_SERVER_REQ. I am wondering though. When I run from green screen, it types FTP 'XXX.XX.XXXX;. From PC, Open XXX XX XXXX. Then User ID XXXXXXXXXX and Password XXXXXXXXXX. From green screen, it has my user profile ID. From PC, I have no idea what it...

    Piano520 pointsBadges:
  • Date Function AS400

    I need the Date function of DB2. Actually I want to subtract the Date however I have used the follwoing: select current date -1 from sysibm.sysdummay1; But It occures an error. Is there any way to subtract the date in the query. I am using iSeries DB2 AS400

    Mr. SEA130 pointsBadges:
  • Reading values through data area except IN & RTVDTAARA?

    Is there any other way to read values through data area except using 'IN'Opcode in RPG and RTVDTARA command in CL? Please tell me if it could be done in other ways in our RPG program or in our CL program?

    6r1,640 pointsBadges:
  • SQL in an SQLRPGLE program

    I want to use embedded SQL in an SQLRPGLE program to search a file for a field entered in a screen to select data using the LIKE operand. This is my code C/EXEC SQL C+ DECLARE C1 CURSOR FOR SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC * I entered...

    Alpfalpf25 pointsBadges:
  • Not able to add folder to TOSTMF parameter

    Hey just a short question. I tested a piece of code and it works probably, but I'm not able to add any folder to the tostmf parameter.

    Blueye20 pointsBadges:
  • How do I retrieve data from Visual Basic 6.0 with SQL?

    How can I retrieve data in VB 6.0 from SQL?

    Escabarte5 pointsBadges:
  • Retreiving JOB information (command String) for JOBS waiting in JOB queues on an iSeries

    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:

    Is there any way to query the JOBSCDE entries to find job names or other keywords without going into each individual entry?

    Dhinton5 pointsBadges:
  • Remote Outq Configurations on AS/400

    Hello, I am on a model 720 iSeries V4.4 OS and am attempting to create a remote output queue to print to an HP1022n laserjet printer currently attached to our network. At this level of the operating system (V4.4), that particular HP printer is not listed under the Manufacturer Type and Model...

    LutherG5 pointsBadges:
  • AS/400 subfiles

    It's a general question. I need to update and delete the records in file at a time using subfile screens. Please see the below subfile screen when I'm selecting alternative option and press enter, it's not working. Please advise. Program logic: 0025.00 C     SFLPROCESS    BEGSR 0026.00 C    ...

    chowas400615 pointsBadges:
  • Tools for testing code in RPG

    I need tool for testing code in RPG. Any proposals?

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