ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Search Result

Collapse
48 results in 0.0586 seconds.
Keywords
Members
Tags
  •  

  • umpireprgmr
    started a topic query multiple databases on multiple servers
    in SQL

    query multiple databases on multiple servers

    My select attempts to return all records from the QA system which are not in the Dev system.

    SELECT QA.updated3,QA.acctid,QA.timestamp,QA.postingseq
    FROM AS400.ABODATA.d3p004 PR
    LEFT OUTER JOIN as400dev.abolib.d3p004 DV ON
    QA.updated3 = DV.updated3 AND...
    See more | Go to post

  • jonnyoffside
    started a topic Mimix Replication SLA Reporting

    Mimix Replication SLA Reporting

    I have a contracted SLA for Mimix replication but struggling to come up with a way to measure that the source and target systems are up to date. Mimix audits could be an option but the systems are still quite new and setlling down so we always have some errors picked up.

    Any ideas?
    See more | Go to post

  • dwr0211400
    started a topic Record level access iSeries <-> pSeries

    Record level access iSeries <-> pSeries

    Is there a standard way for an RPG program running on a V6R1 iSeries to pass a key value to a pSeries machine and then pSeries will return a record back to iSeries RPG program.
    The pSeries will need to take the key value and sum dollar amounts and pass back at least two summed values to iSeries....
    See more | Go to post

  • Looking for an alternate Scheduling and monitoring tool for iSeries

    Folks,

    Our shop is looking for an alternative solution for job scheduling and system monitoring . Currently we are using the Halcyon software which has both the provision(job schedule & sys monitoring) . I know there are a few vendors who has applications with both these features...
    See more | Go to post

  • abercrombieande
    started a topic Indexes & Stat Maintenance
    in DB2

    Indexes & Stat Maintenance

    I am looking for a good whitepaper on Indexes and Stats for V7.1. Coming from SQL Server I am use to checking the fragmention level and reorganizing or rebuilding the indexes and also running stats. I am at a lost for how the iSeries handles index maintenance and how to check fragmentation levels....
    See more | Go to post

  • abercrombieande
    started a topic Xml functions
    in SQL

    Xml functions

    What am I doing wrong with XMLCAST? I get "S1000(-20338)[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQ20338 - The data type of the XMLCAST specification must be XML. (1.55 secs)". This has to be something easy that I am missing, XMLGROUP returns an XML datatype so I don't get it....
    See more | Go to post

  • abercrombieande
    started a topic Function Job Log

    Function Job Log

    I have this function that checks if a date is valid. Every time a date is invalid the sql exception occurs and fills my job log. Any ideas on how to keep this out of the job log?


    CREATE FUNCTION testyt.ISDATE (
    @DATE VARCHAR(10) )
    RETURNS CHAR(1)
    LANGUAGE...
    See more | Go to post

  • abercrombieande
    started a topic Estimating Size
    in DB2

    Estimating Size

    I have a few tables that I would like to estimate the size savings on if I drop a few columns. What is the best way to estimate the savings?
    See more | Go to post

  • VivekSharma
    started a topic Decryption on iSeries

    Decryption on iSeries

    Hi

    I have a requirement to decrypt some field on web browser and direct it to as/400.

    Do we have any way in which we can decrypt the text on iSeries.

    Thanks,
    Vivek Sharma
    See more | Go to post

  • Data Area (Decimal) - Read/Write/Increment for Unique Running Number

    Hi guys,

    I have this assignment that required me to do the followings,
    • To retrieve a Next Transaction ID from Data Area (Decimal)
    • To use that ID in a SQL Insert Statement on a specific table on the same system
    • For a successful insert (committed), the value of Transaction
    ...
    See more | Go to post

  • abercrombieande
    started a topic Program Between Systems Runs Slow

    Program Between Systems Runs Slow

    I have two iSeries sytsems A & B both on V7 and one SQLRPGLE program. The program is mostly SQL. When it is compiled on system A and runs on A it completes in a matter of minutes. When it is compiled on system A and runs on B it appears to be stuck on a SQL statement. It sits there for hours and...
    See more | Go to post

  • abercrombieande
    started a topic Contraint does not have a matching parent key
    in DB2

    Contraint does not have a matching parent key

    I have two table as defined below

    TABLE 1
    --COLA
    --COLB
    --COLC

    TABLE 2
    --COLA
    --COLB
    --COLC

    Table 1 COLA is autonumber.
    When I try to run
    Code:
    alter table TABLE2 add contraint CSTID foreign key
    ...
    See more | Go to post

  • John Andersen
    started a topic 4 Tips For Unlocking The 400 Database

    4 Tips For Unlocking The 400 Database

    At the core of every AS/400, iSeries and IBM i is the DB2 database tightly integrated into the operating system. If you work with the 400 for any length of time eventually you will end up diving into the data stored within the database tables, usually to update a field correcting inaccuracies or other...
    See more | Go to post

  • senmalar
    started a topic emulator for practice

    emulator for practice

    I am new to AS400.So i need to practise a lot at home.Can anyone suggest me free emulator to work in AS400,RPGLE etc.
    See more | Go to post

  • ritatech
    started a topic AS/400 Computer Operator - Tampa, Florida

    AS/400 Computer Operator - Tampa, Florida

    Status: Full-time
    Hours: 4pm - 12am
    Start date: ASAP

    Local candidates will only be considered for this position.

    Will perform routine operation functions which include submitting jobs, monitoring messages, labeling/storing tapes, managing job/output queues,...
    See more | Go to post

Our Sponsors

Collapse
Working...
X