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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
AS/400 Profile getting disabled by MS Access
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400′s in to MS Access. The other [...]
Answer Question
| June 8, 2012 2:15 PM
iSeries, Microsoft Access, ODBC
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400′s in to MS Access. The other [...]
Answer Question
| June 8, 2012 2:15 PM
iSeries, Microsoft Access, ODBC
GROUP BY mysql
Hi I have started working with a mySQL databse. I need a query that will either make use of “DISTINCT” or “GROUP BY” but that selectes the record that has the highest ‘VersionNumber’ Can anybody suggest how I would achieve this? Thanks in advance.
Answer Question
| June 22, 2012 8:10 AM
MySQL, MySQL Database, MySQL query
Hi I have started working with a mySQL databse. I need a query that will either make use of “DISTINCT” or “GROUP BY” but that selectes the record that has the highest ‘VersionNumber’ Can anybody suggest how I would achieve this? Thanks in advance.
Answer Question
| June 22, 2012 8:10 AM
MySQL, MySQL Database, MySQL query
