• Passing library in a QMQRY

    I have a simple QMQRY with a select statement "SELECT * FROM SFMNC". But the file SFMNC are in a number of libraries. I want to pass the name of the library to the QMQRY. Is this possible?

    Kaustav0000165 pointsBadges:
  • Finding servers and FTPs in AS/400

    We are migrating the AS/400 servers from one IP to another and all the applications it FTPs or anything from within AS/400 is going to change. So, what all things I need to keep in mind and what should I change in the source codes so that the migration can be done without issue?

    Rajatgupta55 pointsBadges:
  • Is it possible to get a PDF from AS400 spool file?

    Is this possible? Is it really possible to get a PDF from spool file? Nothing seems to work. :-( I was trying to convert PDF in iSeries Navigator. I put a spool file, right click, convert to pdf, asks me whether I want a new printer, I say yes, starts a printer then a writer but then everything...

    Avrelivs80 pointsBadges:
  • Read spool files in C

    How to I read spool files in C?

    vicky15 pointsBadges:
  • Find the IP address and FTP in AS/400 programs

    I have dumps of AS/400 programs source code in text file (about 100 programs) and I need to find out where all we are using the servers (FTP command)/IP addresses in those programs. So, I want help in what all commands I should search in the source codes.

    Rajatgupta55 pointsBadges:
  • Can I use the UPDDTA command in a RPG program?

    Can I use the UPDDTA command in a RPG program in which contains a file?

    venki125965 pointsBadges:
  • Run PHP script in AS/400 batch

    We have an application on our AS/400 where we are passing changes to data down to a MYSQL DB on a server. Using a purchased product we have issues when passing large amounts of data, Were get JAVA heap dumps. So I am replacing this with a PHP process. The RPG code writes SQL statements to a file...

    CharlieBrowne42,940 pointsBadges:
  • Difference between logical join file vs. view

    What is the difference between a Logical Join file and a view in DB2/400?

    RBauer92525 pointsBadges:
  • DSPFD command throws message CPF3061

    I am trying to delete members from a physical file if the member size is reaced. I have written code in CL as below -> dclf file(qtemp/ehutmp) opnid efile create outfile by dspfd-> dspfd file(ehub) type(*mbrlist) output(*outfile) outfile(qtemp/ehutmp) and then read file and delete old member...

    mohit123210 pointsBadges:
  • Calling COBOL program from native DB2 stored procedure

    Can we call COBOL program from native DB2 stored procedure? Or can we call external COBOL stored procedure from native DB2 stored procedure?

    Tanmay2115 pointsBadges:
  • Advance Job scheduler, Job change details

    How can we identify who released a particular job which was in held status in Advance job scheduler?

    rajesh191055 pointsBadges:
  • SQL0666 SQL query exceeds specified time limit or storage limit

    I have a web service using a iDB2 connection to return a Data Set. I am searching a large table on a partial string to find a portion of a serial number, I kept getting this SQL0666 error so I had a new LF created over the file on the i-Series side by the text field I am searching on and it now...

    ToddN200036,575 pointsBadges:
  • Device is vary on pending when AS/400 job is running

    My device is vary on pending when job is running, we have a system where user job is looping under one device description. QVIRCD0017        ACTIVE TUOLST_S9       VARY ON PENDING       TUOLST_S9   SETUMGE     154582 Can someone suggest what needs to be done? Since every...

    deepakt1130 pointsBadges:
  • Zoned decimal in a physical file

    Hello all, I have a decimal field in a physical file say amount 15S2. By default when we enter value in that field all leading zeroes are not shown in PF. For example suppose I enter 00025.33 into the amount filed. It will be shown as 25.33 in PF. I want it to be 0000000000025.33 in PF. Is there...

    mohit123210 pointsBadges:
  • SST logged in users

    How to check how many interactive users are logged in into SST, except checking in WRKACTJOB? Any API?

    anaya140 pointsBadges:
  • SAVF to iSeries directory

    How would I get a SAVF from my iSeries library to a directory?

    sjw46gnw5 pointsBadges:
  • Access member table within a library using ODBC

    I want to access a member table within a library using ODBC. How can I do that?

    Kevin015 pointsBadges:
  • switch device to library mode

    Problem:  Library device TAPMLB01 is not in library mode. Recovery  Switch library device TAPMLB01 to library mode and retry the      Any have an idea how to do the switch?

    Erickpriolo5 pointsBadges:
  • SYNON connectivity

    How do I get access to SYNON AS/400?

    sarojini10 pointsBadges:
  • Is there any one who can give paid access to SYNON for training purpose?

    I need AS/400 access with SYNON loaded on it. Is this type of service provided by anyone?

    sarojini10 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