Embedded SQL using SUM or some other method to total up qty and display 1 unique record
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
Restoring a backup from Brightstor 12 server
Run a Scan job to find out what sessions are on the tape. Manager > Quick Start > Utilities > Media Assure & Scan If you want to restore the whole session then Quick Start > Restore > select Restore By Backup Media > select the specific session # to restore and the destination. If [...]
View Answer
| June 7, 2011 8:49 PM
Backup, BrightStor, BrightStor ARCserve Backup 12, Database Backup, Database backup and recovery
Run a Scan job to find out what sessions are on the tape. Manager > Quick Start > Utilities > Media Assure & Scan If you want to restore the whole session then Quick Start > Restore > select Restore By Backup Media > select the specific session # to restore and the destination. If [...]
View Answer
| June 7, 2011 8:49 PM
Backup, BrightStor, BrightStor ARCserve Backup 12, Database Backup, Database backup and recovery
Free IT Book: The Data Warehouse Mentor
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Can someone guide about the career path?
Hands on experience is valued in the IT indistry, but so is a strong conceptual knowledge about the various solutions available. Your strength will be in your ability to make recommendations that identify the proper solutions (right size, right cost, right functionality) for the problems at hand. History show that IT related consultants working outside [...]
View Answer
| June 6, 2011 12:33 PM
IT careers
Hands on experience is valued in the IT indistry, but so is a strong conceptual knowledge about the various solutions available. Your strength will be in your ability to make recommendations that identify the proper solutions (right size, right cost, right functionality) for the problems at hand. History show that IT related consultants working outside [...]
View Answer
| June 6, 2011 12:33 PM
IT careers
Free IT Book: Building Applications in the Cloud
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Access 2007 database query question
Download the free program Expressor and have them do their free webinar. If you have the excel doc they will base the webinar off that and teach you everything you need to do. <a href=”http://www.expressor-software.com/”>Expressor
View Answer
| June 1, 2011 9:36 PM
Access 2007, Access 2007 functions, Access Database, Access query, QuerySave
Download the free program Expressor and have them do their free webinar. If you have the excel doc they will base the webinar off that and teach you everything you need to do. <a href=”http://www.expressor-software.com/”>Expressor
View Answer
| June 1, 2011 9:36 PM
Access 2007, Access 2007 functions, Access Database, Access query, QuerySave
Oracle fails due to disk partition is full. Data now is corrupted.
I’ve been lucky and not hit that error. I would take a look at http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm
View Answer
| May 25, 2011 11:19 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors
I’ve been lucky and not hit that error. I would take a look at http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/repair.htm
View Answer
| May 25, 2011 11:19 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors
Free IT Book: Governing Shared Services On-Premise and in the Cloud
Spam removed.
View Answer
| May 23, 2011 1:26 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Spam removed.
View Answer
| May 23, 2011 1:26 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Completed IT Knowledge Exchange Profile? Earn points!
http://itknowledgeexchange.techtarget.com/profile/Batye/
View Answer
| May 18, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
http://itknowledgeexchange.techtarget.com/profile/Batye/
View Answer
| May 18, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
How to make the connection in SQL 2000 with Visual Basic 6
<a href=”http://www.vbforums.com/archive/index.php/t-178076.html”>http://www.vbforums.com/archive/index.php/t-178076.html</a> Substitute your own parameters where applicable. ADO is fairly straightforward to work with. If you have any issues, post back and we’ll try to take care of them!
View Answer
| May 16, 2011 3:36 PM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
<a href=”http://www.vbforums.com/archive/index.php/t-178076.html”>http://www.vbforums.com/archive/index.php/t-178076.html</a> Substitute your own parameters where applicable. ADO is fairly straightforward to work with. If you have any issues, post back and we’ll try to take care of them!
View Answer
| May 16, 2011 3:36 PM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
Free IT Book: The RAILS 3 Way
Don’t know, link won’t open
View Answer
| May 12, 2011 5:52 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Don’t know, link won’t open
View Answer
| May 12, 2011 5:52 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
use Data connection wizard / Microsoft query to get data from as400 to excel 2007
If you have Client Access why not use Excel Addins that setup Icons in Excel to bring up a wizard in Excel to download to or from the Iseries. Can be saved fo subsequent downloads. With Excel 2007 need PTF SI26879 for 5722XE1 IF ON v5r4
View Answer
| May 11, 2011 3:28 PM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC
If you have Client Access why not use Excel Addins that setup Icons in Excel to bring up a wizard in Excel to download to or from the Iseries. Can be saved fo subsequent downloads. With Excel 2007 need PTF SI26879 for 5722XE1 IF ON v5r4
View Answer
| May 11, 2011 3:28 PM
AS/400, Data connection wizard, Excel 2007, Microsoft Query, ODBC
Embedded SQLRPGLE Books, guides, how to’s
http://www.mc-store.com/ You can also sign up for a weekly newsletter with RPG tips
View Answer
| May 11, 2011 12:38 PM
Embedded SQL, IT Books, Open IT Forum, Reference Guides, SQLRPGLE Books
http://www.mc-store.com/ You can also sign up for a weekly newsletter with RPG tips
View Answer
| May 11, 2011 12:38 PM
Embedded SQL, IT Books, Open IT Forum, Reference Guides, SQLRPGLE Books
Can we change length of CSV File
Actually I donot have a Source for this CSV file. its program described PF. I have created the new file and copied the data. Thanks, Pradeep
View Answer
| May 11, 2011 5:47 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
Actually I donot have a Source for this CSV file. its program described PF. I have created the new file and copied the data. Thanks, Pradeep
View Answer
| May 11, 2011 5:47 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
Embedded SQL in RPGLE hdr, dtl fetch for subfile build
I have not been able to find any good examples of what I am trying to do with the create view. I did combine all of the fields from the header and the detail into their own new file to reference as an external data structure. This shows all of the fields. I may have [...]
View Answer
| May 10, 2011 6:29 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
I have not been able to find any good examples of what I am trying to do with the create view. I did combine all of the fields from the header and the detail into their own new file to reference as an external data structure. This shows all of the fields. I may have [...]
View Answer
| May 10, 2011 6:29 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
MySQL Replication I think!
Replication is almost certainly the way to go, although MySQL Replication is generally only one-way only unless you use a cluster, which is a little out of my comfort zone to talk about. You could have a MySQL database which is accessible to your clients and also via a data source name via the access [...]
View Answer
| May 5, 2011 3:55 PM
Access Database, MySQL, MySQL Replication, MySQL Restore
Replication is almost certainly the way to go, although MySQL Replication is generally only one-way only unless you use a cluster, which is a little out of my comfort zone to talk about. You could have a MySQL database which is accessible to your clients and also via a data source name via the access [...]
View Answer
| May 5, 2011 3:55 PM
Access Database, MySQL, MySQL Replication, MySQL Restore
Open IT Forum: Share networking resources, earn knowledge points!
A little more information: We’re looking to do a roundup of recommended reading for networking professionals. If you have books or other resources you’ve found helpful, either as a general “cookbook,” getting up to speed on a particular topic, or even prepping for a certification exam, it would be great if you could share the [...]
View Answer
| May 5, 2011 3:16 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
A little more information: We’re looking to do a roundup of recommended reading for networking professionals. If you have books or other resources you’ve found helpful, either as a general “cookbook,” getting up to speed on a particular topic, or even prepping for a certification exam, it would be great if you could share the [...]
View Answer
| May 5, 2011 3:16 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SalesForce Developer
So you are not experienced…but hired as a SF developer? Maybe start by getting training. If you are new, you need to know how to administer (security roles and profiles, etc. are important as you move forward.) The 401 class is the declaritive development class (the point and click applicaiton building,) and the 50x are [...]
View Answer
| May 3, 2011 6:24 PM
IT career development, IT careers, Salesforce
So you are not experienced…but hired as a SF developer? Maybe start by getting training. If you are new, you need to know how to administer (security roles and profiles, etc. are important as you move forward.) The 401 class is the declaritive development class (the point and click applicaiton building,) and the 50x are [...]
View Answer
| May 3, 2011 6:24 PM
IT career development, IT careers, Salesforce
Inserting and viewing of Chinese characters in DB2400
Here is a link with information http://www.mcpressonline.com/forum/showthread.php?8597-Chinese-Charater-input-display-on-AS400
View Answer
| May 3, 2011 6:21 PM
AS/400 DB2, CCSID, DB2, DB2 administration
Here is a link with information http://www.mcpressonline.com/forum/showthread.php?8597-Chinese-Charater-input-display-on-AS400
View Answer
| May 3, 2011 6:21 PM
AS/400 DB2, CCSID, DB2, DB2 administration
Spring Cleaning: Free IT Book(s) Giveaway!
some of the Apple Itunes account got hacked I just find out my itunes account got hacked on the 05/01/11 when I did quick search online http://thenextweb.com/apple/2010/07/04/appstore-hack-itunes/ anyway I change my password and report this problem to apple but I would suggest to all members on itknowledgeexchange.techtarget to check the itunes account for unauthorized purchases [...]
View Answer
| May 3, 2011 2:57 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
some of the Apple Itunes account got hacked I just find out my itunes account got hacked on the 05/01/11 when I did quick search online http://thenextweb.com/apple/2010/07/04/appstore-hack-itunes/ anyway I change my password and report this problem to apple but I would suggest to all members on itknowledgeexchange.techtarget to check the itunes account for unauthorized purchases [...]
View Answer
| May 3, 2011 2:57 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
