MySQL Questions


iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]

Answer Question   |  October 14, 2010  10:35 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML
asked by:
0 pts.

Network Resource Allocation cum Planning cum Technical Problem
This is the real commercial problem face by my company. Well, the reason I ask this problem is I salute and respect all of you as I believe all of you are as good as network solution company out there, or even better!! Lets me rephrase the entire problem again. Company expand so fast that [...]

Answer Question   |  May 22, 2006  10:17 AM
3Com, Access, Access control, Active Directory, Altiris, Application security, Availability, Avaya, backdoors, Bandwidth, Benchmarking, Bind, Biometrics, BMC, Browsers, Budgeting, Business/IT alignment, Cabling, Career development, Cisco, Compliance, Computer Associates, configuration, CRM, Current threats, Database, DataCenter, DB2, Dell, Desktop management applications, Desktops, DHCP, Digital certificates, Disaster Recovery, DNS, E-business, Encryption, Enterasys, Enterprise Desktop, Ethernet, Exchange, Fault isolation, FDDI, filtering, Firewalls, Forensics, Foundry, Frame Relay, General Directories, H.323, Hacking, Hardware, Hewlett-Packard, Hubs, human factors, IBM, IBM/Tivoli, Identity & Access Management, Incident response, Instant Messaging, Intel, Interoperability, InterSystems, Intrusion management, IPv4, IPv6, Juniper Networks, LANDesk, Laws, LDAP, Linux, Lotus Domino, Lucent, Management, Marimba, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, MPLS, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Network testing, Networking, Networking services, NFS, Nortel, Novell, Novell IPX/SPX, Novell NDS, Online transaction processing, Oracle, OS, Partner facing, Patch management, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Project management, Protocol analysis, provisioning, Regulations, Remote management, Risk management, ROI & cost justification, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, SIP, Software, Spyware, SQL, SQL Server, SSL/TLS, standards, Storage, Switches, Sybase, Systems management software, TCP, Tech support, Trojans, Unisys, Vector Networks, Vendors, Viruses, VPN, vulnerability management, Web security, WINS, Wireless, worms
asked by:
5 pts.

Mainframe to SAP
Hi, I’m a cobol programmer working on Mainframes with a work exp. of 2 yrs. I’ve worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the Industry, do you think [...]

Answer Question   |  October 31, 2011  6:40 AM
390, ABAP, Application development, AS/400, AS/400 careers, Backup & recovery, Basis, Billing and customer care, Billing Support Systems, Career development, Certifications, CLP, CO, Database, DB2, DB2 Universal Database, Development, ED, Email, Enterprise Desktop, FI, Financials, IBM Marketing Sound Off, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, Linux, Mainframe, MySAP, MySQL, NetWeaver, Oracle, PC/Windows Connectivity, RIVA, RPG, RPGLE, SAP, SAP APO, SAP careers, SEM, TR, Training, Upgrades / implementations, Windows, zSeries
asked by:
0 pts.

Domino Installation in Linux
Dear all WE have a problem while Configuring the Domino6.5 in a Linux 2.4 server. The installation of the Domino had finished sucessfully, then we start up the server by giving the command /opt/lotus/bin/server from the /local/notesdata directory. we get the error as below. line 124 : 9288(3241) segmentation fault What may be the problem. [...]

Answer Question   |  February 28, 2006  11:59 PM
Enterprise Desktop, Linux, Lotus Domino, MySQL, Platform Issues
asked by:
0 pts.

asked by:
0 pts.

Remote Syslog with MySQL and PHP
Dear All, i want to set up a Remote Syslog with MySQL and PHP on system with whitebox linux,can some tell me a step by step on how to install and configure this,also the requirement needed to complete the task Regards Edwin

Answer Question   |  December 22, 2005  4:43 AM
3Com, Active Directory, Availability, Avaya, Bandwidth, Benchmarking, Billing and customer care, Billing Support Systems, Bind, Cabling, Cisco, Dell, Development, DHCP, DNS, Enterasys, Enterprise Desktop, Ethernet, Fault isolation, FDDI, Foundry, Frame Relay, H.323, Hardware, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, Linux, Lucent, MPLS, MySQL, NetBIOS, Network management software, Network monitoring, Network protocols, Networking, Networking services, Nortel, Novell IPX/SPX, Performance management, Protocol analysis, Remote management, Routers, SIP, Switches, TCP
asked by:
0 pts.

Performance Optimisations
I need to optimize the DB for my Company web site expecially I need to be sure that I have all the right views. There is tool that analize the SQL request and propose to create the needed views? Thanks.

Answer Question   |  December 4, 2005  4:27 PM
MySQL
asked by:
0 pts.

internet cafe equipment
could anyone describe the equipment of an internet cafe and the purpose of each one?

Answer Question   |  September 23, 2005  6:18 AM
MySQL, Networking
asked by:
0 pts.

asked by:
0 pts.

Network neigbhorhood
Sir, I have a windows 2K advanced server running on HP Proliant ML350 G3. The problem is my network neighborhood does not open quickly. Same problem with control panel. It take a long time to open maybe 45 mins to 1 hour. I have uninstalled all the HP tools but installation takes place only through [...]

Answer Question   |  September 21, 2005  2:10 AM
Access, Active Directory, AS/400, Bind, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Help Desk, Linux, Lotus Domino, Management, Manufacturing applications, Microsoft Office, Microsoft Windows, MySQL, Network applications management, Network management software, Network monitoring, Network testing, Networking, Networking services, Oracle, OS, Patch management, Performance management, Ping, Remote management, Security, Servers, SQL, SQL Server, TCP, VoIP
asked by:
0 pts.

asked by:
0 pts.

asked by:
0 pts.

function to subtract 200 days from date
I need to write the filter condition in cognos as follows: YRMOSDOS between (&YRMOSDOS – 200) AND (&YRMOSDOS) where YRMOSDOS is in date form. How do I achieve it? The database is in db2. Decimal function does not work. Please help. Thanks a lot.

Answer Question   |  June 29, 2005  11:20 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, Development, MySQL, Software testing
asked by:
0 pts.

Removing spaces between two words in SQL
Hi, I have a table called employee and column called Name. The column Name contains (firstname lastname)i.e. firstname ‘space’ lastname. I want to retrieve just the firstname from the column Name for ALL the employees. I have tried using the function “substring” but since the firstname can be of VARIABLE length, I do not know [...]

Answer Question   |  April 26, 2005  4:40 PM
DataCenter, MySQL, Oracle, SQL Server
asked by:
0 pts.

- DB2 – RPG
My question has two parts: 1- Is there any way to create DB2 at a PC similar to what is exist at IBM I-Series AS/400? 2- Is there any RPG Compiler that I can install and run it and PC?

Answer Question   |  April 14, 2005  9:15 AM
Business Objects, CA Ingres, Cognos, Data analysis, Data Junction, Data mining/analysis, Data warehousing applications, Database Management Systems, Development, Hardware, IBM, Information Builders, Instant Messaging, Microsoft Access, Microsoft Windows, MySQL, Servers, Software
asked by:
0 pts.

Importing Data in SQL Server 2000. “Integrity violation error” in RowID column
Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in the Enterprise Manager. The textfile [...]

Answer Question   |  April 8, 2005  7:18 PM
Database Management Systems, MySQL, Oracle
asked by:
0 pts.

sqlserver 2000 stored procedures
Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

Answer Question   |  April 4, 2005  10:02 AM
ColdFusion, MySQL, SQL, SQL Server
asked by:
0 pts.

Accessing Linked Server in SQL Server 2000 (Urgent)
I have a server named say ‘SRVMAIN’. Using Enterprise Manager I added a linked server ‘LNKDSRVR1′ (existing server). I m able to access any database in ‘LNKDSRVR1′ by writing a query in query analyzer of ‘SRVMAIN’ as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as ‘linkedserver’. Again I added a linked server in [...]

Answer Question   |  March 24, 2005  10:47 PM
Administration, Availability, Backup & recovery, Biometrics, Digital certificates, Identity & Access Management, Migration, MySQL, Performance/Tuning, provisioning, Security, Security tokens, Servers, Single sign-on, SQL Server, SQL Server 2000, Standard Edition 2000, Tech support
asked by:
0 pts.

Free online practice exercises on SQL/Oracle
I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

Answer Question   |  April 17, 2013  9:47 AM
MySQL, Oracle, SQL Server
asked by:
0 pts.

SQL Server equivalent of Oracle’s desc tablename command
Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle’s desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular [...]

Answer Question   |  March 17, 2005  2:13 PM
Database Management Systems, MySQL, Oracle, SQL Server
asked by:
0 pts.