Fill factor on subscriber
Hello, We have an OLTP application for which a majority of the database’s tables are replicated between two environments. The publisher side is intended to handle the writes from users and the subscriber handles the reporting aspect of the application. The subscriber therefore is mainly read by users and should only be updated by replication. [...]

Answer Question   |  February 6, 2009  4:17 PM
OLAP/OLTP, SQL Server Indexes, SQL Server replication

What are the containers available in VB 6.0
containers available in vb 6.0

Answer Question   |  February 9, 2009  10:05 AM
VB 6, VB 6 containers, Visual Basic, Visual Basic 6 containers

How to find a string in all columns of a table
I want to search for a string for example “POLARIS” in all the columns of a table ? How to find the string using sql query ?

Answer Question   |  February 6, 2009  7:18 AM
Search string, SQL, SQL Query

Using SOAP with iSeries
Using ILOG JRules with AS/400 on VR4 through Lansa Integrator. The communications is using SOAP and WSDL because ILOG communicates as a web service. I am seeking an alternate means to connect to the ILOG engine without Lansa because the performance is a huge bottleneck.

Answer Question   |  June 14, 2011  1:13 AM
AS/400, ILOG, ILOG JRules, iSeries, Lansa Integrator, SOAP, Web services, WSDL, XML

SQL Server Query Help Needed
I have a table with Inventory transacation records. The table contains both Shipment (outgoing) and Receiving (incoming) transactions. I’m trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records. If I link the Inventory Transaction table to the Shipment (Sales Order) tables [...]

Answer Question   |  February 6, 2009  10:39 PM
INNER JOIN, JOIN statement, LEFT JOIN, RIGHT JOIN, SQL, SQL queries, SQL Query, SQL Server development, SQL Server Query

Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b
I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case ‘Lewis’), then add the numbers in column c labeled ‘hours’, if the sum equals 24 then no problem, [...]

Answer Question   |  February 10, 2009  10:28 PM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel, SUM function

exchange data between Client (vbscript variable) and Server (PHP)
I have searched far and wide on the net for an easy answer to how you can gather client information using vbscript through a website and pass that data to a server. I still have not found a cut and dry easy method. Is there some way that I am not considering to achieve these [...]

Answer Question   |  February 5, 2009  9:13 PM
PHP, VBScript

Address segregation in SQL 2005
I am working in SQL 2005 and would like to parse an address filed such as “1234 N CLARK ST APT 111 ” into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

Answer Question   |  February 6, 2009  8:30 PM
SQL, SQL 2005, SQL Address Segregation

Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.
Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.

Answer Question   |  February 5, 2009  7:37 PM
Excel 2003, Excel Formatting, Excel formulas, Microsoft Excel

Oracle vs Java programming
Which is better Oracle or Java? I have a interest in programming. What should I learn?

Answer Question   |  September 17, 2011  7:33 PM
IT career planning, IT careers, Java developers, Oracle development, Programming Careers

Help on SQL Query
Hi, I have a table which has customer order and date in the below format. customer order Date 1 1a 02/10/2008 19:48 1 1b 02/10/2008 18:48 1 1c 02/10/2008 17:48 1 1d 03/10/2008 19:48 2 2a 01/11/2008 01:30 2 2b 02/11/2008 01:30 2 2c 03/11/2008 03:45 2 2d 03/11/2008 03:50 3 3a 06/11/2008 03:50 3 [...]

Answer Question   |  February 6, 2009  6:35 PM
SQL, SQL Query

Why isn’t my data displaying in the next page of Gridview?
I added a sqldatasource from my toolbox to my aspx page. I then configured the sqldatasource to connect to a table. I then added a gridview to the same aspx page and selected the sqldatasource as it’s data source. In addition to other column formatting etc., I set paging to true. I then opened the [...]

Answer Question   |  July 21, 2009  5:25 PM
ASPX, GridView, SQL data source, VBScript, Visual Studio, Visual Studio 2005

Quality Center and SAP
Has anyone used Quality Center with SAP, I mean in addition to Solution Manager?

Answer Question   |  February 5, 2009  4:24 PM
QC and SAP, Quality Center, SAP Solution Manager

Limit number of rows in a table
Dear all, I’d just like to ask if anyone can help me find a solution to the following problem: I want to limit the number of records in a table. So when all the available rows are used, the customer can purchase additional ones. Say for example that the customer is allowed to enter 100 [...]

Answer Question   |  February 6, 2009  7:26 AM
Auto increment, Database programming, SQL

Java on iSeries
We have a java program running on web sphere on linux. The java program is zipped as jar and deployed in an IFS directory and we use RPGILE to call the java program. Would it be possible to deploy war file instead of jar file in IFS directory and call the java program in the [...]

Answer Question   |  February 5, 2009  4:12 AM
IFS Directory, iSeries, iSeries development, JAR file, Java, Java ARchive, RPGILE, WAR file, Web ARchive, WebSphere

To retrieve records from SQL Server database
Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named “Name” in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on…. Now, through some application [...]

Answer Question   |  February 10, 2009  3:35 AM
Query optimization, SQL, SQL Server development, SQL Server Query

Java400
How to implement simple java program(to display Helloworld Program) in Synon or AS/400?Please let me know? Thanks in advance…

Answer Question   |  February 6, 2009  2:34 PM
Java, Java/400, Synon

VBA/VB code to edit hyperlinks in PDF files
Hi, How do we read the content in a pdf file. I have some sample pdf where I have to edit already existing hyperlinks . Thanks in advance.

Answer Question   |  February 21, 2012  12:16 PM
Hyperlinks, PDF, PDF hyperlinks, VBA, Visual Basic, Visual Basic for Applications

Subform based on conditional values?
Is it possible to add a computed subform with a condition based on the value supplied for a textfield at runtime?

Answer Question   |  February 4, 2009  10:20 AM
Conditional statements, Conditional values, Dynamic subform, RunTime, Text field

Stored Procedures, One Database, Different Software Releases
Hi Everyone. Currently at my work we use SQL in our VB.NET code. I have previously always used stored procedures for all of their benefits. My company has said that our customers might use different versions of our software against its one database. For example: While a customer is migrating from release 1 to release [...]

Answer Question   |  February 24, 2009  9:20 AM
Release management, Software maintenance, SQL, Stored Procedures, VB.NET, Visual Basic .NET