Remore RS232 Control
Good Day All I wondered if anyone knows how to remotely access and control RS23 devices. I will give you my example. I have a PC which is attached to 2 RS232 devices. I would like to have some form of control of the devices attached to the PC from a remote location, like a [...]
Answer Question
| December 7, 2005 6:25 AM
Cabling, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Mobile, Networking, Networking services, Oracle, OS, Project management, Security, Servers, Software, SQL, SQL Server, Tech support, Wireless
Good Day All I wondered if anyone knows how to remotely access and control RS23 devices. I will give you my example. I have a PC which is attached to 2 RS232 devices. I would like to have some form of control of the devices attached to the PC from a remote location, like a [...]
Answer Question
| December 7, 2005 6:25 AM
Cabling, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Mobile, Networking, Networking services, Oracle, OS, Project management, Security, Servers, Software, SQL, SQL Server, Tech support, Wireless
What is correct syntax for SQL for Maxrecords in OS400/DB2?
What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn’t recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM “TRNGDATA1″.”OICRT1″ FETCH FIRST 1 ROWS ONLY However the standard [...]
Answer Question
| November 20, 2009 12:10 PM
AS/400, DB2 Universal Database, SQL Server
What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn’t recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM “TRNGDATA1″.”OICRT1″ FETCH FIRST 1 ROWS ONLY However the standard [...]
Answer Question
| November 20, 2009 12:10 PM
AS/400, DB2 Universal Database, SQL Server
VPn solution required for remote IP telephony
We would like to have remote ip telephony connectivity for our office so that it will be helpful for our remote users and our Royal customers to have ip soft phone which will be connected to our network through VPN tunnel to our IP PABX and dial out locally. We are having ADSL modem connectivity [...]
Answer Question
| November 27, 2005 11:40 AM
Application security, Availability, Cabling, Database, Encryption, Exchange, Firewalls, Forensics, Hardware, Hubs, Incident response, Instant Messaging, Intrusion management, Network security, Networking, Nortel, Routers, Secure Coding, Security, Switches, VoIP, VPN, Wireless
We would like to have remote ip telephony connectivity for our office so that it will be helpful for our remote users and our Royal customers to have ip soft phone which will be connected to our network through VPN tunnel to our IP PABX and dial out locally. We are having ADSL modem connectivity [...]
Answer Question
| November 27, 2005 11:40 AM
Application security, Availability, Cabling, Database, Encryption, Exchange, Firewalls, Forensics, Hardware, Hubs, Incident response, Instant Messaging, Intrusion management, Network security, Networking, Nortel, Routers, Secure Coding, Security, Switches, VoIP, VPN, Wireless
Regarding Oracle connectivity issues
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB [...]
Answer Question
| November 29, 2005 7:51 PM
Database, DB2, Oracle, SQL, Windows
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB [...]
Answer Question
| November 29, 2005 7:51 PM
Database, DB2, Oracle, SQL, Windows
DB2 Joins
Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID LEFT OUTER JOIN RSTHSTP ON RSINDIP.INICID=RSTHSTP.TVICID Thanks,
Answer Question
| November 23, 2005 5:22 PM
DB2 Universal Database
Can someone explain the order this join specification will be performed in? RSINDIP LEFT OUTER JOIN RSINDPP ON RSINDIP.INICID=RSINDPP.IPICID LEFT OUTER JOIN MKEMLAP ON RSINDIP.INCID=MKEMLAP.ELEMIC LEFT OUTER JOIN MKIPRMP ON RSINDIP.INICID=MKIPRMP.IKICID LEFT OUTER JOIN RSTHSTP ON RSINDIP.INICID=RSTHSTP.TVICID Thanks,
Answer Question
| November 23, 2005 5:22 PM
DB2 Universal Database
Indexing on Large table
Hi, Is indexing on 5 keys of a table containing 100 fields more slower than indexing on same 5 keys of a table containing 150 fields. Both the tables (one containing 150 fields and other containing 100 fields) are similar except the 50 attributes which are redundant. Suppose there are 2 attributes common to both [...]
Answer Question
| November 23, 2005 8:08 AM
Database, DB2, Oracle
Hi, Is indexing on 5 keys of a table containing 100 fields more slower than indexing on same 5 keys of a table containing 150 fields. Both the tables (one containing 150 fields and other containing 100 fields) are similar except the 50 attributes which are redundant. Suppose there are 2 attributes common to both [...]
Answer Question
| November 23, 2005 8:08 AM
Database, DB2, Oracle
Using Query returned values in Oracle Graphics 6i
Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the colors dynamically to the sub-categories based on the [...]
Answer Question
| November 28, 2005 7:08 AM
Billing and customer care, Billing Support Systems, Business/IT alignment, Career development, Database, DB2, Desktops, Development, Financials, Human Resources, Intelligence, Interaction Center Technology, Maintenance Management, Management, Manufacturing, Marketing/Sales, Microsoft Windows, Oracle, Order Management, OS, Procurement, Product Lifecycle Management, Project management, Projects, Security, Servers, Service, Software, SQL, SQL Server, Supply Chain Planning, Training
Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the colors dynamically to the sub-categories based on the [...]
Answer Question
| November 28, 2005 7:08 AM
Billing and customer care, Billing Support Systems, Business/IT alignment, Career development, Database, DB2, Desktops, Development, Financials, Human Resources, Intelligence, Interaction Center Technology, Maintenance Management, Management, Manufacturing, Marketing/Sales, Microsoft Windows, Oracle, Order Management, OS, Procurement, Product Lifecycle Management, Project management, Projects, Security, Servers, Service, Software, SQL, SQL Server, Supply Chain Planning, Training
SQL Server 2005 adoption
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than [...]
Answer Question
| November 23, 2005 3:36 PM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than [...]
Answer Question
| November 23, 2005 3:36 PM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
Group Policy Management
Has anyone looked into Group Policy Management products (outisde of the functionality provided by Microsoft’s Active Directory)? I’m trying to choose a product, and wanted to compare based on what current users thought (rather than what the sales departments tell me). The products I’ve been able to identify so far are FullArmor’s GPAnywhere and Intellipolicy [...]
Answer Question
| November 22, 2005 2:54 PM
Application security, Compliance, configuration, CRM, Database, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, VPN, vulnerability management, Wireless
Has anyone looked into Group Policy Management products (outisde of the functionality provided by Microsoft’s Active Directory)? I’m trying to choose a product, and wanted to compare based on what current users thought (rather than what the sales departments tell me). The products I’ve been able to identify so far are FullArmor’s GPAnywhere and Intellipolicy [...]
Answer Question
| November 22, 2005 2:54 PM
Application security, Compliance, configuration, CRM, Database, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, VPN, vulnerability management, Wireless
AOL Spammer IP Identification
Concerning the ever increasing amount of received spam, to battle this I have a program with which I can extract the IP address from the sender for reporting purposes, however, I have been receiving an increasing amount from AOL proxy server for which I cannot aquire the senders IP address. Is there another way I [...]
Answer Question
| November 20, 2005 11:56 AM
Access control, Active Directory, Application security, Availability, backdoors, Bandwidth, Bind, Biometrics, Browsers, Cabling, Compliance, configuration, CRM, Current threats, Database, DataCenter, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Encryption, Exchange, filtering, Firewalls, Forensics, General Directories, Hacking, Hardware, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Interoperability, Intrusion management, Lotus Domino, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network security, Network testing, Networking, Networking services, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Protocol analysis, provisioning, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Concerning the ever increasing amount of received spam, to battle this I have a program with which I can extract the IP address from the sender for reporting purposes, however, I have been receiving an increasing amount from AOL proxy server for which I cannot aquire the senders IP address. Is there another way I [...]
Answer Question
| November 20, 2005 11:56 AM
Access control, Active Directory, Application security, Availability, backdoors, Bandwidth, Bind, Biometrics, Browsers, Cabling, Compliance, configuration, CRM, Current threats, Database, DataCenter, Development, DHCP, Digital certificates, Disaster Recovery, DNS, Encryption, Exchange, filtering, Firewalls, Forensics, General Directories, Hacking, Hardware, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Interoperability, Intrusion management, Lotus Domino, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network security, Network testing, Networking, Networking services, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Protocol analysis, provisioning, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Software, Spyware, SSL/TLS, Switches, Tech support, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2
I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I [...]
Answer Question
| November 22, 2005 5:36 PM
3Com, Active Directory, ActiveX, Administration, Apache, Automated, Availability, BASIC, Benchmarking, Business Objects, C, Cabling, Cape Clear Cape Connect, Career development, Cisco, Clustering, Cognos, Crystal Reports, Data analysis, Data Junction, Data management and storage, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Dell, Desktop management applications, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterprise Desktop, Ethernet, Fault isolation, Fax and print management, FDDI, File, Frame Relay, Functional, H.323, Hardware, Hardware selection and management, Hewlett-Packard, Hewlett-Packard Application Server, Hubs, Hyperion, IBM, Informatica, Information Builders, Interoperability, Lifecycle development, Linux, Lotus Domino, Management, Manufacturing applications, Microprocessors, Microsoft Systems Management Server, Microsoft Windows, Migrations and upgrades, Monitoring, NCR, NCR/Teradata, Network applications management, Network connectivity, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NIC, Novell IPX/SPX, Oracle, OS, Performance and availability, Performance management, Performance/Load, Ping, Power management, Printers, Programming Languages, Protocol analysis, Remote management, Routers, SAP, SAS Institute, Security, Servers, Software, Software testing, Software testing tools, SPSS, SQL Server, standards, Storage, Switches, Systems management software, TCP, Tech support, Thermal controls
I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I [...]
Answer Question
| November 22, 2005 5:36 PM
3Com, Active Directory, ActiveX, Administration, Apache, Automated, Availability, BASIC, Benchmarking, Business Objects, C, Cabling, Cape Clear Cape Connect, Career development, Cisco, Clustering, Cognos, Crystal Reports, Data analysis, Data Junction, Data management and storage, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Dell, Desktop management applications, Desktops, Development, DHCP, Distribution/logistics applications, DNS, Enterprise Desktop, Ethernet, Fault isolation, Fax and print management, FDDI, File, Frame Relay, Functional, H.323, Hardware, Hardware selection and management, Hewlett-Packard, Hewlett-Packard Application Server, Hubs, Hyperion, IBM, Informatica, Information Builders, Interoperability, Lifecycle development, Linux, Lotus Domino, Management, Manufacturing applications, Microprocessors, Microsoft Systems Management Server, Microsoft Windows, Migrations and upgrades, Monitoring, NCR, NCR/Teradata, Network applications management, Network connectivity, Network management software, Network monitoring, Network protocols, Network testing, Networking, Networking services, NIC, Novell IPX/SPX, Oracle, OS, Performance and availability, Performance management, Performance/Load, Ping, Power management, Printers, Programming Languages, Protocol analysis, Remote management, Routers, SAP, SAS Institute, Security, Servers, Software, Software testing, Software testing tools, SPSS, SQL Server, standards, Storage, Switches, Systems management software, TCP, Tech support, Thermal controls
sql query
There are 2 tables POLICY and NAME. The relationship between Policy and name is only the policy number. and ther relation ship is like many to one. I mean several policy number can have same name in the name table with that many records. Now my question is to find out the policy numbers having [...]
Answer Question
| November 18, 2005 11:36 AM
Database, DB2, Oracle
There are 2 tables POLICY and NAME. The relationship between Policy and name is only the policy number. and ther relation ship is like many to one. I mean several policy number can have same name in the name table with that many records. Now my question is to find out the policy numbers having [...]
Answer Question
| November 18, 2005 11:36 AM
Database, DB2, Oracle
How to operating with Multiple Member PF in RPG ?
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with compilation [...]
Answer Question
| November 20, 2009 12:06 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with compilation [...]
Answer Question
| November 20, 2009 12:06 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Printek printer using tcpip
What does the spool file need to look like to print a barcode on a printek 4305 se printer? I cant figure out how to send the hex command to the printer so it understands that it is a command not just text.
Answer Question
| November 17, 2005 1:49 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
What does the spool file need to look like to print a barcode on a printek 4305 se printer? I cant figure out how to send the hex command to the printer so it understands that it is a command not just text.
Answer Question
| November 17, 2005 1:49 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Memory (helpfield) usage in Microsoft Access with VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA [...]
Answer Question
| November 17, 2005 7:59 AM
Access, Database, DB2, Oracle, VBA
Microsoft Access software is running on the desktop of every user, but the database is installed centrally on a server. More users can start and run on the same database simultaneously. In VBA I have various helpfields defined. What I want to know is: if more users are in the same part of the VBA [...]
Answer Question
| November 17, 2005 7:59 AM
Access, Database, DB2, Oracle, VBA
rpg
We just upgraded to an iSeries box with 5.3. We were running 4.6. My RPG programs function properly until I recompile the program. Then I get an compile error 7073 regarding the length of a key field not equal. The compile shows BIN2 (and sometimes multiples) after the other key fields and I can’t get [...]
Answer Question
| November 20, 2009 3:06 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
We just upgraded to an iSeries box with 5.3. We were running 4.6. My RPG programs function properly until I recompile the program. Then I get an compile error 7073 regarding the length of a key field not equal. The compile shows BIN2 (and sometimes multiples) after the other key fields and I can’t get [...]
Answer Question
| November 20, 2009 3:06 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Delete maximum records in a table
Hi! I need to Delete maximum records in a table that has 2 columns, such as Ord No. & Part No. Each Part No. can have many Ord Nos. I need to identify the Maximum Ord No per part No & delete the record from the table. Help would be much appreciated! Sarj
Answer Question
| November 23, 2005 11:29 PM
Database, DB2, Oracle
Hi! I need to Delete maximum records in a table that has 2 columns, such as Ord No. & Part No. Each Part No. can have many Ord Nos. I need to identify the Maximum Ord No per part No & delete the record from the table. Help would be much appreciated! Sarj
Answer Question
| November 23, 2005 11:29 PM
Database, DB2, Oracle
Database Diagram Tool
Does anyone know of a free database diagram tool? I downloaded DBDesigner 4 (http://www.fabforce.net/dbdesigner4/), but it’s not working the way I would like. I could just create them in Access but that isn’t really ideal. I want to create diagrams of an existing database, not to create a new schema from scratch. Thanks in advance!
Answer Question
| February 22, 2012 4:00 PM
Data analysis, Data warehousing applications, Database, DB2, Oracle
Does anyone know of a free database diagram tool? I downloaded DBDesigner 4 (http://www.fabforce.net/dbdesigner4/), but it’s not working the way I would like. I could just create them in Access but that isn’t really ideal. I want to create diagrams of an existing database, not to create a new schema from scratch. Thanks in advance!
Answer Question
| February 22, 2012 4:00 PM
Data analysis, Data warehousing applications, Database, DB2, Oracle
database down
can anybody tell me how to know “Exactly at what time the database has gone down
Answer Question
| November 15, 2005 3:14 AM
Database, DB2, Oracle
can anybody tell me how to know “Exactly at what time the database has gone down
Answer Question
| November 15, 2005 3:14 AM
Database, DB2, Oracle
Help running interactive SQL statement
This user recently upgraded from V4R5 to V5R2, and now they’re having difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) Previously this returned the following result: 674 rows updated in MSPMP100 [...]
Answer Question
| November 15, 2005 9:30 PM
DB2 Universal Database
This user recently upgraded from V4R5 to V5R2, and now they’re having difficulty running an interactive SQL statement that worked fine at R4R5. The statement is as follows: update grmlib/mspmp100 as t1 set pmfp2=(select pmfp2 from grmlib/sin gupl2 as t2 where t1.prdno=t2.prdno and t2.pmfp2<>0) Previously this returned the following result: 674 rows updated in MSPMP100 [...]
Answer Question
| November 15, 2005 9:30 PM
DB2 Universal Database
