• Logical File record deletion

    Can we delete a record through logical file and will it reflect in the physical file?

    Gopinath007760 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:
  • JDBC connection to DB2/400

    Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to...

    rajsubhyd105 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
  • DB2/400 – Why does each Physical File member has its own access path?

    why each physical file member has its own access path?

    Ashish8630 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.