Recent IT Questions

1 - 9 of 9
<<PREVIOUS 1 NEXT>>

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


1 - 9 of 9
<<PREVIOUS 1 NEXT>>