How can we automate the DB2/400 used in AS/400 through QTP?
We want to access the DB2/400 in AS/400 through QTP. So please can you give me reply how we can connect the DB2/400 through QTP? Actually we are not getting the database where stored in AS/400.
We want to access the DB2/400 in AS/400 through QTP. So please can you give me reply how we can connect the DB2/400 through QTP? Actually we are not getting the database where stored in AS/400.
5 pts.
Converting a varchar to a numberic in SQL query
How can we convert a varchar field to Numberic in a SQL Query in db2 400?
How can we convert a varchar field to Numberic in a SQL Query in db2 400?
DB2/400
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried...
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried...
RPG/400
Hello ,how can we Migrate fromcurrently running on UNISYS platform to AS/400 platform. Major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database
Hello ,how can we Migrate fromcurrently running on UNISYS platform to AS/400 platform. Major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database
job QZDASOINIT
My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?
My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?
What is Referential Integrity in DB2/400?
What is referential integrity in DB2/400? & What is field reference file in DB2/400?
What is referential integrity in DB2/400? & What is field reference file in DB2/400?
Create a view in DB2/400
I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??
I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??
How to create CL file from Java class
i m creating a .sh file on the fly from my java code to perform db2 export operation in the code given below. Can I do the same in as/400 to create a cl file on the fly . path = new File(batchfilepath+".sh"); path.delete(); path.createNewFile(); String...
i m creating a .sh file on the fly from my java code to perform db2 export operation in the code given below. Can I do the same in as/400 to create a cl file on the fly . path = new File(batchfilepath+".sh"); path.delete(); path.createNewFile(); String...
error in DB2/400
Hi, i created a physical file(named 'PHF1') and created a logical file(named 'LF1') in Source file(named 'MYSRC')..i complied those files and inserted data.. i wrote a query by STRSQL,that query is "SELECT * FROM LF1"...But i getting a error as "LF1 in *LIBL type *FILE not found" NOTE: ...
Hi, i created a physical file(named 'PHF1') and created a logical file(named 'LF1') in Source file(named 'MYSRC')..i complied those files and inserted data.. i wrote a query by STRSQL,that query is "SELECT * FROM LF1"...But i getting a error as "LF1 in *LIBL type *FILE not found" NOTE: ...
Setting isolation levels with hibernate and DB2/AS400
I am using hibernate with DB2/AS400. When I set any isoltion level other than '0' in the hibernate.cfg.xml and try to insert/update data in the table on DB2/AS400, The Exception '' could not update :" occurs. Update is succesful for isolation level 0. Please guide how this can be solved. ...
I am using hibernate with DB2/AS400. When I set any isoltion level other than '0' in the hibernate.cfg.xml and try to insert/update data in the table on DB2/AS400, The Exception '' could not update :" occurs. Update is succesful for isolation level 0. Please guide how this can be solved. ...
Obtain member list RPG 400
can any body tell me is there any opcode to obtain a list of members in a file
can any body tell me is there any opcode to obtain a list of members in a file
AS/400,db2/400,rpg/400
is there any perfect method to make externally described file fields available to a program
is there any perfect method to make externally described file fields available to a program
Internal vs Externa Stored Procedure Performance
Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...
Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...
AS400 ODBC
Hi Our company uses AS400 for our financial processing application. The users access the AS400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...
Hi Our company uses AS400 for our financial processing application. The users access the AS400 through an emulator. They also access the application database through ODBC. They extract the data to excel sheets to create certain reports for their own purpose. Recently, one the data base files in...
Progress/400 with DB2/400
Firstly I would like to thank to all that helped me on my doubt with AS/400. We migrated of Progress/400 version 9 for Progress/400 version 10, and now the access to the db2/400 is from ODBC. Can I improve the performance of AS/400 knowing that the tables generated by Genexus version 9 doesn't...
Firstly I would like to thank to all that helped me on my doubt with AS/400. We migrated of Progress/400 version 9 for Progress/400 version 10, and now the access to the db2/400 is from ODBC. Can I improve the performance of AS/400 knowing that the tables generated by Genexus version 9 doesn't...
iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd
Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...
Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...
Changing DB2 Short or Internal Names
We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001...
We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001...
String Aggregate Function
I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...
I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...
