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

    ToddN200011,820 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:
  • 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:
  • Printing Heading in Simplified Chinese

    I have been asked by one of oversea office to print a currently English title & column heading report in simplified Chinese. The contents are no change. I haven't do any DBCS report before. What should I need to change & install? We are running on V5r4. Can I use copy and paste to change...

    sydlee5 pointsBadges:
  • AS/400 RPG, Passing an Integer variable to an RPG program from the command line

    How can you pass an Integer variable to an RPG program from the command line? Please provide an example.

    ANGEL201310 pointsBadges:
  • Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637

    This week's free IT book is just what you need if you're planning to take your CCNP Security SECURE 642-637 certification exam. From exam topics and quizzes to exam prep tasks and realistic exam questions, the Official Cert Guide is a must for everyone preparing or planning to prepare for this...

    MelanieYarbrough6,345 pointsBadges:
  • Protecting plain text password transmission in iSeries Access

    iSeries Access for Windows using TCP/IP connectivity applications such as telnet and ftp transmit data and passwords over the network in plain text. This means that the data and passwords can be intercepted and read by other users on the network. Looking for solution to solve this problem.

    AS400 - Ask the Expert485 pointsBadges:
  • Joining More Than 2 Files

    What is the best way to join more than 2 files using SQLRPGLE with embedded sql?

    TJSDAD35 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