• AS/400 ODBC connection

    How can I restrict SQL reporter to run update and delete query via ODBC connection? I don't want to restrict some profile which are being used by other application to write some records in specific file. Please advise.

    KapilTiwari201850 pointsBadges:
  • DSPOBJD for Library size and # of objects

    Is there a command/way of just getting the number of objects and total size of libraries other than selecting the *PRINT option? I wanted to dump the information to a file so I can query over it. I can dump the library names to a file, but I had to produce a listing as well so I can get the number...

    Rrbond07440 pointsBadges:
  • PTF installation

    Installed latest CUM PTF on V7R2 machine. Once PTF was done, restarted system through HMC. Now, restart operation is stuck in C20081FF status (waiting to receive the continue acknowledgement from System Licensed Internal Code). Now, the system license also expired. Hence, have requested license...

    sri8707165 pointsBadges:
  • How to update server DB file from web browser?

    We have a web page served directly off our IBMi system (out of the IFS). We want users to be able to maintain data from there (equivalent to green screen work-with & maintenance, but in a browser). I've tried looking for examples of how to update a database from JavaScript but they don't make...

    GregManzo2,315 pointsBadges:
  • How to disable auto audentity of a DB2/400 table

    Hello, For a migration data project (from SQL/Server to DB2/400), we need to disable the auto identifiers of a DB2/400 table. On SQL Server, the equivalent command is "set identity_insert MyTable off". Thank you in advance JC Cherid

    TheWorldAsGarp5 pointsBadges:
  • Accessing IBM MQ via a batch job running on an iASP

    I have an IBM i batch job BATCH1 that is running under a user profile PRF1 with an independent ASP IASP1 defined in the job description JOBD1 used by PRF1. BATCH1 is running under commitment control, *JOB scoped. I have a queue manager configured in *SYSBAS (QMGR library in *SYSBAS). I am getting...

    Jpjawili165 pointsBadges:
  • Writing a record to a physical file from CL

    Can I write a record to a physical file from CL? Once I do a test on a record, and before I delete the record, I wanted to write it to a physical file so later I can query over it to list what records were deleted.

    Rrbond07440 pointsBadges:
  • RPG SQL Nomain Module with DSPF

    I have Cycle Program with embedded SQL that updates table using display file. What do I have to do to create a module, so it will be compiled to *PGM object?

    FlashSmile5 pointsBadges:
  • Convert MSG file types into PDF or Word doc

    Is there any way to convert these type files into a PDF or Word DOC, since the person receiving the file does not have MS outlook

    clifton125 pointsBadges:
  • Status of a receiver in AS/400

    When I do command WRKJRNA QAUDJRN  then Shift+F3 it will display the "Work with receiver directory". Under the Status column it will list as SAVED, ONLINE, PARTIAL or ATTACHED. Does anyone know what IBM file where I can grab that field value? I want to do a test on it for the SAVED status and...

    Rrbond07440 pointsBadges:
  • SFTP enabled on AS/400 by default or not?

    Hello guys, so reading through a bunch of posts and google searches. Am I correct in understanding that the AS/400 system cannot run an FTP to connect to SFTP without any 3rd party add-ons? I really appreciate the help!

    bp01442105 pointsBadges:
  • License Keys on the AS/400

    At what level of OS/400 did license keys become mandatory?

    Rrbond07440 pointsBadges:
  • COBOL/400 report generation

    Regarding report generation, how can I skip remaining lines in Page 1 and print the other report in Page 2 in COBOL/400?

    Mujtabahussain5 pointsBadges:
  • AS400 Disk space

    AS400 Disk space I’ve just inherited the responsibility for a couple of old AS400 (model 510, OS V4R5) which are out of support and although I spent many years supporting AS400 I’ve not touched them in the last 6 years and I have a little problem with them. The problem is the system ASP is...

    Dazzaleeuk55 pointsBadges:
  • Turnover in AS/400

    How to create a user worklist? How to add objects to worklist? How to check out the objects? Which option we can use to modify source? How to compile the source and creating their objects? How we can create form to add source/objects. Once the sources/objects are added to form we need to run the...

    6r1,955 pointsBadges:
  • CL program to calculate 31 days less than system date

    I want to write a CL program that will calculate 31 days less than the system date. If a journal receiver is 31 days older than the system date I want to delete it. I already have the logic in another program to also test on whether or not commands SAVCHGOBJ and SAVLIB were used. I normally use...

    Rrbond07440 pointsBadges:
  • AS/400 Date Calculation

    We run several schedules based on the day - Daily schedule for M-Th, weekly schedule on Friday, then monthly on Last Business Day of the month. The problem we have is in the test environments, the programmers like to advance cycle dates. So we have to remember to check the date to determine type of...

    JMatthews5040 pointsBadges:
  • Ability to perform AS/400 file transfers in batch

    Is there a way to perform AS/400 file transfers in bathc using client access? The STRPCCMD can only be run interactively, but I need a way to schedule a job to run daily which will transfer files from the AS/400 converting it to CSV format on a PC based server. I am open to any other ways to...

    TOMCHM0 pointsBadges:
  • Upload Excel multiple sheets to AS/400

    I want to upload Excel multiple sheet to AS/400 by batch program but program upload first sheet only, not upload sheet remaining.

    supawichc25 pointsBadges:
  • Adding disk drive to AS/400 9406-520

    I'm looking for the requirements for adding 2 ,#4326, 35.1 GB disk units to my AS/400. I have the open slots and I need to know if I can user install these units. The unit is RAID 5 DASD.

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

Thanks! We'll email you when relevant content is added and updated.

Following