ODBC in AS/400, OS/400, System i, i5/OS
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).
Answer Question
| November 10, 2008 9:00 AM
AS/400 database, AS/400 database connectivity, i5/OS, Lotus Notes, ODBC, ODBC drivers, Open Database Connectivity, OS/400, System i
Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).
Answer Question
| November 10, 2008 9:00 AM
AS/400 database, AS/400 database connectivity, i5/OS, Lotus Notes, ODBC, ODBC drivers, Open Database Connectivity, OS/400, System i
Create table by comparising 2 tables
I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow [...]
Answer Question
| November 6, 2008 4:38 AM
Access conditional expressions, CREATE TABLE statement, Database programming, Microsoft Access
I am new at Access but have some help with creating a db. I would like to know if it is possible to compare table 1: prior data and table 2: current data, and then create a table 3, with all the changes/deletions from the 1st table to the 2nd. All the data is workflow [...]
Answer Question
| November 6, 2008 4:38 AM
Access conditional expressions, CREATE TABLE statement, Database programming, Microsoft Access
MySQL vs SQL server
If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they’re cabable of or does it just change what front-end you use? Why would I need a WAMP stack [...]
Answer Question
| February 27, 2011 4:34 PM
MySQL, SQL, SQL Small Business Server, WAMP Stack
If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they’re cabable of or does it just change what front-end you use? Why would I need a WAMP stack [...]
Answer Question
| February 27, 2011 4:34 PM
MySQL, SQL, SQL Small Business Server, WAMP Stack
About UPDATE query
hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand(“update device set manu=’” + mtxt.Text + “‘,desc=’” + dtxt.Text + “‘,model=’” + mdtxt.Text + “‘,pdate=’” + prodate.Text + “‘,price=’” + ptxt.Text + “‘where ano=’” + atxt.Text + [...]
Answer Question
| November 5, 2008 4:09 PM
Access 2003, Microsoft Access, RSS, VB 2008, Visual Basic 2008
hi friends , i am using VB 2008 . database access 2003 in my project , i include an update query,its below con.Open() Dim cmd As New OleDbCommand(“update device set manu=’” + mtxt.Text + “‘,desc=’” + dtxt.Text + “‘,model=’” + mdtxt.Text + “‘,pdate=’” + prodate.Text + “‘,price=’” + ptxt.Text + “‘where ano=’” + atxt.Text + [...]
Answer Question
| November 5, 2008 4:09 PM
Access 2003, Microsoft Access, RSS, VB 2008, Visual Basic 2008
Advice on buying new PC
I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access – what would be a good PC processor, ram, etc? I have been quoted on a system with [...]
Answer Question
| November 8, 2008 1:50 PM
CorelDRAW, Hardware, Hardware configuration management, Microsoft Access, Microsoft Excel, Pentium
I have a Pentium 4 & need to upgrade. I teach Microsoft, use graphics in my manuals, & use CorelDraw a lot. I also design huge Excel spreadsheets with lots of formulas and design databases in Access – what would be a good PC processor, ram, etc? I have been quoted on a system with [...]
Answer Question
| November 8, 2008 1:50 PM
CorelDRAW, Hardware, Hardware configuration management, Microsoft Access, Microsoft Excel, Pentium
Connecting to a remote DB on a UNIX server with SQL
I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr [...]
Answer Question
| November 4, 2008 7:35 PM
DB2, Remote access, SQL database replication, Unix Servers
I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr [...]
Answer Question
| November 4, 2008 7:35 PM
DB2, Remote access, SQL database replication, Unix Servers
SQL query error: token DATA
I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),…… ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this query on iSeries [...]
Answer Question
| September 23, 2009 5:54 PM
AS/400, DB2, JDBC, SQL Query
I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),…… ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this query on iSeries [...]
Answer Question
| September 23, 2009 5:54 PM
AS/400, DB2, JDBC, SQL Query
Entry in SAP through SAP testing
Hi All , I have about 5 years of experience in software development and testing. Prior to this, I did MCA. Now I am interested to continue my career through SAP only. And since I have enough exposure of testing domain, SAP testing may be one of the option to take break into SAP. Now [...]
Answer Question
| November 4, 2008 12:45 PM
Career development, IT careers, SAP careers, SAP testing
Hi All , I have about 5 years of experience in software development and testing. Prior to this, I did MCA. Now I am interested to continue my career through SAP only. And since I have enough exposure of testing domain, SAP testing may be one of the option to take break into SAP. Now [...]
Answer Question
| November 4, 2008 12:45 PM
Career development, IT careers, SAP careers, SAP testing
Spool to Flat
Can anyone please guide me on the following: 1) How can I convert Spool to Flat and vice cersa ? 2) If I already have a Flat file. Can I convert it back into spool ? using what utility ? 3) What are the archivers that convert Flat to Spool and vice versa ?
Answer Question
| November 4, 2008 10:40 AM
File conversion, File formats, Flat files, Flat to Spool, Spool files, Spool to Flat
Can anyone please guide me on the following: 1) How can I convert Spool to Flat and vice cersa ? 2) If I already have a Flat file. Can I convert it back into spool ? using what utility ? 3) What are the archivers that convert Flat to Spool and vice versa ?
Answer Question
| November 4, 2008 10:40 AM
File conversion, File formats, Flat files, Flat to Spool, Spool files, Spool to Flat
Database design schema for Test Data Management?
For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.
Answer Question
| November 4, 2008 6:31 AM
Database design, Database schema, Software Quality, Software Quality Assurance, Software testing, Software testing tools
For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.
Answer Question
| November 4, 2008 6:31 AM
Database design, Database schema, Software Quality, Software Quality Assurance, Software testing, Software testing tools
Need to modify an existing form in Access 2007
I have just migrated to ACCESS 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.
Answer Question
| November 4, 2008 4:04 AM
Access 2007, Access forms, Database programming, Microsoft Access
I have just migrated to ACCESS 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.
Answer Question
| November 4, 2008 4:04 AM
Access 2007, Access forms, Database programming, Microsoft Access
Prevent Update in DB2 SQL External Trigger Program
I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a [...]
Answer Question
| November 6, 2008 4:29 PM
AS/400, DB2, SQL, Triggers
I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a [...]
Answer Question
| November 6, 2008 4:29 PM
AS/400, DB2, SQL, Triggers
Connection with two Database for an Application
I have an application that makes use of 2 different database say A and B. I am working with A but using some datas as views from database B. How can I establish the connection with two database using Bridges?
Answer Question
| November 3, 2008 3:57 PM
Bridging, Database
I have an application that makes use of 2 different database say A and B. I am working with A but using some datas as views from database B. How can I establish the connection with two database using Bridges?
Answer Question
| November 3, 2008 3:57 PM
Bridging, Database
Community Update: New Member Contest – Earn Knowledge Points and win!!
Get some Amazon.com gift cards for your holiday shopping. Now is your chance to win an Amazon gift certificate based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. The top 10 most active members from noon today (Nov [...]
Answer Question
| November 19, 2008 3:19 PM
AS/400, CIO, CRM, Database, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Get some Amazon.com gift cards for your holiday shopping. Now is your chance to win an Amazon gift certificate based on your activity in the IT Knowledge Exchange Community. Remember: the more you ask, answer or discuss questions, the more Knowledge Points you will earn. The top 10 most active members from noon today (Nov [...]
Answer Question
| November 19, 2008 3:19 PM
AS/400, CIO, CRM, Database, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
JDBC/ODBC to Excel 2007 getting Exception
Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) [...]
Answer Question
| November 3, 2008 1:14 PM
Excel 2007, Java, JDBC, Microsoft Excel, ODBC, SQL Exception
Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) [...]
Answer Question
| November 3, 2008 1:14 PM
Excel 2007, Java, JDBC, Microsoft Excel, ODBC, SQL Exception
Copy data from flat file to a flat file
My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto [...]
Answer Question
| November 3, 2008 6:37 AM
AS/400 import/export, COBOL, COBOL/400, Flat files, PF, Physical File, RPG
My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto [...]
Answer Question
| November 3, 2008 6:37 AM
AS/400 import/export, COBOL, COBOL/400, Flat files, PF, Physical File, RPG
Oracle9i Performance Issue
I got Oracle9i R2 database running on windows 2003. On a very busy day I got very bad performance with Average Disk Queue Length very high on the performance monitor. There is heaps of free RAM and I am running Raid 10. I am still new to Oracle, so I need some help. Thanks and [...]
Answer Question
| November 20, 2008 11:15 PM
Average Disk Queue Length, Oracle 9i, Oracle 9i performance, Oracle performance
I got Oracle9i R2 database running on windows 2003. On a very busy day I got very bad performance with Average Disk Queue Length very high on the performance monitor. There is heaps of free RAM and I am running Raid 10. I am still new to Oracle, so I need some help. Thanks and [...]
Answer Question
| November 20, 2008 11:15 PM
Average Disk Queue Length, Oracle 9i, Oracle 9i performance, Oracle performance
Haversine formula in RPG or SQL
I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?
Answer Question
| November 6, 2008 10:01 PM
AS/400 development, Great-circle distance, Haversine formula, RPG, SQL
I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?
Answer Question
| November 6, 2008 10:01 PM
AS/400 development, Great-circle distance, Haversine formula, RPG, SQL
Database Oracle
hi please answer the question how to create database in oracle9 and link the database in sqlserver 2000 table in oracle and table in sql
Answer Question
| November 3, 2008 7:58 PM
External database, Linked database, Oracle 9i, SQL Server 2000
hi please answer the question how to create database in oracle9 and link the database in sqlserver 2000 table in oracle and table in sql
Answer Question
| November 3, 2008 7:58 PM
External database, Linked database, Oracle 9i, SQL Server 2000
How to change the location where jpg is looked for in ACCESS
I enter data for trophy fish catches into an AK. Dept of Fish and Game database. I inherited the DB. I have no IT help. All pictures were in a messy folder with the DB. I sorted the pics into sub-folders. Now the program cannot find the JPG associated with a particular entry. I assume [...]
Answer Question
| October 31, 2008 6:40 PM
Access Database, Access File Paths, Microsoft Access
I enter data for trophy fish catches into an AK. Dept of Fish and Game database. I inherited the DB. I have no IT help. All pictures were in a messy folder with the DB. I sorted the pics into sub-folders. Now the program cannot find the JPG associated with a particular entry. I assume [...]
Answer Question
| October 31, 2008 6:40 PM
Access Database, Access File Paths, Microsoft Access
