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?
Answer Question
| September 27, 2010 5:40 AM
DB2/400, iSeries database, ODBC, 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?
Answer Question
| September 27, 2010 5:40 AM
DB2/400, iSeries database, ODBC, QZDASOINIT
What is Referential Integrity in DB2/400?
What is referential integrity in DB2/400? & What is field reference file in DB2/400?
Answer Question
| August 31, 2010 3:37 AM
Data quality, DB2/400, Referential integrity
What is referential integrity in DB2/400? & What is field reference file in DB2/400?
Answer Question
| August 31, 2010 3:37 AM
Data quality, DB2/400, Referential integrity
Current Date
IN DB2/400 IS THERE FIELD LEVEL KEYWORD FOR SHOWING CURRENT DATE?
Answer Question
| August 10, 2010 6:45 AM
DB2/400, Field-Level keywords
IN DB2/400 IS THERE FIELD LEVEL KEYWORD FOR SHOWING CURRENT DATE?
Answer Question
| August 10, 2010 6:45 AM
DB2/400, Field-Level keywords
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??
Answer Question
| July 31, 2010 3:09 PM
DB2, 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??
Answer Question
| July 31, 2010 3:09 PM
DB2, DB2/400
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 exitString = “No”; PrintWriter print = new PrintWriter(new FileWriter(path)); [...]
Answer Question
| July 30, 2010 6:33 AM
CL, DB2/400, Java classes
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 exitString = “No”; PrintWriter print = new PrintWriter(new FileWriter(path)); [...]
Answer Question
| July 30, 2010 6:33 AM
CL, DB2/400, Java classes
DB2/400
what is the difference between logical file and View in DB2/400
Answer Question
| May 20, 2011 8:03 AM
DB2/400, Logical File
what is the difference between logical file and View in DB2/400
Answer Question
| May 20, 2011 8:03 AM
DB2/400, Logical File
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: I’m using Mocha TN5250 trial version Please [...]
Answer Question
| September 2, 2008 2:26 PM
AS/400 errors, 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: I’m using Mocha TN5250 trial version Please [...]
Answer Question
| September 2, 2008 2:26 PM
AS/400 errors, DB2/400
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. Following is the error stack [...]
Answer Question
| August 22, 2008 6:14 AM
Database programming, DB2/400, Isolation level
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. Following is the error stack [...]
Answer Question
| August 22, 2008 6:14 AM
Database programming, DB2/400, Isolation level
Obtain member list RPG 400
can any body tell me is there any opcode to obtain a list of members in a file
Answer Question
| July 29, 2008 12:17 PM
CL/400, DB2/400, RPG/400
can any body tell me is there any opcode to obtain a list of members in a file
Answer Question
| July 29, 2008 12:17 PM
CL/400, DB2/400, RPG/400
AS/400,db2/400,rpg/400
is there any perfect method to make externally described file fields available to a program
Answer Question
| May 7, 2010 5:57 AM
DB2/400, RPG, RPG/400
is there any perfect method to make externally described file fields available to a program
Answer Question
| May 7, 2010 5:57 AM
DB2/400, RPG, RPG/400
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 any diference in performance between internal vs external stored [...]
Answer Question
| May 4, 2010 2:18 AM
C#, Database performance and tuning, DB2/400, SQL stored procedures, Stored Procedures
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 any diference in performance between internal vs external stored [...]
Answer Question
| May 4, 2010 2:18 AM
C#, Database performance and tuning, DB2/400, SQL stored procedures, Stored Procedures
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 AS400 were replaced by such a user [...]
Answer Question
| May 7, 2010 10:00 AM
AS/400, Database permissions, DB2 administration, DB2/400, 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 AS400 were replaced by such a user [...]
Answer Question
| May 7, 2010 10:00 AM
AS/400, Database permissions, DB2 administration, DB2/400, ODBC
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 have primary [...]
Answer Question
| July 1, 2008 4:20 PM
AS/400, DB2/400, GeneXus, Progress/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 have primary [...]
Answer Question
| July 1, 2008 4:20 PM
AS/400, DB2/400, GeneXus, Progress/400
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 SLSBIGD.R1SSID,SLSBIGD.prdistynm,SLSBIGD.prdiclrd,SLSBIGD.prdiclrnm, sum(SLSBIGD.MNET$) [...]
Answer Question
| May 30, 2008 2:31 PM
Date format, Date variable, DB2/400, SQL Query, SQL Subselect
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 SLSBIGD.R1SSID,SLSBIGD.prdistynm,SLSBIGD.prdiclrd,SLSBIGD.prdiclrnm, sum(SLSBIGD.MNET$) [...]
Answer Question
| May 30, 2008 2:31 PM
Date format, Date variable, DB2/400, SQL Query, SQL Subselect
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 and MAX_P00002 but no [...]
Answer Question
| October 30, 2009 8:33 PM
Database, DB2/400
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 and MAX_P00002 but no [...]
Answer Question
| October 30, 2009 8:33 PM
Database, DB2/400
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 this and my [...]
Answer Question
| July 15, 2011 7:39 PM
AS/400, AS/400 DB2, DB2/400, SQL
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 this and my [...]
Answer Question
| July 15, 2011 7:39 PM
AS/400, AS/400 DB2, DB2/400, SQL
Having trouble with DB2/400 UDF returning a table.
I’ve written a test RPGLE program (not a service program) to return a table that for testing puposes I’m returning 1 row and 1 hard coded return column that is defined as varchar. I’m building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I waited about 30seconds [...]
Answer Question
| October 30, 2009 12:25 AM
DB2/400, RPGLE, SQL, Table Functions, UDF
I’ve written a test RPGLE program (not a service program) to return a table that for testing puposes I’m returning 1 row and 1 hard coded return column that is defined as varchar. I’m building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I waited about 30seconds [...]
Answer Question
| October 30, 2009 12:25 AM
DB2/400, RPGLE, SQL, Table Functions, UDF
Assign default values to SQL VIEW columns
I’m trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I’ve tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.
Answer Question
| March 9, 2010 11:57 AM
DB2/400, Oracle Views, SQL
I’m trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I’ve tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.
Answer Question
| March 9, 2010 11:57 AM
DB2/400, Oracle Views, SQL
