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
DB2 indexes and Crystal Reports
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Answer Question
| Apr 22 2008 10:31 AM GMT
| asked by
AJ52
DB2, Indexes, Crystal Reports 8
SQL COMMAND to see table relation
Which command I can use to get the relation between all tables in a system application?
View Answer
| Apr 18 2008 8:23 PM GMT
| asked by
Arielmx
AS/400 DB2, SQL
Crystal Report Problem in VB6
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0.When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use...
Answer Question
| Apr 14 2008 6:49 AM GMT
| asked by
Mr. SEA
Crystal Reports, AS/400 DB2, VB6
LogOnServer Problem in Crystal Report
I am using VB6 with back ground Database DB2 AS400 iSerices and Crystal Report 9.0.When I Show the Report Its prompt me to enter password. I have tried to find the solution and found some thing about LogOnServer but every example is there for Crystal Report 7,8, and 8.5. I have tried to use...
Answer Question
| Apr 8 2008 11:35 AM GMT
| asked by
Mr. SEA
Crystal Reports, AS/400 DB2, VB6
Date Function AS400
I need the Date function of DB2.Actually I want to subtract the Date however I have used the follwoing:select current date -1 from sysibm.sysdummay1;But It occures an error.Is there any way to subtract the date in the query.I am using iSeries DB2 AS400
View Answer
| Apr 4 2008 10:23 AM GMT
| asked by
Mr. SEA
AS/400 DB2, iSeries development
How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess
We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess.Are there any way to list those users from the accounting journal or audit journal?
View Answer
| Apr 3 2008 1:23 AM GMT
| asked by
ISHII
AS/400 DB2, iSeries database, iSeries Access
Data transfer from DB2 (AS400) TO SQL SERVER 2005
I want to transfer a data from a DB2 file to a SQL Server file.I do not want to buy a software that do it.I want to do it by my self (perhaps using ODBC)Thinks all for help.Abdou
View Answer
| Apr 1 2008 3:03 PM GMT
| asked by
HABDOU
Data transfer, AS/400, DB2
DB2 to Text File Conversion and Transfer
I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??
View Answer
| Mar 1 2008 2:50 PM GMT
| asked by
Gvdsswami
DB2 Implementation, AS/400 DB2, DB2
