• 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:
  • Version of DB2 running on AS/400

    I need to know the version of DB2 runing on AS400, do you know how can I to get it?

    GeLaLo10 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:
  • Releasing lock in AS/400

    how to find which record is locked and who locked that record.how to release the lock by ourselves.please explain in detail.i'm new to as/400.

    Kaly470 pointsBadges:
  • Prevent record lock scenario with AS/400 ?

    Suppose 2 users are accesssing the same record in a file.User 1 tried to update the record and while doing so he did not log-off from his update screen,while the user tries to do inquiry on that same record. As a result there will be a record lock situation.How to prevent this scenario ? i need...

    Supriyoas400165 pointsBadges:
  • File Level identifier Vs. Record Format Level Identifier vs. Member level identifier

    Hi,   Please let me know the difference b/n File Level identifier, Record Format Level Identifier and Member level identifier with an example

    AS400B20 pointsBadges:
  • using %char and removing leading blanks

    I have a 6 pos serial number, ex(000022) that I need to CAT onto a qualifier of UN. so the final result should be UN22. I would like to do this using %char. I thought I could do it in one line, but I am having issues with not being able to remove the leading blanks. My result ends up being...

    Dobie80 pointsBadges:
  • How to Import Data from a .CSV or .XLSX file to an AS400 file?

    I want to import the data of a .CSV or .XLSX file to a AS400 file. How can I accomplish this? Also, the .CSV/.XLSX file has two columns that I would like to keep in the AS400 File. Any inputs would be really appreciated.

    Jorame5 pointsBadges:
  • I need help with DSPF…

    Hi everybody, i try explain my need. I have one RPG pgm with several DSPF, and for this work well, i have a OVRDSPF. My problem is when other people make any changes in one DSPF we have a level check, i know that, but because of this i need a idea for make an ALERT inside of DSPF source code in...

    BUG68235 pointsBadges:
  • How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess

    We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess. Are there any way to list those users from the accounting journal or audit journal?

    ISHII5 pointsBadges:
  • Isolation level in iseries DB2

    How to set isolation level in iseries DB2? please reply.

    ORS5 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