FTP
FTP is only for text data. it’s yoour job to give to ftp a transferable file, ie no binary data (such as packed numeric or integer or float or …). Or uses BIN mode to transfer data
View Answer
| March 15, 2006 3:55 PM
DB2 Universal Database
FTP is only for text data. it’s yoour job to give to ftp a transferable file, ie no binary data (such as packed numeric or integer or float or …). Or uses BIN mode to transfer data
View Answer
| March 15, 2006 3:55 PM
DB2 Universal Database
SQL server replication
What are you using to replicate the database? Is there a publisher / subscriber model or maybe a backup is being restored nightly? This information will help determine where the differences could be.
View Answer
| March 14, 2006 11:10 AM
Database, DB2, Oracle
What are you using to replicate the database? Is there a publisher / subscriber model or maybe a backup is being restored nightly? This information will help determine where the differences could be.
View Answer
| March 14, 2006 11:10 AM
Database, DB2, Oracle
Visual Basic
VBA is for scripting (withing an application). VB.NET is a whole development platform
View Answer
| March 12, 2006 3:15 AM
Database, DB2, Oracle, SQL, Web services, Web site design & management
VBA is for scripting (withing an application). VB.NET is a whole development platform
View Answer
| March 12, 2006 3:15 AM
Database, DB2, Oracle, SQL, Web services, Web site design & management
Doubts regarding speed in data access
The fastest possible way is to use a compiled language, with this logic flow: Have a large, static array of record buffers Open the input as a streamed (Unix or OS/400) or double-buffered (zOS) file. Loop Read a record Leave the loop if EOF Validate the record If passed Store its values into the array [...]
View Answer
| March 10, 2006 1:59 AM
Database, DB2, Java/J2EE, Oracle, SQL, Windows
The fastest possible way is to use a compiled language, with this logic flow: Have a large, static array of record buffers Open the input as a streamed (Unix or OS/400) or double-buffered (zOS) file. Loop Read a record Leave the loop if EOF Validate the record If passed Store its values into the array [...]
View Answer
| March 10, 2006 1:59 AM
Database, DB2, Java/J2EE, Oracle, SQL, Windows
Explanation & remedy for Web-based Attack
Is your machine open to the Internet? What protections do you load onto it? How is it firewalled? In short, what kind of access is available? An unprotected machine facing the Interet can become infected in 15 minutes according to reports I have read. You need to provide protections to avoid tis from happening. Firewall [...]
View Answer
| March 9, 2006 12:25 AM
Access control, Application security, backdoors, Browsers, configuration, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Secure Coding, Security, Servers, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Is your machine open to the Internet? What protections do you load onto it? How is it firewalled? In short, what kind of access is available? An unprotected machine facing the Interet can become infected in 15 minutes according to reports I have read. You need to provide protections to avoid tis from happening. Firewall [...]
View Answer
| March 9, 2006 12:25 AM
Access control, Application security, backdoors, Browsers, configuration, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Secure Coding, Security, Servers, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Capture screen w/scrolling marquee
Not easy – screen captures are just that – still pictures. 1 – try ‘Screen Grab Pro’ and capture as many screens as possible during marquee transit. 2 – Macromedia ‘Captivate’ and create a Flash movie. 3 – Streaming video capture to a ‘Windows Media Format’. Good Luck.
View Answer
| March 7, 2006 4:07 PM
Billing and customer care, Billing Support Systems, Call Centers, Career development, CRM, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, Development, E-business, Hardware, IBM, Lifecycle development, Management, Microsoft Windows, NCR, Networking, Oracle, OS, Project management, Sales force automation applications, Security, Servers, Software, Software Quality Assurance, SQL Server, Storage, Tech support, Web services, Web Services Standards
Not easy – screen captures are just that – still pictures. 1 – try ‘Screen Grab Pro’ and capture as many screens as possible during marquee transit. 2 – Macromedia ‘Captivate’ and create a Flash movie. 3 – Streaming video capture to a ‘Windows Media Format’. Good Luck.
View Answer
| March 7, 2006 4:07 PM
Billing and customer care, Billing Support Systems, Call Centers, Career development, CRM, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, Development, E-business, Hardware, IBM, Lifecycle development, Management, Microsoft Windows, NCR, Networking, Oracle, OS, Project management, Sales force automation applications, Security, Servers, Software, Software Quality Assurance, SQL Server, Storage, Tech support, Web services, Web Services Standards
Numeric values search from alphanumeric column of DB2
You can try this: Select columns from table where numeric value of columncolumn between numeric1 and numeric2 Note: values of numeric1 and numeric2 depend of the type you are using integer, smallint, decimal, etc
View Answer
| March 7, 2006 9:11 AM
Database, DB2, Oracle
You can try this: Select columns from table where numeric value of columncolumn between numeric1 and numeric2 Note: values of numeric1 and numeric2 depend of the type you are using integer, smallint, decimal, etc
View Answer
| March 7, 2006 9:11 AM
Database, DB2, Oracle
Updating Access Database Structure At Run-Time
I use a seperate access program to update the front ends. The prog has one form with one button on it called “Install Upgrade”. This button then runs VBA code or Queries to update either the FE or BE tables etc. Below is an example of the VBA to add a new field. Function AddNumField() [...]
View Answer
| March 7, 2006 6:09 AM
Database, DB2, Development, Oracle, Visual Basic
I use a seperate access program to update the front ends. The prog has one form with one button on it called “Install Upgrade”. This button then runs VBA code or Queries to update either the FE or BE tables etc. Below is an example of the VBA to add a new field. Function AddNumField() [...]
View Answer
| March 7, 2006 6:09 AM
Database, DB2, Development, Oracle, Visual Basic
Retrieving Job Info
The List Job (QUSLJOB) API generates a list of all or some jobs on the system. The generated list replaces any existing list in the user space. The QUSLJOB API produces a list similar to the list produced by the Work with User Job (WRKUSRJOB) command. http://publib.boulder.ibm.com/iseries/v5r2/ic2928/index.htm?info/rzahgicmain.htm here after, a sample in CLP. I have [...]
View Answer
| March 4, 2006 12:22 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development
The List Job (QUSLJOB) API generates a list of all or some jobs on the system. The generated list replaces any existing list in the user space. The QUSLJOB API produces a list similar to the list produced by the Work with User Job (WRKUSRJOB) command. http://publib.boulder.ibm.com/iseries/v5r2/ic2928/index.htm?info/rzahgicmain.htm here after, a sample in CLP. I have [...]
View Answer
| March 4, 2006 12:22 PM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE, Web development
Replicating data between I-series and Ms-CRM using Scribe?
We’re in the process of doing the same thing right now. I’ve setup an ODBC connection (using iSeries Access) on the server that Scribe is running on, and delivered a prototype SQL statement to our contractors for the tables that they need to access. I used the SQL script environment in iSeries Access to generate, [...]
View Answer
| March 1, 2006 8:58 AM
AS/400, CLP, CRM, DataCenter, DB2 Universal Database, PC/Windows Connectivity, SQL, SQL Server
We’re in the process of doing the same thing right now. I’ve setup an ODBC connection (using iSeries Access) on the server that Scribe is running on, and delivered a prototype SQL statement to our contractors for the tables that they need to access. I used the SQL script environment in iSeries Access to generate, [...]
View Answer
| March 1, 2006 8:58 AM
AS/400, CLP, CRM, DataCenter, DB2 Universal Database, PC/Windows Connectivity, SQL, SQL Server
Blocking music on internet connection
Hi, You might want to create an ACL (access list) to block the address of the website or filter the web address, to the music site, on the pc’s. A great port blocking software is www.kerio.com
View Answer
| February 27, 2006 8:10 PM
3Com, Access control, Application security, Availability, Avaya, backdoors, Bandwidth, Benchmarking, Browsers, Cabling, Cisco, Compliance, CRM, Current threats, Database, DataCenter, Development, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Microsoft Office, Mobile security, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Network testing, Networking, Patch management, Performance management, Ping, Policies, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VPN, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
Hi, You might want to create an ACL (access list) to block the address of the website or filter the web address, to the music site, on the pc’s. A great port blocking software is www.kerio.com
View Answer
| February 27, 2006 8:10 PM
3Com, Access control, Application security, Availability, Avaya, backdoors, Bandwidth, Benchmarking, Browsers, Cabling, Cisco, Compliance, CRM, Current threats, Database, DataCenter, Development, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Microsoft Office, Mobile security, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Network testing, Networking, Patch management, Performance management, Ping, Policies, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VPN, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
Blocking Music on Internet connection
Hello Do you have isa server?
View Answer
| February 27, 2006 6:03 PM
3Com, Access control, Application security, Availability, Avaya, backdoors, Bandwidth, Benchmarking, Browsers, Cabling, Cisco, Compliance, CRM, Current threats, Database, DataCenter, Development, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Microsoft Office, Mobile security, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Network testing, Networking, Patch management, Performance management, Ping, Policies, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VPN, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
Hello Do you have isa server?
View Answer
| February 27, 2006 6:03 PM
3Com, Access control, Application security, Availability, Avaya, backdoors, Bandwidth, Benchmarking, Browsers, Cabling, Cisco, Compliance, CRM, Current threats, Database, DataCenter, Development, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Microsoft Office, Mobile security, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Network testing, Networking, Patch management, Performance management, Ping, Policies, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VPN, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
Zebra printer will not print CORRECTLY through Oracle application(s)
is there a printer font that is missing from the oracle program?
View Answer
| February 27, 2006 9:40 AM
Aspen Technology, Baan, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Distribution/logistics applications, Hardware, i2 Technologies, IBM, Interoperability, Management, Manufacturing applications, Manugistics, Microsoft .NET, Microsoft BizTalk Server, Microsoft Internet Information Server, Microsoft Windows, NCR, Online transaction processing, Oracle, Oracle Application Server, Oracle Manufacturing, OS, PeopleSoft, Printers, QAD, SalesLogix, SAP, SAS Institute, SDRC/EDS, Security, Servers, Siebel, SQL Server, Supply chain management applications, Tech support, Windows
is there a printer font that is missing from the oracle program?
View Answer
| February 27, 2006 9:40 AM
Aspen Technology, Baan, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Distribution/logistics applications, Hardware, i2 Technologies, IBM, Interoperability, Management, Manufacturing applications, Manugistics, Microsoft .NET, Microsoft BizTalk Server, Microsoft Internet Information Server, Microsoft Windows, NCR, Online transaction processing, Oracle, Oracle Application Server, Oracle Manufacturing, OS, PeopleSoft, Printers, QAD, SalesLogix, SAP, SAS Institute, SDRC/EDS, Security, Servers, Siebel, SQL Server, Supply chain management applications, Tech support, Windows
Allowing IE to Install Selected Software
you shoul use the javascript oblect open tag OBJECT id=factory style=”DISPLAY: none” codeBase=http://localhost/xxxx.exe classid=clsid:1663ed61-23eb-11d2-b92f-008048fdd814 viewastext OBJECT close the object tag I hope this will help you
View Answer
| February 23, 2006 10:24 AM
Access control, Application security, Browsers, Database, Development, Encryption, Exchange, filtering, Instant Messaging, Secure Coding, Security, Servers, SSL/TLS, Web security
you shoul use the javascript oblect open tag OBJECT id=factory style=”DISPLAY: none” codeBase=http://localhost/xxxx.exe classid=clsid:1663ed61-23eb-11d2-b92f-008048fdd814 viewastext OBJECT close the object tag I hope this will help you
View Answer
| February 23, 2006 10:24 AM
Access control, Application security, Browsers, Database, Development, Encryption, Exchange, filtering, Instant Messaging, Secure Coding, Security, Servers, SSL/TLS, Web security
Domino Installation in Linux
HI Did you log in as the notes user you used during installation script. You did login as root and run the install I am sure. Also did you run /opt/lotus/bin/checkos to make sure you have all the pre-regs
View Answer
| February 22, 2006 10:15 AM
Enterprise Desktop, Linux, Lotus Domino, MySQL, Platform Issues
HI Did you log in as the notes user you used during installation script. You did login as root and run the install I am sure. Also did you run /opt/lotus/bin/checkos to make sure you have all the pre-regs
View Answer
| February 22, 2006 10:15 AM
Enterprise Desktop, Linux, Lotus Domino, MySQL, Platform Issues
IPSec VPN Connection
Apart from all the other trouble a hacker would have to go through to orchestrate this attack, it relies on the fact that the VPN is set to use MS-CHAP which is known to be weak. Set your VPN to use MS-CHAPv2 or some other more modern hash and you don’t really have anything to [...]
View Answer
| February 21, 2006 10:56 PM
Active Directory, Application security, Database, DataCenter, DHCP, DNS, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Microsoft Windows, Network management software, Network monitoring, Network security, Networking, Networking services, Performance management, Ping, Secure Coding, Security, VPN, Wireless
Apart from all the other trouble a hacker would have to go through to orchestrate this attack, it relies on the fact that the VPN is set to use MS-CHAP which is known to be weak. Set your VPN to use MS-CHAPv2 or some other more modern hash and you don’t really have anything to [...]
View Answer
| February 21, 2006 10:56 PM
Active Directory, Application security, Database, DataCenter, DHCP, DNS, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Microsoft Windows, Network management software, Network monitoring, Network security, Networking, Networking services, Performance management, Ping, Secure Coding, Security, VPN, Wireless
Fixing violation errors found with CHKOBJITG
Is this IBM 4690 Code for business grade? If so IBM has a site and I would start there. http://www-1.ibm.com/support/docview.wss?rs=0&q1=4800&uid=pos1R4000072&loc=en_US&cs=utf-8&cc=us&lang=en Good luck. Marie
View Answer
| February 14, 2006 11:02 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Is this IBM 4690 Code for business grade? If so IBM has a site and I would start there. http://www-1.ibm.com/support/docview.wss?rs=0&q1=4800&uid=pos1R4000072&loc=en_US&cs=utf-8&cc=us&lang=en Good luck. Marie
View Answer
| February 14, 2006 11:02 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
File size for DB2/iSeries
so big !?! are you sure ? it’s not a textpad, it’s a database. today’s unit of count is not the byte but the megabyte. How many giga in your PC ? probably more than in your I5
View Answer
| February 10, 2006 1:51 PM
DB2 Universal Database
so big !?! are you sure ? it’s not a textpad, it’s a database. today’s unit of count is not the byte but the megabyte. How many giga in your PC ? probably more than in your I5
View Answer
| February 10, 2006 1:51 PM
DB2 Universal Database
adding partition to existing non-partitioned table
Hello: The ‘AS SELECT…’ clause should be the last part of the CREATE TABLE … PARTITION. Try this: create table quote_header_test partition by range (ordered_date) partition less_jul2004 values less than (to_date(’01-JUL-2004′,’MON-DD-YYYY’)) as select * from quote_header; Good Luck
View Answer
| February 8, 2006 6:42 AM
Database, DB2, Oracle, SQL
Hello: The ‘AS SELECT…’ clause should be the last part of the CREATE TABLE … PARTITION. Try this: create table quote_header_test partition by range (ordered_date) partition less_jul2004 values less than (to_date(’01-JUL-2004′,’MON-DD-YYYY’)) as select * from quote_header; Good Luck
View Answer
| February 8, 2006 6:42 AM
Database, DB2, Oracle, SQL
Database Implementation
In order for you to decide on a Database Software Implementation requires that you fully understand the business needs and what the Database should provide to them. I would recommend that you try to understand the general aspects of business needs before you actually implement a Database Software or Project. Be careful, More functions and [...]
View Answer
| February 8, 2006 4:53 AM
Database, DB2, Oracle, Project management
In order for you to decide on a Database Software Implementation requires that you fully understand the business needs and what the Database should provide to them. I would recommend that you try to understand the general aspects of business needs before you actually implement a Database Software or Project. Be careful, More functions and [...]
View Answer
| February 8, 2006 4:53 AM
Database, DB2, Oracle, Project management
