• Production support team in AS400

    In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project. 

    Kaly470 pointsBadges:
  • DB2 Tuning link or manual for AS400

    Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don't know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.

    Mariodlg2,790 pointsBadges:
  • SQL Update Set: Higlight Customers without Invoices, Update and join Tables?

    Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to "not active" in the customer table that did not receive invoices since 2008. I can "Select" the corresponding records in the customer table...

    Cavallino30 pointsBadges:
  • CPF9999

    What CPF9999 does?

    Kar425 pointsBadges:
  • AS400 – Physical Files

    Hi I have some qusetion in AS400 How can we convert rows into columns and columns into row for a PF in AS400. Please send me the coding for this requirement. Thanks

    iiiiiiiiiiiii335 pointsBadges:
  • Boomi using JDBC to access DB2 in AS/400

    Want to use Boomi to access JDE DB2 What do I need to define on AS400?

    APMMRE5 pointsBadges:
  • AS/400 Error: RRN() does not start from 1, but starts from number of rows deleted + 1 db2, v5r4m0

    i'm trying to populate a field in A table with the row number using rrn(tablename). the first time if i insert 4 rows then the id is 1,2,3,4 as required. if i delete the rows and try the insert again the rrn() does not return the same so 1,2,3,4 but returns 5,6,7,8 (that is the nr of rows deleted +...

    Elai45 pointsBadges:
  • create xml content from as/400 db2

    Hi, wonder if these xml functions (XML2CLOB, XMLELEMENT, XMLATTRIBUTES, XMLAGG, ...) can be used in db/400 -- as/400 V6R1M0, if yes, any sample code? of not what else I can use to generate xml content from db2 queries? Any answer is appreciated.

    Jluo1235 pointsBadges:
  • Migrating from AS/400 to SQL Server

    We have an AS/400 that no one in our agency knows anything about except that it has been running for a few years and the data needs to be removed from the AS/400 to another platform, either DB2 or SQL Server. I have read that a SQL ssis package can be used to migrate the data - I need to know what...

    Dharder15 pointsBadges:
  • Responsibilities of DB2/400

    Hi, Being an AS/400 development/admin guy what are the roles and responsibilites of DB2/400(DB/400 ?) on daily basis.  What could be the  maintenance activities. I'm just curious about to know...waiting for your valuable comments..    

    qmaster1,675 pointsBadges:
  • DB2 physical file

    how we can create View with Key to more than one PF in Diffrance Lib exsample LIB                         PF File Name ============================= Lib1                         Custom             (( for HeadOffice ))...

    Hodish40635 pointsBadges:
  • Jreport problem – floating point literal

    hi! I'm new here! I have a report and this is connect to db2/as400. When I compile i have the next error "[SQL0410] Floating point literal 2.00805121133377101E18 not valid. Cause...." I don't know what is happenning. The query I run in other program and this is right, so I think is something with...

    LouIT5 pointsBadges:
  • How i can create LF View To More than One Library?

    how i can create LF View To More than One Lib.

    Hodish5 pointsBadges:
  • Enherit column attributes when ALTERing column

    I have this: 1. A field-reference table (fieldref): CREATE TABLE mylib/fieldref ( A CHAR (10) NOT NULL WITH DEFAULT, B CHAR (10) NOT NULL WITH DEFAULT, C DECIMAL (7 , 5) NOT NULL WITH DEFAULT, PRIMARY KEY (A)) 2. A data table (myfile) created on the basis of the above fieldref table: CREATE TABLE...

    DanTheDane2,555 pointsBadges:
  • iSeries Update Values in a Table Based on Values in Two Tables.

    I want to update a Client Category Code in the Client_Table where the Client has a specific Country Code AND and the Clients VAT No is Blank, Which is in The Client_Account Table in another Library. The Matched Records are [LIBRARY1]FILE1.CLLDRS and [LIBRARY2]FILE2.ADLDRS So Update...

    Sconna2325 pointsBadges:
  • SNDDST to include User Name with the Error

      I would also like to get the USER Name that has the MSGW  in this CL... How can I do that?   SNDDST TYPE(*LMSG) TOINTNET(('user@tmyCompany.com') DSTD('***- Message in ACTIVE JOBS -***') LONGMSG('Message waiting in Active Jobs ') IMPORTANCE(*HIGH) PTY(*HIGH)

    Jaymz69765 pointsBadges:
  • Finiding the PF name

    Hi Guys, I am stuck in here to find the physical file name, I know the alternate name of the PF, is there any procedure to find out the original PF name using the alternate name? Please help

    vssagar70 pointsBadges:
  • Recovery of PF data from journal

    Hi All, Consider the case, some one has accidentally deleted all records in a PF and that file is Journaled, Is it possible to recovery the records from receiver attached. if so, how can we do it?

    Kar425 pointsBadges:
  • How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    For example on an as/400 Data base file, some 10 indexes are created? How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    TNKR130 pointsBadges:
  • Update done in physical file which does not reflect in Logical file

    Hello All,   1.I need to know when an update happens to Physical file the updates should not reflect in the corresponding logical file. Please let me know what needs to be done for this.  2. How will we update a field in a physical nd not the whole record in RPG IV. Please explain with an...

    Ponsasikumar5 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