AS400 System Information Through Data Access
Hi, We do a lot of AS400 system checks on a number of servers. Is there a way of using ODBC/OLE DB to access information from an AS400 concerning such commands like WRKDSKSTS (After using the F11 key to determine which ones are active), WRKSBS, QSYSOPR Messages, etc. I am trying to download this informaiton [...]
Answer Question
| December 20, 2007 7:02 AM
AS/400, Automation, ODBC, OLE DB, QSYSOPR, VB, WRKDSKSTS, WRKSBS
Hi, We do a lot of AS400 system checks on a number of servers. Is there a way of using ODBC/OLE DB to access information from an AS400 concerning such commands like WRKDSKSTS (After using the F11 key to determine which ones are active), WRKSBS, QSYSOPR Messages, etc. I am trying to download this informaiton [...]
Answer Question
| December 20, 2007 7:02 AM
AS/400, Automation, ODBC, OLE DB, QSYSOPR, VB, WRKDSKSTS, WRKSBS
Relational DBMS
What is a Relational DBMS?
Answer Question
| December 3, 2007 1:39 AM
Database, RDBMS
What is a Relational DBMS?
Answer Question
| December 3, 2007 1:39 AM
Database, RDBMS
database identifier
database identifier should be system generated or manual input, please advise
Answer Question
| November 29, 2007 9:22 PM
Database Identifier
database identifier should be system generated or manual input, please advise
Answer Question
| November 29, 2007 9:22 PM
Database Identifier
Showing all records
DATA SET: Table1 XID YID WRKDATE — — ——- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY — — — 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY — — ——- — — 1 NOR 2007-01 PAP 20 1 NOR [...]
Answer Question
| November 27, 2007 2:58 AM
JOIN statement, SELECT statement
DATA SET: Table1 XID YID WRKDATE — — ——- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY — — — 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY — — ——- — — 1 NOR 2007-01 PAP 20 1 NOR [...]
Answer Question
| November 27, 2007 2:58 AM
JOIN statement, SELECT statement
how to define page lenth in foxpro 2.6 for win 95
if in each run of the same prg the output to be sent to the printer is of different length how to define it
Answer Question
| November 26, 2007 12:53 PM
FoxPro 2.6
if in each run of the same prg the output to be sent to the printer is of different length how to define it
Answer Question
| November 26, 2007 12:53 PM
FoxPro 2.6
Vista and Office 2007
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.
Answer Question
| June 4, 2012 7:25 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.
Answer Question
| June 4, 2012 7:25 PM
AS/400, Microsoft Access, Microsoft Excel, Microsoft Office 2007
What are the Advantages of database system over File processing systems?
What are the Advantages of database system over File processing systems?
Answer Question
| October 14, 2011 2:49 PM
Database, File management
What are the Advantages of database system over File processing systems?
Answer Question
| October 14, 2011 2:49 PM
Database, File management
Printing a report in varying pagesizes
I have a customer who want to the dot matrix printer to stop where the invoice ends.. it could be juz 3inches for some bills and A4 for some others..can anyone please tell me how to set the pagesize through code in VB6? I tried using the Printer.PaperSize property.. but no effect..anybody got a work [...]
Answer Question
| August 4, 2008 7:58 PM
Database, Printing, Reports, VB
I have a customer who want to the dot matrix printer to stop where the invoice ends.. it could be juz 3inches for some bills and A4 for some others..can anyone please tell me how to set the pagesize through code in VB6? I tried using the Printer.PaperSize property.. but no effect..anybody got a work [...]
Answer Question
| August 4, 2008 7:58 PM
Database, Printing, Reports, VB
saving text files in oracle database
how to save text files in oracle database
Answer Question
| December 4, 2007 10:59 AM
Database, Oracle
how to save text files in oracle database
Answer Question
| December 4, 2007 10:59 AM
Database, Oracle
Cold Fusion and Data base application
I am in the process of developing and internet web site, and do not know cold fusion. I have a database in access that I want customers to be able to search. There will be three levels of search and I am using dreamweaver 8 for designing my web page Instead of coding every link [...]
Answer Question
| November 12, 2007 12:15 AM
ColdFusion, Database, Microsoft Access
I am in the process of developing and internet web site, and do not know cold fusion. I have a database in access that I want customers to be able to search. There will be three levels of search and I am using dreamweaver 8 for designing my web page Instead of coding every link [...]
Answer Question
| November 12, 2007 12:15 AM
ColdFusion, Database, Microsoft Access
retrieving data/tables through ODBC to Oracle
HI I need to pull up oracle tables through ODBC in access is that possible? help.
Answer Question
| February 1, 2008 9:41 PM
Database, ODBC Oracle Access, Oracle
HI I need to pull up oracle tables through ODBC in access is that possible? help.
Answer Question
| February 1, 2008 9:41 PM
Database, ODBC Oracle Access, Oracle
DB Triggers and JPA
I have a physical file/table, on an iSeries, into which I drop a record containing UserID and Password. This action in turn fires a trigger that ends up calling the api QSYGETPH to verify the user’s login credentials. This has been working for years under our previous architecture, wherein we inserted the record via SQL [...]
Answer Question
| February 20, 2010 4:27 PM
AS/400, iSeries, JPA, Spring, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Toplink, Triggers, XFire
I have a physical file/table, on an iSeries, into which I drop a record containing UserID and Password. This action in turn fires a trigger that ends up calling the api QSYGETPH to verify the user’s login credentials. This has been working for years under our previous architecture, wherein we inserted the record via SQL [...]
Answer Question
| February 20, 2010 4:27 PM
AS/400, iSeries, JPA, Spring, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Toplink, Triggers, XFire
USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]
Answer Question
| December 2, 2007 1:40 PM
Database, SQL, Stored Procedures, USE DATABASE
How can I write a stored procedure which can switch to new databases using something like “use DBASENAME”, but without knowing the dbase names before the procedure runs? The example below was my attempt to do this using SP_EXECUTESQL. The reason for this is so that I can call stored procedures within my stored procedure [...]
Answer Question
| December 2, 2007 1:40 PM
Database, SQL, Stored Procedures, USE DATABASE
SQL 2005 Restore DB with Multiple files in Primary File group
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee
Answer Question
| December 2, 2007 8:58 PM
Database, Restore, SQL, SQL Server, SQL Server 2005
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee
Answer Question
| December 2, 2007 8:58 PM
Database, Restore, SQL, SQL Server, SQL Server 2005
design a web database application
i want to design a web database application to compile undergraduates results using php and MySql. can i get a worked example?
Answer Question
| January 16, 2008 11:51 AM
MySQL, PHP
i want to design a web database application to compile undergraduates results using php and MySql. can i get a worked example?
Answer Question
| January 16, 2008 11:51 AM
MySQL, PHP
Local replication
I have a database that resides on a server. Many users have access to this database to add and edit documents. When this database is replicated to a local machine not all documents will replicate. Can someone tell me what I need to do to correct this problem? Thanks,
Answer Question
| March 1, 2008 4:42 PM
Database, Replication
I have a database that resides on a server. Many users have access to this database to add and edit documents. When this database is replicated to a local machine not all documents will replicate. Can someone tell me what I need to do to correct this problem? Thanks,
Answer Question
| March 1, 2008 4:42 PM
Database, Replication
opening crystal report using ISeries sql error Temp table already exists
I built an sql stored procedure on the ISeries using ISeries Navigator. The procdure returns a good result set using a couple of global temporary tables from other stored procedures I call. When I try to access the stored procedure using Crystal X1, I get an obdc error telling me the temp table already exists. [...]
Answer Question
| December 13, 2007 8:20 PM
Crystal Reports, iSeries, ODBC
I built an sql stored procedure on the ISeries using ISeries Navigator. The procdure returns a good result set using a couple of global temporary tables from other stored procedures I call. When I try to access the stored procedure using Crystal X1, I get an obdc error telling me the temp table already exists. [...]
Answer Question
| December 13, 2007 8:20 PM
Crystal Reports, iSeries, ODBC
Question on JOIN Clause
Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash
Answer Question
| November 2, 2007 9:00 AM
JOIN statement, SQL Server 2000, SQL Server 2005
Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash
Answer Question
| November 2, 2007 9:00 AM
JOIN statement, SQL Server 2000, SQL Server 2005
Open MSAccess database
Hi there, Does anyone know how I can open an Access database with script without giving the path of the MSAccess.exe file. I would need the equivalent of Execute, @Command that does not require a path. @Command( [Execute] ; “msaccess.exe”; “C:\MyAppsTest.mdb” ) currently I am using Shell that does require MSAccess.exe path. The problem is [...]
Answer Question
| October 24, 2007 6:55 PM
file open, Microsoft Access
Hi there, Does anyone know how I can open an Access database with script without giving the path of the MSAccess.exe file. I would need the equivalent of Execute, @Command that does not require a path. @Command( [Execute] ; “msaccess.exe”; “C:\MyAppsTest.mdb” ) currently I am using Shell that does require MSAccess.exe path. The problem is [...]
Answer Question
| October 24, 2007 6:55 PM
file open, Microsoft Access
update single row error
This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why? UPDATE property p SET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE mfr_code = p.mfrcode)
Answer Question
| October 25, 2007 2:43 PM
multiple row query, Update
This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why? UPDATE property p SET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE mfr_code = p.mfrcode)
Answer Question
| October 25, 2007 2:43 PM
multiple row query, Update
