Application retirement and database archiving
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]
Answer Question
| May 22, 2013 10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]
Answer Question
| May 22, 2013 10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM
StartDates
How would you write the “Where” clause (sql) for abstracting just the “Year” out of a startdate like 03/12/2013 which would result in an answer of “2013″?
Answer Question
| May 21, 2013 2:29 PM
Database Management Systems
How would you write the “Where” clause (sql) for abstracting just the “Year” out of a startdate like 03/12/2013 which would result in an answer of “2013″?
Answer Question
| May 21, 2013 2:29 PM
Database Management Systems
Business Intelligence startup
Hi Members, I am new to this community.I have done BTech in computer science in 2012 and currently working on Visual Studio 2010 C# Asp.net SQL Server 2010.My interest is in artificial intelligence,Data mining and warehousing,algorithms,pattern Recognition etc.So I choose to make startup in BI and ready to take challenges. So kindly guide, that from [...]
Answer Question
| May 20, 2013 6:32 AM
Business Intelligence
Hi Members, I am new to this community.I have done BTech in computer science in 2012 and currently working on Visual Studio 2010 C# Asp.net SQL Server 2010.My interest is in artificial intelligence,Data mining and warehousing,algorithms,pattern Recognition etc.So I choose to make startup in BI and ready to take challenges. So kindly guide, that from [...]
Answer Question
| May 20, 2013 6:32 AM
Business Intelligence
What is the best method to connect Oracle and DB2 DB with HIGH reliability and speed?
Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly (recently upgraded [...]
Answer Question
| May 16, 2013 1:02 PM
DB2, ERP system, JDE, Oracle
Hello, My company currently has 2 ERP systems: JDE (in Oracle) and another which has 3 of our divisions. The decision has been made to move the remaining 3 divisions to JDE. The other divisions currently push pricing to the 2nd ERP system from home grown Contract Systems on the System i nightly (recently upgraded [...]
Answer Question
| May 16, 2013 1:02 PM
DB2, ERP system, JDE, Oracle
Trigger
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Answer Question
| May 14, 2013 4:24 AM
AS/400, CLLE, DB2, RPGLE
Guys, we got a problem here…our file is associated with Insert and delete trigger. So will an SQL delete query execution trigger the job attached?
Answer Question
| May 14, 2013 4:24 AM
AS/400, CLLE, DB2, RPGLE
Trigger removed
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?
Answer Question
| May 14, 2013 4:03 AM
AS/400, DB2, RPGLE
How to know if some one had removed the trigger from the file? We have a situation like this so how to know who did that? Shall we get the data from journaling?
Answer Question
| May 14, 2013 4:03 AM
AS/400, DB2, RPGLE
QR code barcode generation
Recently, I learned QR Code barcode generation in Java here, could anyone tell me how to generate QR Code barcode in other platforms, like ASP.NET, NET WinForms?
Answer Question
| May 10, 2013 11:50 AM
ASP.NET, Barcode, Java
Recently, I learned QR Code barcode generation in Java here, could anyone tell me how to generate QR Code barcode in other platforms, like ASP.NET, NET WinForms?
Answer Question
| May 10, 2013 11:50 AM
ASP.NET, Barcode, Java
Steps to an improved data quality assurance plan?
David Loshin has outlined his five steps to an improved data quality assurance plan. Do his five steps cover everything needed? What would be your five (or more) steps?
Answer Question
| May 17, 2013 1:19 PM
Data quality, improve, Quality assurance
David Loshin has outlined his five steps to an improved data quality assurance plan. Do his five steps cover everything needed? What would be your five (or more) steps?
Answer Question
| May 17, 2013 1:19 PM
Data quality, improve, Quality assurance
Data mining and warehousing
State the salient differences between data query and knowledge query?
Answer Question
| May 1, 2013 10:44 AM
Data Mining, Data warehouse
State the salient differences between data query and knowledge query?
Answer Question
| May 1, 2013 10:44 AM
Data Mining, Data warehouse
Sequel IF and Else statements
I’m a newbie to Sequel and I’m trying to recreate some old Crystal Reports using Sequel. My question is: how does the IF, Else statement work in Sequel? This is the statement for Crystal, for a Termination report, we have six companies and if an employee transfers to one of our other companies, we need [...]
Answer Question
| April 30, 2013 2:40 PM
AS/400, Crystal Reports
I’m a newbie to Sequel and I’m trying to recreate some old Crystal Reports using Sequel. My question is: how does the IF, Else statement work in Sequel? This is the statement for Crystal, for a Termination report, we have six companies and if an employee transfers to one of our other companies, we need [...]
Answer Question
| April 30, 2013 2:40 PM
AS/400, Crystal Reports
Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.
Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as ‘%’ and if Numeric default till the length of the field with -9999. As per now I’m getting two options. 1. Create the [...]
Answer Question
| April 26, 2013 4:53 PM
AS/400, DB2, RPG, RPGILE
Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as ‘%’ and if Numeric default till the length of the field with -9999. As per now I’m getting two options. 1. Create the [...]
Answer Question
| April 26, 2013 4:53 PM
AS/400, DB2, RPG, RPGILE
Crystal Reports 9
Hi, I’m using Crystal Reports 9 version and in the database expert, it is not displaying all the schemas of the DB2 database connected. Only fewer are displayed. I’m unable to query it even after I have verified all the options such as tables, views etc in the “Options”. But none of them have worked. [...]
Answer Question
| April 22, 2013 2:58 PM
Crystal Reports 9, DB2 server
Hi, I’m using Crystal Reports 9 version and in the database expert, it is not displaying all the schemas of the DB2 database connected. Only fewer are displayed. I’m unable to query it even after I have verified all the options such as tables, views etc in the “Options”. But none of them have worked. [...]
Answer Question
| April 22, 2013 2:58 PM
Crystal Reports 9, DB2 server
Formula to take three date fields and create on date field with the most recent date.
I have three date fields; approved, countered and denied. I need to have one date field called Decision date. The formula needs to account for the null values and also needs to return the most recent date out of all three of the fields. I know how to do this with two dates but haven’t [...]
Answer Question
| April 22, 2013 10:10 PM
Crystal Reports formulas, Crystal Reports XI
I have three date fields; approved, countered and denied. I need to have one date field called Decision date. The formula needs to account for the null values and also needs to return the most recent date out of all three of the fields. I know how to do this with two dates but haven’t [...]
Answer Question
| April 22, 2013 10:10 PM
Crystal Reports formulas, Crystal Reports XI
Types of data
I want to know the different types of data, their description and applications.
Answer Question
| April 19, 2013 8:59 PM
Data, Data analysis
I want to know the different types of data, their description and applications.
Answer Question
| April 19, 2013 8:59 PM
Data, Data analysis
SQL creating an unwanted duplicate of file
The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than [...]
Answer Question
| April 18, 2013 1:50 PM
DB2, SQL statement
The other day a colleague ran an SQL statement to update a field in a file to a constant where 2 other fields were equal to constants (so no joining was needed, etc.) When finished, there was a duplicate copy of the file in the first library in the library list. (Which is higher than [...]
Answer Question
| April 18, 2013 1:50 PM
DB2, SQL statement
A good way to protect sensitive data
Hello, My name is Aaron and I am a UAT student. A good security hygiene practice is to protect sensitive data, and also protect stored data and encrypt transmissions of sensitive data across open, public networks. It’s good to protect this data both in transit and when it’s at rest. Having protected sensitive data will [...]
Answer Question
| April 14, 2013 10:52 AM
Data, Protect, UAT
Hello, My name is Aaron and I am a UAT student. A good security hygiene practice is to protect sensitive data, and also protect stored data and encrypt transmissions of sensitive data across open, public networks. It’s good to protect this data both in transit and when it’s at rest. Having protected sensitive data will [...]
Answer Question
| April 14, 2013 10:52 AM
Data, Protect, UAT
Meeting Type Report
Is it possible to occasionally run a report based on color coded activity types (such as client meetings, phone calls, etc.)
Answer Question
| April 12, 2013 2:42 PM
Reports
Is it possible to occasionally run a report based on color coded activity types (such as client meetings, phone calls, etc.)
Answer Question
| April 12, 2013 2:42 PM
Reports
Migration issue from 8.5 to 11.5
I use an application which generates Crystal Reports. This application currently uses Crystal Reports 8.5 when I tried to migrate the Crystal Reports to 11.5 and tried generating reports, an error is thrown which says”failed to load database information”.
Answer Question
| April 5, 2013 11:46 AM
Crystal Reports 11.5, Crystal Reports 8.5
I use an application which generates Crystal Reports. This application currently uses Crystal Reports 8.5 when I tried to migrate the Crystal Reports to 11.5 and tried generating reports, an error is thrown which says”failed to load database information”.
Answer Question
| April 5, 2013 11:46 AM
Crystal Reports 11.5, Crystal Reports 8.5
How to trace and log a “phantom” print job
Greetings, our company owns a string of distribution centers that use optio formatting for labels and packing slips. We have noticed lately a label print job that randomly occurs at different centers and different times of the day. This seems to be a bug of some sort that will just spool rolls and rolls of [...]
Answer Question
| April 4, 2013 2:41 PM
Optio, Optio Software
Greetings, our company owns a string of distribution centers that use optio formatting for labels and packing slips. We have noticed lately a label print job that randomly occurs at different centers and different times of the day. This seems to be a bug of some sort that will just spool rolls and rolls of [...]
Answer Question
| April 4, 2013 2:41 PM
Optio, Optio Software
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
