Hi everyone! I thought I would easily find a discussion on the internet about this subject but I didn’t find anything to really help me. I have many applications that need to share common tables. Think about an Employee table for example. I don’t want to have this table duplicated in each project’s database! With…

Hi, I’m having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message: Default options…

When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?

select  gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999)   This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and  ’G’ are constants…

I want to assign a serial number for the below data using the Access query or by using SQL for Access     DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211   I want the output like as below: S.noDateItems Sold12/1/201354622/1/201389715/1/201325625/1/2013103235/1/201378518/2/201365428/2/20131211   Can anyone help me?

Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?

I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether…

Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks for your help.

Before change: CLAIM_ID CR/RE   Internal TAT 11061488        Rebill 27 11061488        Credit  11061488 Credit  11062027 Rebill  34 11062027        Rebill  11071404 Credit  12 11071404        Credit            After change : CLAIM_ID CR/RE   Internal TAT 11061488        Rebill  11061488 Credit  27 11061488        Credit  11062027 Rebill  34 11062027        Rebill  11071404 Credit  12 11071404        Credit         condition : if Credit – Credit…

We have a Windows 2003 web server, a SQL database, and a Sonic Wall. The existing web server is to be replaced. We can see and log into our back office application on the new server when we are looking at local host but when we put it into the DMZ we cannot log into…

How to debug an SQL Stored Procedure?

I am trying to suppress a text field within a section by both field parameters being null and also by specific time frame. The formulas work independently just fine, but not when placed together. (isnull({DBA.POST})= false or isnull ({DBA.ANNUAL}) = false) and {DBA_DATE.Report_DATE} < DateTime (2012,11,04,00,00,00)

IKM online test questions SQL Server 2008.

This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.

I have a date parameter :ASOFDATE being entered as such: 01/01/2008. I would like the following to print out in my columns: 2008-09. The code I am using to attempt getting this is as follows: to_char(extract(year FROM to_date(:ASOFDATE, ‘DD-MM-YYYY’))) || ‘-’ || substr(extract(year FROM to_date(:ASOFDATE , ‘DD-MM-YYYY’) + 365), 3,2) The information that prints in…

We have an Intranet site that was set up in SharePoint 3.0. Over the weekend windows updates were installed, specifically KB2687442. Now my Intranet site does not work. When I try and run the SharePoint Products and Technologies Configuration Wizard it fails at step 9 with the following error : Failed to upgrade SharePoint Products…

I am new to MDS, client give me the mdm.udpValidateModel SP with @username etc. parameter. i don’t know i parsed first time or executed. I again executed. will there will be any side effect . please guide me urgently. urgent. SET @User_ID = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName ) SET @Version_ID…

Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.

How can I insert data from SQL procedure. I am using cursor.