• External DB2 Database link/trigger

    In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

    r.otto810 pointsBadges:
  • How to calculate diff in time of two diff time stamp

    I have a table in that two fields stores the value of time stamp for eg 2009-12-10-20.00.26.424000 - DQ1CREATED 2009-12-10-20.00.26.860000-DQ2CREATED these two fields should be compared such that if there is a diff of 5 mins I need to get an alert as well as if any one of the field is blank I need...

    PrashanthR0750 pointsBadges:
  • Declare variables in RPGLE program

    How will we declare variables in an RPGLE program which have the same field names of a file that is declared in the PF?

    vasanthisrini10 pointsBadges:
  • Can I backup to disk with BRMS?

    Can I backup to disk with BRMS?

    Webdevyahoocom5 pointsBadges:
  • AS/400-DB2/400

    I have a file (customer) that have 50 records. How we can select the 34th record with out using rrn() and fetch. Would you please help me with the query.

    chowas400260 pointsBadges:
  • How to login if QSECOFR password is lost

    I am new in AS/400 Administration so I wanna learn more things. Please suggest me how I will be able to login on the system if my QSECOFR password is lost. Also, what are the best books which are available online to learn about LPAR, OS upgradation and AS/400 performance monitoring and resolving...

    JennyMack4,280 pointsBadges:
  • Convert iSeries Character set in VB

    I am creating a VBA macro in an Excel spreadsheet to download selected data from an iSeries database. Running into an issue with character set. I don't understand VB well enough yet and have not had success w/ google in resolving this. I appear to be getting the data, but a lot of the fields are...

    azohawk610 pointsBadges:
  • Creating a PDF from multiple spool files

    I have a project where multiple spool files are created. The users want to view each spool file to determine which ones they want to keep. After viewing and deleting the unwanted spool files they want to create a PDF file to send. I have found ways of converting spool files to PDF right after they...

    lgronewold10 pointsBadges:
  • Monitor for qbatch job error

    How can I monitor for a qbatch job with an error?

    TommyBSC5 pointsBadges:
  • Date in COBOL/400

    I have a character field having length 10 charsm say DATE1 PIC X(10). Now I want to check if the date in this field is in format MM/DD/YYY then how can I check it? and if I want to add 60 days to this date then how to do it in CBL program?

    Vids295 pointsBadges:
  • IMS drivers / clients needed on AS/400

    What client or driver pieces are required on the AS/400 to connect to and communicate to an IMS database on the mainframe.

    Jrsurber5 pointsBadges:
  • call php script from CL – slow

    Hello, I try to call a php-script on our 520. CHGVAR     VAR(&CMM) +                                                VALUE('/usr/local/Zend/Core/bin/php +                    /www/zendcore/htdocs/test.php') QSH       ...

    Jogisarge30 pointsBadges:
  • IBM – iseries access for windows running an Automated Macro via Scheduled Tasks

    I am trying to create a schedule job to run at night to process my Pharmacy Dayend by executing a .ws session then running a macro. Although I was able to execute the iSeries Access program to come up, I was unable to make the macro run itself using the Scheduled Task from Windows XP professional....

    GGOMEZ10 pointsBadges:
  • API to get the GMT date and time in AS/400 system

    Hi, I need to get the GMT date and time from the AS/400 system. Is their any API available to retrieve the GMT date and Time. Please suggest the way to retrieve the date and time. It's very urgent.

    As400pgmmer305 pointsBadges:
  • AS/400 emulator to download in Windows 7

    Earlier I was downloading from Mochasoft.dk site. Now a days when I am trying to download there is nothing available for free? Can any one give me links to download at free of cost? I was creating an User from as400profis.de site. Now a days it is also not available. How can I create an user to...

    Abdulonas400125 pointsBadges:
  • AS/400 (ALDON)

    Can anyone please tell me how to add a Trigger program to a physical file in ALDON and promote it? ALDON is change management tool.

    C.naveen09140 pointsBadges:
  • IBM i certifications

    Hi, Can anybody please list out the types of certifications one can do on IBM i including the administration and development. I am experienced over 5 yrs in development and a novice in administration. Hence to move my career ahead and as an administrator too I want do some certifications. Please...

    ten20081,150 pointsBadges:
  • Free Format RPGIV

    Hello everybody, I am looking for complete reference for free format RPGIV, as I am new to free format. Please provide me a link/PDF for the same. Thanks, Samul

    Samule400160 pointsBadges:
  • Command line virus scanning program suggestions

    What command line virus scanning program can you recommend for a application? We want to scan any files uploaded using our new programs interface. What is free and good? It needs to be able to integrate in a .Net application.

    Troubleshooter24755 pointsBadges:
  • How to capture screen continuously for Rumba AS/400?

    I can capture each screen by clicking on option -> capture screen. Can I capture all displays or assign a short-cut key to capture the current screen?

    Wchang7215 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