Problem to storing records at SAP DB from MySQL
I’m using JCO for connecting SAP through jsp-Servlet. I want to store all MySQL Records to SAP DB. What will I Do?

Answer Question   |  September 17, 2012  6:45 AM
MySQL, SAP

SQL selecting multiple rows from same column based on different column values
I have am joining a table (object_restrictions) that has three columns: (object_type), (object_restriction_ID) and (object_restriction). I would like to join the table on (object_restriction_id) but select multiple rows based on the value in the column (object_type) and have them listed as separate columns in the final query. For example ‘object_restrictions’ table object_type object_restriction_ID object_restriction protein [...]

Answer Question   |  September 15, 2012  5:12 PM
MySQL query

SPSS v. 21 STAR JOIN
I have just started with version 21 and I have run into a major issue. Merge is no longer the MATCH CASES command. It is now STAR JOIN. There is something different that this command is doing. When merging, the command just stops when it runs into a keyed variable that has no match in [...]

Answer Question   |  September 11, 2012  5:25 PM
MERGE statement, star join statement, version 21

Take .csv files and show that on a subfile
Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option – upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with [...]

Answer Question   |  September 11, 2012  12:35 PM
CSV

sql access/rights
I am a local admin on the SQL server machine but do not have access to create a database and to browse other databases on the server. I have access to few databases but not all. Which SQL rights or role do i need to have a full access to the SQL server? Besides above, [...]

Answer Question   |  September 5, 2012  5:44 PM
SQL Security

What’s your biggest data problem? (Answer to win a free book)
Data management is of growing concern now, and there are lots of ways to tame the beast.  What issues has your organization had with managing or analyzing data? Have you come up with any solutions yet? We’ll give a free copy of Making Sense of NoSQL (read an excerpt here) to the member who offers [...]

Answer Question   |  September 5, 2012  1:45 PM
Big Data, Data management, Database administration, NoSQL

DBMS query
I have a two table. first is income table column name is – icode,point(outlet),incomedate,interest second is – ocode, point(outlet), outcomedate, interest 2 query 1). income of interest & out of the money at each outlet are return not more than the once a day. 2) income & out of the money at each outlet are [...]

Answer Question   |  September 2, 2012  11:11 AM
Database

Adding from two tables in VBA
Does anyone know how I can use VBA to take one value from one table and add to it a value from another table and then put that total into one field of the original table. I’ve been fighting with this for a couple of days so now i am looking for some help.

Answer Question   |  August 31, 2012  1:51 AM
adding, tables, VBA

editing in grid forms
How do I add,edit,delete in gridforms with Microsoft Access?

Answer Question   |  August 22, 2012  4:16 PM
Microsoft Access, Microsoft Access gridforms

Powershell, loop through two different arrays?
Helllo, What I am trying to accomplish is reading in two separate text files and going through them 1 by 1. Say text file 1 is computer names and text file 2 is ABCDEFG (the alphabet) In the script i’m trying to access a remote computer(s) (According to the text file 1) and access a [...]

Answer Question   |  August 20, 2012  11:12 PM
Arrays, LOOP statement, PowerShell, PowerShell Scripts, Scripting

Determining data from a certain date range
I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a [...]

Answer Question   |  July 30, 2012  12:40 PM
Data access, Database management, Date calculation, Microsoft Access 2003

Open IT Forum: Who’s on your list of the most influential women in IT?
Two weeks ago, ComputerWeekly.com produced a list of the top 25 most influential women in UK IT, with Thomson Reuters Global CIO Jane Moran coming in at the top spot. Do you agree with this list? Tell us your top 10 of the most powerful women in the IT industry.

Answer Question   |  July 26, 2012  3:57 PM
CIO, IT careers

VBA Array Loop
Hello, Can anyone help me with VBA code that creates an array from a range of cells (A1:E1), loops through the array and performs a function. I already have the function now I need to create the array and loop. Thank you…

Answer Question   |  July 20, 2012  2:18 PM
Array, FORALL loop, loop, VBA

Importing a .dbf file into IBM DB2 table
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]

Answer Question   |  July 19, 2012  3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4

VB6 Search Function
How can I search in vb6 that when I clicked on the search bar, the information will be inserted to the text boxes.

Answer Question   |  July 19, 2012  3:52 AM
Search, Search string, VB6

Filter SQL Replication Deletes by user
I am in the process of setting up replication from sql 2008r2 to Oracle 11.  I have one requirement that is giving me some issues.  My sql db is the publisher and currently maintains data from year 1.  The Oracle subscriber will maintain 7 years data.  After the initial snapshot the sql db will only [...]

Answer Question   |  July 11, 2012  6:13 PM
Replicating databases, Replication, SQL replication

Find a string in text file using MS Access
I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ———— Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT … Patch 654321 : applied on Wed Jun 25 15:41:56 CEST [...]

Answer Question   |  July 10, 2012  11:11 AM
MS Access, Search string

Storing HTML in a Physical File
Hello everyone, I’m looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can’t describe the PF with SQL (I’d like to, but need to use DDS). Thanks in advance! Dave

Answer Question   |  June 21, 2012  2:40 PM
Database, DDS, HTML, PF, System i

Embedded SQL Update Query
Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by [...]

Answer Question   |  June 15, 2012  10:42 AM
Embedded SQL

Extra Page Printing
When I print a form I select a record but it gives me an extra page with part of the header printed with it.

Answer Question   |  June 22, 2012  2:26 PM
Microsoft Access 2007, Microsoft Access printing