• Microsoft ASP(iSerios Access ODBC) list all libraries for a particular user within AS400

    how do i list all the libraries that a user has access to. the user will be login in thru a ASP (iSerios Access ODBC Driver). Is there a "table" i can "SELECT" from and/or a "command" that i can execute. and subsequently i only want to display all the "tables" that the users has created in those...

    Rafael5830 pointsBadges:
  • Triggers and commitment control

    We are having problems finding a way to get trigger programs included in the needed commitment control boundary. The process starts with a JDBC connection to the 400, and via Java executing processes (SQL) that make changes to the DB files. The files are triggered, and any of the files the trigger...

    BoomerSooner0 pointsBadges:
  • Check Connection established on a TCP port from a program?

    Is there any way to get the status of a TCP port within a program? We need to monitor a specific port to ensure that a communications link is established, and then send a page to the analyst on call when the communications link goes down. I can view the information with NETSTAT 3 (WRKTCPSTS *CNN),...

    Tagrove0 pointsBadges:
  • HTTP Server config

    Cannot get iSeries Tasks Page in browser with -> http://xxx.xxx.xxx.xxx:2001 Have run STRTCPSVR SERVER(*HTTP) HTTPSVR(*ADMIN) from command line. Viewed the process thru WRKACTJOB - the job ends after few seconds. OS version V5R1, please help.

    ObjectAuthority0 pointsBadges:
  • Best way to clean out iSeries before selling

    Deb and her group are installing a new iSeries. Before selling the old one, they would like to remove software and programs from from it. What is the best way to do that? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson490 pointsBadges:
  • Automatic email notifications from iSeries

    Nagi needs to write a code on his iSeries 870 to send a notifications to his e-mail, such as server rebooting, jobs not started or need reply, etc. He's a Windows guy, and doesn't know where to start. Can someone help him with the code and possibly send him steps on how to write it and where and...

    MichelleDavidson490 pointsBadges:
  • Convert iSeries spool file to PC data file

    Mario needs to convert an iSeries-AS/400 file to a PC data file. Can anyone advise him? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson490 pointsBadges:
  • Variable length fields in RPG IV

    Ed is wondering, "If you don't yet use free-format RPG, is there a way to utilize variable length fields in RPG IV?" What do you think? Is it possible? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson490 pointsBadges:
  • What is signature checking?

    Nirmala is trying to figure out what signature checking is and when to use it. Can you offer some advice? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson490 pointsBadges:
  • Temp files in IFS

    I keep finding temp files in the IFS(files starting with ~). The only way I can delete the files is through iseries navigator. My question are: (1) How can I prevent these files from being created and (2) is there an automated way to delete them?

    Oldrpger1235 pointsBadges:
  • How to convert characters to numeric in CSV file?

    Roy wrote the editors of Search400.com recently, looking for help with a CSV file. He said: "I'm using CRTCSVF to create a csv file. My problem is that my customer number is alphanumeric, but they want it to be numeric (without the quotes) in the CSV file and with the leading zeros intact. "Is...

    MichelleDavidson490 pointsBadges:
  • Downloading Files Using Client Access In CSV Formats

    I am downloading a data file using Client Access. I would like to create the file in the CSV format is there a to include the column headings in the data file?

    SF49ERS25 pointsBadges:
  • Join our ITKnowledgeExchange.com LinkedIn group

    We have created an ITKnowledgeExchange.com LinkedIn Group If you are a member of LinkedIn come and join the group. You will be able to continue the discussion or post questions that we will post onto the site. Thanks Sean Community Manager

    ITKE983,460 pointsBadges:
  • PCI Compliance in an iSeries Network Environment – Request for advice and direction

    We’re trying to comply with the Payment Card Industry’s PCI DSS requirements. We have a home-grown ERP system running on an IBM iSeries computer that stores and processes credit cards taken over the phone and by mail. We also have a website hosted on another iSeries computer. The site uses a...

    Pmirchin5 pointsBadges:
  • The IT Blog Top 10: Nov. 12, 2009

    10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...

    Michael Morisy8,598 pointsBadges:
  • IFS commands

    Hi can anybody give me the location of all the IFS related commands on as/400 plz. Thanks in advance...

    ten20081,150 pointsBadges:
  • How to install a digital certificate

    Has anyone installed a digital certificate on an iSeries lately?  For example, a certificate from VeriSign or GoDaddy.  Can you give me any pointers? After the certificate is installed we need to export it to a Microsoft ISA server which will be the front door for users who need to use our AS/400...

    WoodEngineer7,005 pointsBadges:
  • AS/400 cloning

    Currently AS/400 version V5R3 is used in one region. We need to clone this to other region where the version will be V5R6. May I know the hardware recommendations and other requirements to fulfil this task?

    SArunkumar50 pointsBadges:
  • online course material for as400

    I am a beginner in RPGILE can somebody give me some online links to study  materials ,which covers  programming with sda ,rlu,seu tools of as400

    Peraj55 pointsBadges:
  • AS400 to the Excel

    I need to split the city and state. I can do it once the results are in Excel but I would like to do it on the way from the AS400 to the Excel spreadsheet.

    Dbatank0 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