AS400 ODBC
HiOur 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...
View Answer
| Jun 30 2008 10:00 AM GMT
| asked by
Pgsdeb
AS/400, DB2 Administration, DB2/400
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...
View Answer
| Jun 22 2008 4:20 PM GMT
| asked by
SILVARB
AS/400, Progress/400, GeneXus
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...
View Answer
| May 30 2008 2:31 PM GMT
| asked by
MarcGreen
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...
Answer Question
| Apr 29 2008 8:33 PM GMT
| asked by
RodVerity
DB2/400, Database
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...
Answer Question
| Apr 23 2008 7:39 PM GMT
| asked by
Mgemmill
AS/400, 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...
Answer Question
| Mar 4 2008 0:25 AM GMT
| asked by
Dwk001
DB2/400, UDF, Table Functions
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.
View Answer
| Jan 5 2008 11:57 AM GMT
| asked by
Tgee
SQL, Oracle Views, DB2/400
