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...
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...
30 pts.
Difference between ODBC and JDBC?
I'm writing a java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400...
I'm writing a java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400...
understanding and detecting sql performance situation with abnormal 400 shutdown
Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...
Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...
data base files
How are the negative values in the packed fields are stored in the PF? How to enter negative data in those fields?
How are the negative values in the packed fields are stored in the PF? How to enter negative data in those fields?
Windows ODBC driver for IBM DB2 database
I'm looking for a windows ODBC driver to access a DB2 database on the AS400. Does anyone have a link or suggested vendors?
I'm looking for a windows ODBC driver to access a DB2 database on the AS400. Does anyone have a link or suggested vendors?
Transform DB2 to XML from AS/400
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client's web server. I have looked at IBM's XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something...
AS/400 data mapping with CPYFRMIMPF
We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new...
We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new...
Conversion of SQL Server 2000 to iSeries DB2 V6R1
Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.
Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.
Is a DB on AS400 always DB2 ?
Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely
Please, I want to know if possible : when we speak about a data base on AS400, exactly a data base used by RPG, is it allways a DB2 database ? Is AS400 a database. Is it the same as DB2/400 ? I hope to be clear enough. Sincerely
How to check DB2 version in AS/400 green screen command line?
How to check db2 version in as400 green screen command line?
How to check db2 version in as400 green screen command line?
CPYTOIMPF --FLDDLM(*TAB) QUESTION
Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command I am...
Our OS is V5R4. I am using cpytoimpf to import .txt file (tab delimited) to DB2 physical file. If I remove the FLDDLM(*TAB), I get all the records but the fields have overlapped data. If I use the (*TAB) I get one record and errors on the remaining copy.(error code 7) Here is the command I am...
In DB2 when a select statement is executed, it is taking lot of time and the table is being locked.
In DB2 when I'm giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you in advance.
In DB2 when I'm giving a select statement its taking lot of time, the reason is like the table is a very huge table. As a result some times it is locking the table. Can any one help me for executing the select query with any option which would not lock the table. Thank you in advance.
Mainframe batch DB2 table I-O monitoring
Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo
Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo
db2/400
I need add a field in existing Physical file without imacting any thing file? i know CHGPF command but i am not sure about which parameter needs to be update... Please advice...
I need add a field in existing Physical file without imacting any thing file? i know CHGPF command but i am not sure about which parameter needs to be update... Please advice...
How to Determine Database Access on AS/400
I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.
I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.
DB2 SQL Confusion
I am failing to understand why the following won't work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don't...
I am failing to understand why the following won't work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don't...
