Excel Spreadsheets
Try checking to see if the properties for auto refreshing the data when you open the workbook are set. This can be set to automatically open the required spreadsheet(s)/data file without user intervention. I use this to get data from the web automatically when I launch a workbook for epos data to be collated. I [...]
View Answer
| November 23, 2006 12:23 PM
Data analysis, Database, DataCenter, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
Try checking to see if the properties for auto refreshing the data when you open the workbook are set. This can be set to automatically open the required spreadsheet(s)/data file without user intervention. I use this to get data from the web automatically when I launch a workbook for epos data to be collated. I [...]
View Answer
| November 23, 2006 12:23 PM
Data analysis, Database, DataCenter, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server
Mail sending error in certain domains through excahnge server 2003
Hi, Does this happen on all domains except for yahoo, hotmail and gmail or only on specific domains? Does it happen only when you send large amount of email at once (e.g. some marketing mailing) or even when sending message to single recipient? I had similar issue during email marketing campaigns and it was related [...]
View Answer
| November 17, 2006 8:24 AM
Business/IT alignment, Data analysis, Exchange, Exchange security, Microsoft Windows, Networking
Hi, Does this happen on all domains except for yahoo, hotmail and gmail or only on specific domains? Does it happen only when you send large amount of email at once (e.g. some marketing mailing) or even when sending message to single recipient? I had similar issue during email marketing campaigns and it was related [...]
View Answer
| November 17, 2006 8:24 AM
Business/IT alignment, Data analysis, Exchange, Exchange security, Microsoft Windows, Networking
Conversion Project
As both your source and target data resides on the I-Series you shouldn’t have too much trouble. We have experience of replicating data between i-Series and MS-SQL using a product called Scribe Insight. This allows you to map source files and fields to target files and fields. This mapping process allows you to perform functions [...]
View Answer
| November 15, 2006 7:14 AM
Application development, AS/400, Data analysis, DB2 Universal Database
As both your source and target data resides on the I-Series you shouldn’t have too much trouble. We have experience of replicating data between i-Series and MS-SQL using a product called Scribe Insight. This allows you to map source files and fields to target files and fields. This mapping process allows you to perform functions [...]
View Answer
| November 15, 2006 7:14 AM
Application development, AS/400, Data analysis, DB2 Universal Database
Cataloging Stored Procedures
scottcrill@premiseinc.com has a save restore sql procedure tool.
View Answer
| November 13, 2006 12:36 PM
Application development, AS/400, Data mining/analysis, RPGLE
scottcrill@premiseinc.com has a save restore sql procedure tool.
View Answer
| November 13, 2006 12:36 PM
Application development, AS/400, Data mining/analysis, RPGLE
can strqmqry be run as remote command
I got it! Yes, it can be done this way. I finally decided to step through the proc again and my issue was when executing the command I was not properly quoting the variable. My initial presumption based on my research was that I did not need it… but I did. The example below required [...]
View Answer
| November 9, 2006 12:18 PM
Application development, AS/400, Backup & recovery, CLP, Data analysis, DB2 Universal Database, PC/Windows Connectivity, Printing
I got it! Yes, it can be done this way. I finally decided to step through the proc again and my issue was when executing the command I was not properly quoting the variable. My initial presumption based on my research was that I did not need it… but I did. The example below required [...]
View Answer
| November 9, 2006 12:18 PM
Application development, AS/400, Backup & recovery, CLP, Data analysis, DB2 Universal Database, PC/Windows Connectivity, Printing
OPNQRYF’s MAPFLD
MAPFLD(@NEW ‘%max(A,B)’)
View Answer
| November 8, 2006 9:04 AM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
MAPFLD(@NEW ‘%max(A,B)’)
View Answer
| November 8, 2006 9:04 AM
Application development, AS/400, Data analysis, Database, DB2, DB2 Universal Database, IBM, IBM Marketing Sound Off, Oracle, RPGLE
MS SQL Server 2000
You need public IP for that SQL server machine if your server is located behide firewall u need to config your firewall to redirect to SQL server machine with specific port that sql server use.
View Answer
| November 8, 2006 1:37 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
You need public IP for that SQL server machine if your server is located behide firewall u need to config your firewall to redirect to SQL server machine with specific port that sql server use.
View Answer
| November 8, 2006 1:37 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
security problem
The answer is simple. The company who owns the computer has the right to monitor all business conducted on that computer wheather it is business related or not. Most employees think that the pc belongs to them and the have the right to do with it as they please. The pc is there as a [...]
View Answer
| October 31, 2006 7:00 AM
Access control, Application security, backdoors, Backup & recovery, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Ecommerce applications, Encryption, Enterprise Desktop, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, Intrusion management, LANDesk, Lotus Domino, McAfee, Microsoft Systems Management Server, Microsoft Windows, Mobile security, Network security, Networking, Networking services, Oracle, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Postini, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Tech support, Trojans, Vector Networks, Viruses, VPN, vulnerability management, Web security, Wireless, worms
The answer is simple. The company who owns the computer has the right to monitor all business conducted on that computer wheather it is business related or not. Most employees think that the pc belongs to them and the have the right to do with it as they please. The pc is there as a [...]
View Answer
| October 31, 2006 7:00 AM
Access control, Application security, backdoors, Backup & recovery, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Database, DataCenter, DataManagement, DB2, Desktop management applications, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Ecommerce applications, Encryption, Enterprise Desktop, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, Intrusion management, LANDesk, Lotus Domino, McAfee, Microsoft Systems Management Server, Microsoft Windows, Mobile security, Network security, Networking, Networking services, Oracle, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Postini, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Tech support, Trojans, Vector Networks, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Document scanning and organizing
Have you considered a copier/scanner that allows scan-to-folder functionality? We have implemented a process that works as you described using a Canon ir5020. Basically, you scan the copies to a folder/subfolder which has been predefined. Maybe this is too simplistic for what you’re wanting, but it works for us.
View Answer
| October 18, 2006 5:14 PM
Business/IT alignment, Career development, CRM, Data analysis, DataCenter, DataManagement, Desktops, Development, Management, Microsoft Windows, OS, Outsourcing, Project management, Sales force automation applications, Security, Servers, SQL Server
Have you considered a copier/scanner that allows scan-to-folder functionality? We have implemented a process that works as you described using a Canon ir5020. Basically, you scan the copies to a folder/subfolder which has been predefined. Maybe this is too simplistic for what you’re wanting, but it works for us.
View Answer
| October 18, 2006 5:14 PM
Business/IT alignment, Career development, CRM, Data analysis, DataCenter, DataManagement, Desktops, Development, Management, Microsoft Windows, OS, Outsourcing, Project management, Sales force automation applications, Security, Servers, SQL Server
career advise
Since you are a recent graduate, the best course of action to to learn the business side of the industry. Regardless of your technical background, industry knowledge is the key to a successful career. You may find that the industry of your field does not interest you and you may want to change to another [...]
View Answer
| September 20, 2006 8:48 AM
Basis, Career development, Certifications, CRM, DataManagement, SAP careers, Training
Since you are a recent graduate, the best course of action to to learn the business side of the industry. Regardless of your technical background, industry knowledge is the key to a successful career. You may find that the industry of your field does not interest you and you may want to change to another [...]
View Answer
| September 20, 2006 8:48 AM
Basis, Career development, Certifications, CRM, DataManagement, SAP careers, Training
Data migration strategies-2
Hi We have brought on live data from 9 seperate companies onto our iseries. We loaded the data into excel and then used MS access to link the data to the iseries files using ODBC drivers. This meant that the field names are cross referenced within access. The only difficulty we did have was with [...]
View Answer
| September 5, 2006 6:43 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
Hi We have brought on live data from 9 seperate companies onto our iseries. We loaded the data into excel and then used MS access to link the data to the iseries files using ODBC drivers. This meant that the field names are cross referenced within access. The only difficulty we did have was with [...]
View Answer
| September 5, 2006 6:43 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
Data migration strategies
The strategy you propose is error-prone. Instead, write a script to do one or more INSERT SELECTs from one schema into the other. Check your work. If the second schema was loaded properly, COMMIT it. If not, ROLL it BACK, modify your script, and execute again. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linker.com) 800-315-1174 [...]
View Answer
| September 5, 2006 4:23 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
The strategy you propose is error-prone. Instead, write a script to do one or more INSERT SELECTs from one schema into the other. Check your work. If the second schema was loaded properly, COMMIT it. If not, ROLL it BACK, modify your script, and execute again. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linker.com) 800-315-1174 [...]
View Answer
| September 5, 2006 4:23 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
SECURE FTP SITE ON Windows 2003
You’ve stumbled across something that a lot of us deal with in the MS world when trying to accomplish this. From my personal experience with it I would do one of two things: 1)Consider using a standard FTP server with pgp encrypted files. 2)Consider using a third party product as you already have one of [...]
View Answer
| September 1, 2006 9:14 AM
3Com, Access, Access control, Application security, Availability, backdoors, Bandwidth, BEA, Biometrics, BroadVision, Browsers, Cabling, Cisco, Citrix Systems, Compliance, configuration, Corporate portal applications, CRM, Current threats, Database, DataCenter, Desktops, Development, Digital certificates, Disaster Recovery, Encryption, Epicentric, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, Oracle, OS, Patch management, patching, PEN testing, PeopleSoft, Performance management, Ping, Platform Security, Plumtree, Policies, provisioning, Risk management, Routers, SAP, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Switches, Sybase, TIBCO, Trojans, Viruses, VPN, vulnerability management, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
You’ve stumbled across something that a lot of us deal with in the MS world when trying to accomplish this. From my personal experience with it I would do one of two things: 1)Consider using a standard FTP server with pgp encrypted files. 2)Consider using a third party product as you already have one of [...]
View Answer
| September 1, 2006 9:14 AM
3Com, Access, Access control, Application security, Availability, backdoors, Bandwidth, BEA, Biometrics, BroadVision, Browsers, Cabling, Cisco, Citrix Systems, Compliance, configuration, Corporate portal applications, CRM, Current threats, Database, DataCenter, Desktops, Development, Digital certificates, Disaster Recovery, Encryption, Epicentric, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, Oracle, OS, Patch management, patching, PEN testing, PeopleSoft, Performance management, Ping, Platform Security, Plumtree, Policies, provisioning, Risk management, Routers, SAP, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Switches, Sybase, TIBCO, Trojans, Viruses, VPN, vulnerability management, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
Software based WIN Simulation
NISTnet will do what you want on Linxu. http://www-x.antd.nist.gov/nistnet/
View Answer
| August 30, 2006 9:50 AM
Availability, Bandwidth, Benchmarking, Cabling, Cisco, Data analysis, Desktops, Development, Fault isolation, Foundry, Hardware, Hubs, Linux, Management, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network testing, Networking, Nortel, Oracle, OS, Performance management, Protocol analysis, Remote management, Routers, SAP, Security, Servers, Software testing, SQL Server, Switches
NISTnet will do what you want on Linxu. http://www-x.antd.nist.gov/nistnet/
View Answer
| August 30, 2006 9:50 AM
Availability, Bandwidth, Benchmarking, Cabling, Cisco, Data analysis, Desktops, Development, Fault isolation, Foundry, Hardware, Hubs, Linux, Management, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network testing, Networking, Nortel, Oracle, OS, Performance management, Protocol analysis, Remote management, Routers, SAP, Security, Servers, Software testing, SQL Server, Switches
Data Warehouse – ‘thin layer’ or snapshots?
What we have done is a hybrid between your 2 options. Our customer information is maintained in a master database that stores all their attributes and is updated regularly. We have data marts containing sales and/or activity data pertaining to each customer that are refreshed with 24 months (106 weeks) of data as the data [...]
View Answer
| August 28, 2006 12:32 PM
Data mining/analysis, Data warehousing applications
What we have done is a hybrid between your 2 options. Our customer information is maintained in a master database that stores all their attributes and is updated regularly. We have data marts containing sales and/or activity data pertaining to each customer that are refreshed with 24 months (106 weeks) of data as the data [...]
View Answer
| August 28, 2006 12:32 PM
Data mining/analysis, Data warehousing applications
terminal server and gpo
I have been using a program called ScriptLogic that addresses what you wish to accomplish. I am able to set up desktops, outlook settings and other profile type settings that you can customize by user, groups, and even the type of login source (OS, workstation, server, etc… ) Check it out at ScriptLogic.com. I am [...]
View Answer
| August 6, 2006 9:49 AM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
I have been using a program called ScriptLogic that addresses what you wish to accomplish. I am able to set up desktops, outlook settings and other profile type settings that you can customize by user, groups, and even the type of login source (OS, workstation, server, etc… ) Check it out at ScriptLogic.com. I am [...]
View Answer
| August 6, 2006 9:49 AM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Cannot copy from CD…
Failure to read from ‘SPECIFIC’ cd. Not a drive problem and not a CD problem. I have seen this twice where the memory fas faulty. The restore process loads thousands of small files without problems. But installing ‘Works’ or ‘Office 2k3′ or any other major program puhes the operation into a bad memory space and [...]
View Answer
| July 27, 2006 12:13 PM
Data analysis, Hardware, Interoperability, Software, Tech support
Failure to read from ‘SPECIFIC’ cd. Not a drive problem and not a CD problem. I have seen this twice where the memory fas faulty. The restore process loads thousands of small files without problems. But installing ‘Works’ or ‘Office 2k3′ or any other major program puhes the operation into a bad memory space and [...]
View Answer
| July 27, 2006 12:13 PM
Data analysis, Hardware, Interoperability, Software, Tech support
Dimensions – COMBINATION or SEPERATION
(1) Never place two pieces of data in one field. So, the type should be a separate field. (2) You can write the least code, and have the least initial and maintenance cost, by NOT duplicating things. Thus, the single “Dim”, or record type, struct, or class with all of the fields will do. Extra [...]
View Answer
| July 26, 2006 11:44 AM
Data warehousing applications
(1) Never place two pieces of data in one field. So, the type should be a separate field. (2) You can write the least code, and have the least initial and maintenance cost, by NOT duplicating things. Thus, the single “Dim”, or record type, struct, or class with all of the fields will do. Extra [...]
View Answer
| July 26, 2006 11:44 AM
Data warehousing applications
BOBJ OLAPI TOTALS PROBLEM
My question is: How are you breaking this total? Are you trying to total before the information is available? And how are you getting this info?
View Answer
| July 5, 2006 2:53 PM
Business Objects, Data warehousing applications, Microsoft Windows
My question is: How are you breaking this total? Are you trying to total before the information is available? And how are you getting this info?
View Answer
| July 5, 2006 2:53 PM
Business Objects, Data warehousing applications, Microsoft Windows
SQL Server Integration Services – Pivot Transformation
You need to group the results by fld1, fld2, fld3, and also sum the fields feb, mar, apr, i.e. select fld1, fld2, fld3, sum(…statements to create feb field) as feb, sum(…. ) as mar, sum(…) as apr group by fld1, fld2, fld3 and optionally: order by fld1, fld2, fld3 Hope this helps.
View Answer
| June 30, 2006 5:03 AM
Data warehousing applications, Microsoft Windows, SQL Server
You need to group the results by fld1, fld2, fld3, and also sum the fields feb, mar, apr, i.e. select fld1, fld2, fld3, sum(…statements to create feb field) as feb, sum(…. ) as mar, sum(…) as apr group by fld1, fld2, fld3 and optionally: order by fld1, fld2, fld3 Hope this helps.
View Answer
| June 30, 2006 5:03 AM
Data warehousing applications, Microsoft Windows, SQL Server
