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 to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative...

Starting from scratch, I plan to have 600 users with e-mail, file and print, and Internet services. I will also have 10 servers used as LAN, proxy, and database servers. Two departments will need sufficient bandwidth and access applications from an Oracle server. We are also going to expand to four...

Hi Group, I have a Physical file. It has 3 members, memb1, memb2 and memb3. In my cobol/400 program i need to access all the 3 members and put data into them. What is the select statement for the multimember PF? How to declare the file section for multi member PF? The COBOL/40o pgm should be...

i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc...) where it can cause one book to...

i use the following code to connect and i created DSN but its not getting connected... whats my fault can anyone help me?? Dim X As ADODB.Connection Dim RS As ADODB.Recordset Dim RS1 As ADODB.Recordset i am getting underlined error in adodb.connection, adodb.recordset i think there is some error in...

Sony isn''t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin's breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company's security has been compromised in the past, how did you respond and set...

How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for...

Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !

I have a DB for recording safety information. I have a form to document individual accidents. Each accident can cause multiple types of harm to multiple assets. In the accident form, I have a combobox where I can select a single asset and another where I can select its associated types of harm....

I am working with Domino designer 8.5 () and have a form that contains a field of type 'Names' that has the Choices set to 'Use View dialog for choices' (as there are a lot of entries to choice from I choice the view dialog to allow sorting and searching). The view that I use is constructed from 2...

This week's free IT book is written by one of IT Knowledge Exchange's very own members, Mrdenny. Securing SQL Server promises to help you "secure your SQL Server database so the outside world can't access your internal data." With Mrdenny's extended experience in simplifying SQL speak via his blog,...

Iam using VB6.0 with CR8.5 and backend as MS Acess. During setup creation it gives me an "unexpected error number 28 has occurred.Out of Stack space". plz help me out with proper solution Thanx in Advance...

This week you could win a copy of Achieving Extreme Performance with Oracle Exadata from Oracle Press. Chock full of best practices for Oracle Exadata Database Machine deployment and maintenance, this resource covers data warehousing, transaction processing, consolidation strategies, maximum...

I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating "The Pivot Table field name is not valid....

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy